CREATE TABLE weekly_weather (day_of_week VARCHAR, high_temperature INT)

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"