What is the average number of attendance at home games for each year?
CREATE TABLE home_game (YEAR VARCHAR, attendance INTEGER)
SELECT YEAR, AVG(attendance) FROM home_game GROUP BY YEAR
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE home_game (YEAR VARCHAR, attendance INTEGER) Question: What is the average number of attendance at home games for each year? [/INST] SELECT YEAR, AVG(attendance) FROM home_game GROUP BY YEAR </s>