text: CREATE TABLE trip (duration INTEGER, bike_id VARCHAR) -- What is the total and maximum duration of trips with bike id 636? SELECT SUM(duration), MAX(duration) FROM trip WHERE bike_id = 636 CREATE TABLE weather (zip_code VARCHAR, mean_temperature_f INTEGER, date VARCHAR) -- For each zip code, return the average mean temperature of August there. SELECT zip_code, AVG(mean_temperature_f) FROM weather WHERE date LIKE "8/%" GROUP BY zip_code CREATE TABLE trip (bike_id VARCHAR) -- From the trip record, find the number of unique bikes. SELECT COUNT(DISTINCT bike_id) FROM trip CREATE TABLE station (city VARCHAR) -- What is the number of distinct cities the stations are located at? SELECT COUNT(DISTINCT city) FROM station CREATE TABLE station (city VARCHAR) -- How many stations does Mountain View city has? SELECT COUNT(*) FROM station WHERE city = "Mountain View" CREATE TABLE station (name VARCHAR, id VARCHAR); CREATE TABLE status (station_id VARCHAR, bikes_available VARCHAR) -- Return the unique name for stations that have ever had 7 bikes available. SELECT DISTINCT T1.name FROM station AS T1 JOIN status AS T2 ON T1.id = T2.station_id WHERE T2.bikes_available = 7 CREATE TABLE trip (start_station_name VARCHAR, start_station_id VARCHAR, start_date VARCHAR) -- Which start station had the most trips starting from August? Give me the name and id of the station. SELECT start_station_name, start_station_id FROM trip WHERE start_date LIKE "8/%" GROUP BY start_station_name ORDER BY COUNT(*) DESC LIMIT 1