Task: Text to Code
Input (English): SQL: SELECT start_date FROM trip WHERE duration > 384 AND duration > 60
Feedback: Replace start date with id , duration with average mean temperature of weather , include zip code and omit last part .
Output (English): 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