Give zip codes from trips.
select distinct zip_code from trip
Which zip codes had an average mean temperature greater than 60?
select zip_code from weather group by zip_code having avg(mean_temperature_f) > 60
Give me ids for all the trip that took place in a zip code area with average mean temperature above 60.
select t1.id from trip as t1 join weather as t2 on t1.zip_code = t2.zip_code group by t2.zip_code having avg(t2.mean_temperature_f) > 60