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