For each zip code, return the average mean temperature of August there.
SELECT zip_code  ,  avg(mean_temperature_f) FROM weather WHERE date LIKE "8/%" GROUP BY zip_code
average mean temperature of August = AVG(mean_temperature_f) WHERE date includes August; for each zip code refers to GROUP BY zip_code;