text: CREATE TABLE trip (id VARCHAR, duration VARCHAR) -- What are the ids and durations of the trips with the top 3 durations? SELECT id, duration FROM trip ORDER BY duration DESC LIMIT 3 CREATE TABLE station (name VARCHAR, long VARCHAR, id VARCHAR); CREATE TABLE trip (duration INTEGER, start_station_id VARCHAR) -- For each station, return its longitude and the average duration of trips that started from the station. SELECT T1.name, T1.long, AVG(T2.duration) FROM station AS T1 JOIN trip AS T2 ON T1.id = T2.start_station_id GROUP BY T2.start_station_id CREATE TABLE trip (duration INTEGER, end_station_id VARCHAR); CREATE TABLE station (name VARCHAR, lat VARCHAR, id VARCHAR) -- For each station, find its latitude and the minimum duration of trips that ended at the station. SELECT T1.name, T1.lat, MIN(T2.duration) FROM station AS T1 JOIN trip AS T2 ON T1.id = T2.end_station_id GROUP BY T2.end_station_id CREATE TABLE trip (start_station_name VARCHAR, duration INTEGER) -- List all the distinct stations from which a trip of duration below 100 started. SELECT DISTINCT start_station_name FROM trip WHERE duration < 100 CREATE TABLE weather (zip_code VARCHAR, max_dew_point_f VARCHAR) -- Find all the zip codes in which the max dew point have never reached 70. SELECT DISTINCT zip_code FROM weather EXCEPT SELECT DISTINCT zip_code FROM weather WHERE max_dew_point_f >= 70 CREATE TABLE trip (id VARCHAR, duration INTEGER, zip_code VARCHAR) -- Find the id for the trips that lasted at least as long as the average duration of trips in zip code 94103. SELECT id FROM trip WHERE duration >= (SELECT AVG(duration) FROM trip WHERE zip_code = 94103)