Show weather records from August.
select * from weather where date like "8/%"
Just show the mean temperature in those records.
select mean_temperature_f from weather where date like "8/%"
Group by zipcode and average those records.
select zip_code, avg(mean_temperature_f) from weather where date like "8/%" group by zip_code