
CREATE TABLE station (
	id INTEGER, 
	name TEXT, 
	lat NUMERIC, 
	long NUMERIC, 
	dock_count INTEGER, 
	city TEXT, 
	installation_date TEXT, 
	PRIMARY KEY (id)
)


CREATE TABLE status (
	station_id INTEGER, 
	bikes_available INTEGER, 
	docks_available INTEGER, 
	time TEXT, 
	FOREIGN KEY(station_id) REFERENCES station (id)
)


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


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

CREATE TABLE station (
	id INTEGER, 
	name TEXT, 
	lat NUMERIC, 
	long NUMERIC, 
	dock_count INTEGER, 
	city TEXT, 
	installation_date TEXT, 
	PRIMARY KEY (id)
)

/*
2 rows from station table:
id	name	lat	long	dock_count	city	installation_date
2	San Jose Diridon Caltrain Station	37.3297320000	-121.9017820000	27	San Jose	8/6/2013
3	San Jose Civic Center	37.3306980000	-121.8889790000	15	San Jose	8/5/2013
*/


CREATE TABLE status (
	station_id INTEGER, 
	bikes_available INTEGER, 
	docks_available INTEGER, 
	time TEXT, 
	FOREIGN KEY(station_id) REFERENCES station (id)
)

/*
2 rows from status table:
station_id	bikes_available	docks_available	time
3	12	3	2015-06-02 12:46:02
3	12	3	2015-06-02 12:47:02
*/


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

/*
2 rows from trip table:
id	duration	start_date	start_station_name	start_station_id	end_date	end_station_name	end_station_id	bike_id	subscription_type	zip_code
900504	384	8/21/2015 17:03	Howard at 2nd	63	8/21/2015 17:10	San Francisco Caltrain 2 (330 Townsend)	69	454	Subscriber	94041
900505	588	8/21/2015 17:03	South Van Ness at Market	66	8/21/2015 17:13	San Francisco Caltrain 2 (330 Townsend)	69	574	Subscriber	95119
*/


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

/*
2 rows from weather table:
date	max_temperature_f	mean_temperature_f	min_temperature_f	max_dew_point_f	mean_dew_point_f	min_dew_point_f	max_humidity	mean_humidity	min_humidity	max_sea_level_pressure_inches	mean_sea_level_pressure_inches	min_sea_level_pressure_inches	max_visibility_miles	mean_visibility_miles	min_visibility_miles	max_wind_Speed_mph	mean_wind_speed_mph	max_gust_speed_mph	precipitation_inches	cloud_cover	events	wind_dir_degrees	zip_code
8/29/2013	74	68	61	61	58	56	93	75	57	30.0700000000	30.0200000000	29.9700000000	10	10	10	23	11	28	0	4		286	94107
8/30/2013	78	69	60	61	58	56	90	70	50	30.0500000000	30.0000000000	29.9300000000	10	10	7	29	13	35	0	2		291	94107
*/
What are the names of stations that have latitude lower than 37.5?
SELECT name FROM station WHERE lat  <  37.5
[{'name': 'San Jose Diridon Caltrain Station'}, {'name': 'San Jose Civic Center'}, {'name': 'Santa Clara at Almaden'}, {'name': 'Adobe on Almaden'}, {'name': 'San Pedro Square'}, {'name': 'Paseo de San Antonio'}, {'name': 'San Salvador at 1st'}, {'name': 'Japantown'}, {'name': 'San Jose City Hall'}, {'name': 'MLK Library'}, {'name': 'SJSU 4th at San Carlos'}, {'name': 'St James Park'}, {'name': 'Arena Green / SAP Center'}, {'name': 'SJSU - San Salvador at 9th'}, {'name': 'Franklin at Maple'}, {'name': 'Redwood City Caltrain Station'}, {'name': 'San Mateo County Center'}, {'name': 'Redwood City Public Library'}, {'name': 'Stanford in Redwood City'}, {'name': 'Redwood City Medical Center'}, {'name': 'Mountain View City Hall'}, {'name': 'Mountain View Caltrain Station'}, {'name': 'San Antonio Caltrain Station'}, {'name': 'Evelyn Park and Ride'}, {'name': 'San Antonio Shopping Center'}, {'name': 'Castro Street and El Camino Real'}, {'name': 'Rengstorff Avenue / California Street'}, {'name': 'Palo Alto Caltrain Station'}, {'name': 'University and Emerson'}, {'name': 'California Ave Caltrain Station'}, {'name': 'Cowper at University'}, {'name': 'Park at Olive'}, {'name': 'Santa Clara County Civic Center'}, {'name': 'Mezes Park'}, {'name': 'Ryland Park'}]