Which dates had the largest max gust speed?
select date from weather order by max_gust_speed_mph desc limit 1
Also give mean temperature and mean humidity.
select date, mean_temperature_f, mean_humidity from weather order by max_gust_speed_mph desc limit 1
Give the top 3 days instead.
select date, mean_temperature_f, mean_humidity from weather order by max_gust_speed_mph desc limit 3