Task: Text to Code
Input (English): SQL: SELECT Avg ( duration ) , start_date FROM trip GROUP BY zip_code
Feedback: Replace trip table with weather table and duration with mean temperature f , Make sure specific for august .
Output (English): SELECT zip_code  ,  avg(mean_temperature_f) FROM weather WHERE date LIKE "8/%" GROUP BY zip_code