What is the average high temperature for each day of week?
SELECT avg(high_temperature) ,  day_of_week FROM weekly_weather GROUP BY day_of_week
SELECT avg(high_temperature) ,  day_of_week FROM weekly_weather GROUP BY day_of_week
[{'avg(high_temperature)': 55.0, 'day_of_week': 'Friday'}, {'avg(high_temperature)': 56.0, 'day_of_week': 'Monday'}, {'avg(high_temperature)': 55.0, 'day_of_week': 'Saturday'}, {'avg(high_temperature)': 54.0, 'day_of_week': 'Sunday'}, {'avg(high_temperature)': 57.0, 'day_of_week': 'Thursday'}, {'avg(high_temperature)': 58.0, 'day_of_week': 'Tuesday'}, {'avg(high_temperature)': 58.0, 'day_of_week': 'Wednesday'}]