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
### Context: CREATE TABLE home_game (YEAR VARCHAR, attendance INTEGER) ### Question: What is the average number of attendance at home games for each year? ### Answer: SELECT YEAR, AVG(attendance) FROM home_game GROUP BY YEAR