text: CREATE TABLE weather (date VARCHAR, mean_sea_level_pressure_inches INTEGER) -- What are the dates in which the mean sea level pressure was between 30.3 and 31? SELECT date FROM weather WHERE mean_sea_level_pressure_inches BETWEEN 30.3 AND 31 CREATE TABLE weather (date VARCHAR, max_temperature_f VARCHAR, min_temperature_f VARCHAR) -- Find the day in which the difference between the max temperature and min temperature was the smallest. Also report the difference. SELECT date, max_temperature_f - min_temperature_f FROM weather ORDER BY max_temperature_f - min_temperature_f LIMIT 1 CREATE TABLE station (id VARCHAR, name VARCHAR); CREATE TABLE status (station_id VARCHAR, bikes_available INTEGER) -- What are the id and name of the stations that have ever had more than 12 bikes available? SELECT DISTINCT T1.id, T1.name FROM station AS T1 JOIN status AS T2 ON T1.id = T2.station_id WHERE T2.bikes_available > 12 CREATE TABLE weather (zip_code VARCHAR, mean_humidity INTEGER); CREATE TABLE trip (zip_code VARCHAR, mean_humidity INTEGER) -- Give me the zip code where the average mean humidity is below 70 and at least 100 trips took place. SELECT zip_code FROM weather GROUP BY zip_code HAVING AVG(mean_humidity) < 70 INTERSECT SELECT zip_code FROM trip GROUP BY zip_code HAVING COUNT(*) >= 100 CREATE TABLE trip (name VARCHAR, end_station_name VARCHAR, city VARCHAR); CREATE TABLE station (name VARCHAR, end_station_name VARCHAR, city VARCHAR) -- 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