Schema: CREATE TABLE weekly_weather (day_of_week VARCHAR, high_temperature INTEGER)
Question: What is the average high temperature for each day of week?
SQL: SELECT AVG(high_temperature), day_of_week FROM weekly_weather GROUP BY day_of_week