CREATE TABLE weather (zip_code VARCHAR, mean_temperature_f INT)
CREATE TABLE trip (id VARCHAR, zip_code VARCHAR)

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") > 60