Table: game_stats_9
Columns: week
date
opponent
result
venue
attendance

Question: What is the average attendance at a week 4 game?
SQL: SELECT AVG("attendance") FROM game_stats_9 WHERE "week" = 4

Question: What venue held that game with a result of l 24–14?
SQL: SELECT "venue" FROM game_stats_9 WHERE "result" = 'l 24–14'