What is the average high temperature for each day of week?
CREATE TABLE weekly_weather (day_of_week VARCHAR, high_temperature INTEGER)
SELECT AVG(high_temperature), day_of_week FROM weekly_weather GROUP BY day_of_week
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE weekly_weather (day_of_week VARCHAR, high_temperature INTEGER) Question: What is the average high temperature for each day of week? [/INST] SELECT AVG(high_temperature), day_of_week FROM weekly_weather GROUP BY day_of_week </s>