Table: nfl_game_stats_2
Columns: week
date
opponent
result
attendance

Question: Who was the Opponent in Week 7?
SQL: SELECT "opponent" FROM nfl_game_stats_2 WHERE "week" = 7

Question: What was the Attendance on November 7, 1999?
SQL: SELECT "attendance" FROM nfl_game_stats_2 WHERE "date" = 'november 7, 1999'

Question: Who was the Opponent of the Game with a Result of l 23-41?
SQL: SELECT "opponent" FROM nfl_game_stats_2 WHERE "result" = 'l 23-41'

Question: What was the Attendance in Week 1?
SQL: SELECT "attendance" FROM nfl_game_stats_2 WHERE "week" = 1