Schema: CREATE TABLE table_name_74 (attendance INTEGER, week VARCHAR)
Question: In week 7, what was the average attendance?
SQL: SELECT AVG(attendance) FROM table_name_74 WHERE week = 7