What is the average high temperature for each day of week?
create table weekly_weather (day_of_week varchar, high_temperature integer, PRIMARY KEY (day_of_week))
select avg(high_temperature), day_of_week from weekly_weather group by day_of_week