CREATE TABLE trip (id INT, duration INT, start_date TEXT, start_station_name TEXT, start_station_id INT, end_date TEXT, end_station_name TEXT, end_station_id INT, bike_id INT, subscription_type TEXT, zip_code INT)
CREATE TABLE status (station_id INT, bikes_available INT, docks_available INT, time TEXT)
CREATE TABLE weather (date TEXT, max_temperature_f INT, mean_temperature_f INT, min_temperature_f INT, max_dew_point_f INT, mean_dew_point_f INT, min_dew_point_f INT, max_humidity INT, mean_humidity INT, min_humidity INT, max_sea_level_pressure_inches DECIMAL, mean_sea_level_pressure_inches DECIMAL, min_sea_level_pressure_inches DECIMAL, max_visibility_miles INT, mean_visibility_miles INT, min_visibility_miles INT, max_wind_Speed_mph INT, mean_wind_speed_mph INT, max_gust_speed_mph INT, precipitation_inches INT, cloud_cover INT, events TEXT, wind_dir_degrees INT, zip_code INT)
CREATE TABLE station (id INT, name TEXT, lat DECIMAL, long DECIMAL, dock_count INT, city TEXT, installation_date TEXT)

For the top 3 days with the largest max gust speeds, please bin the date into the day of the week and then sum the mean temperature for a bar chart.
SELECT date, SUM(mean_temperature_f) FROM weather ORDER BY max_gust_speed_mph DESC LIMIT 3
SELECT "date", SUM("mean_temperature_f") FROM "weather" ORDER BY "max_gust_speed_mph" DESC NULLS LAST LIMIT 3