text: CREATE TABLE trip (id VARCHAR, zip_code VARCHAR); CREATE TABLE weather (zip_code VARCHAR, mean_temperature_f INTEGER) -- Give me ids for all the trip that took place in a zip code area with average mean temperature above 60. SELECT T1.id FROM trip AS T1 JOIN weather AS T2 ON T1.zip_code = T2.zip_code GROUP BY T2.zip_code HAVING AVG(T2.mean_temperature_f) > 60 CREATE TABLE weather (zip_code VARCHAR, max_wind_Speed_mph VARCHAR) -- For each zip code, return how many times max wind speed reached 25? SELECT zip_code, COUNT(*) FROM weather WHERE max_wind_Speed_mph >= 25 GROUP BY zip_code CREATE TABLE weather (date VARCHAR, zip_code VARCHAR, min_dew_point_f INTEGER) -- On which day and in which zip code was the min dew point lower than any day in zip code 94107? SELECT date, zip_code FROM weather WHERE min_dew_point_f < (SELECT MIN(min_dew_point_f) FROM weather WHERE zip_code = 94107) CREATE TABLE station (installation_date VARCHAR, id VARCHAR); CREATE TABLE trip (id VARCHAR, end_station_id VARCHAR) -- For each trip, return its ending station's installation date. SELECT T1.id, T2.installation_date FROM trip AS T1 JOIN station AS T2 ON T1.end_station_id = T2.id CREATE TABLE trip (id VARCHAR, start_station_id VARCHAR); CREATE TABLE station (id VARCHAR, dock_count VARCHAR) -- Which trip started from the station with the largest dock count? Give me the trip id. SELECT T1.id FROM trip AS T1 JOIN station AS T2 ON T1.start_station_id = T2.id ORDER BY T2.dock_count DESC LIMIT 1