For each zip code, find the ids of all trips that have a higher 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
ids of all trips refers to T1.id; higher average mean temperature above 60 refers to HAVING AVG(T2.mean_temperature_f) > 60; for each zip code refers to GROUP BY T2.zip_code;