### Database Schema:
CREATE TABLE status (
	station_id	INTEGER	NULL,
	bikes_available	INTEGER	NULL,
	docks_available	INTEGER	NULL,
	time	TEXT	NULL
);

CREATE TABLE station (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	name	TEXT	NULL,
	lat	REAL	NULL,
	long	REAL	NULL,
	dock_count	INTEGER	NULL,
	city	TEXT	NULL,
	installation_date	TEXT	NULL
);

CREATE TABLE weather (
	date	TEXT	NULL,
	max_temperature_f	INTEGER	NULL,
	mean_temperature_f	INTEGER	NULL,
	min_temperature_f	INTEGER	NULL,
	max_dew_point_f	INTEGER	NULL,
	mean_dew_point_f	INTEGER	NULL,
	min_dew_point_f	INTEGER	NULL,
	max_humidity	INTEGER	NULL,
	mean_humidity	INTEGER	NULL,
	min_humidity	INTEGER	NULL,
	max_sea_level_pressure_inches	REAL	NULL,
	mean_sea_level_pressure_inches	REAL	NULL,
	min_sea_level_pressure_inches	REAL	NULL,
	max_visibility_miles	INTEGER	NULL,
	mean_visibility_miles	INTEGER	NULL,
	min_visibility_miles	INTEGER	NULL,
	max_wind_Speed_mph	INTEGER	NULL,
	mean_wind_speed_mph	INTEGER	NULL,
	max_gust_speed_mph	INTEGER	NULL,
	precipitation_inches	TEXT	NULL,
	cloud_cover	INTEGER	NULL,
	events	TEXT	NULL,
	wind_dir_degrees	INTEGER	NULL,
	zip_code	TEXT	NULL
);

CREATE TABLE trip (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	duration	INTEGER	NULL,
	start_date	TEXT	NULL,
	start_station_name	TEXT	NULL,
	start_station_id	INTEGER	NULL,
	end_date	TEXT	NULL,
	end_station_name	TEXT	NULL,
	end_station_id	INTEGER	NULL,
	bike_id	INTEGER	NULL,
	subscription_type	TEXT	NULL,
	zip_code	INTEGER	NULL
);

### User's Query:
Find the longest ride on foggy day. What were the mean visibility, mean wind speed, and weather event during that ride? Also, list the coordinates and names of the start and end stations.

### Extra Knowledge:
foggy day refers to events = 'fog'; longest ride on a foggy day refers to MAX(duration) where events = 'fog'; mean visibility refers to mean_visibility_miles; mean wind speed refers to mean_wind_speed_mph; weather event refers to events; coordinates refers to (lat, long); start station refers to start_station_id; end station refers to end_station_id;
SELECT T3.mean_visibility_miles, T3.mean_wind_speed_mph, T3.events, T1.lat, T1.long , T2.start_station_name, T2.end_station_name FROM station AS T1 INNER JOIN trip AS T2 ON T2.start_station_name = T1.name INNER JOIN weather AS T3 ON T3.zip_code = T2.zip_code WHERE T3.events = 'Fog' ORDER BY T2.duration DESC LIMIT 1