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
SELECT zip_code  ,  avg(mean_temperature_f) FROM weather WHERE date LIKE "8/%" GROUP BY zip_code
[{'zip_code': 94041, 'avg(mean_temperature_f)': 69.92307692307692}, {'zip_code': 94063, 'avg(mean_temperature_f)': 69.15384615384616}, {'zip_code': 94107, 'avg(mean_temperature_f)': 67.8923076923077}, {'zip_code': 94301, 'avg(mean_temperature_f)': 69.03076923076924}, {'zip_code': 95113, 'avg(mean_temperature_f)': 70.73846153846154}]