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
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
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 ) > value
Give me ids for all the trip that took place in a zip code area with average mean temperature above 60 .