Table schema:
CREATE TABLE home_game (YEAR VARCHAR, attendance INTEGER)

Question: What is the average number of attendance at home games for each year?
SQL: SELECT YEAR, AVG(attendance) FROM home_game GROUP BY YEAR