
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 are located in Palo Alto city but have never been the ending point of trips more than 100 times?
SELECT name FROM station WHERE city  =  "Palo Alto" EXCEPT SELECT end_station_name FROM trip GROUP BY end_station_name HAVING count(*)  >  100
[{'name': 'California Ave Caltrain Station'}, {'name': 'Cowper at University'}, {'name': 'Palo Alto Caltrain Station'}, {'name': 'Park at Olive'}, {'name': 'University and Emerson'}]