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