Table: game_stats_7
Columns: week
date
opponent
result
attendance

Question: What week was October 29, 2000?
SQL: SELECT COUNT("week") FROM game_stats_7 WHERE "date" = 'october 29, 2000'

Question: Who was the opponent on December 10, 2000?
SQL: SELECT "opponent" FROM game_stats_7 WHERE "date" = 'december 10, 2000'

Question: Who was the opponent on the game with a 65,569 attendance before week 12?
SQL: SELECT "opponent" FROM game_stats_7 WHERE "week" < 12 AND "attendance" = '65,569'

Question: What week was September 24, 2000 on?
SQL: SELECT SUM("week") FROM game_stats_7 WHERE "date" = 'september 24, 2000'