Table: nhl_game_stats_7
Columns: date
visitor
score
home
decision
attendance
record

Question: What was the score of the game on November 9 when Atlanta was the visiting team?
SQL: SELECT "score" FROM nhl_game_stats_7 WHERE "visitor" = 'atlanta' AND "date" = 'november 9'

Question: What was the score of the home game at Tampa Bay?
SQL: SELECT "score" FROM nhl_game_stats_7 WHERE "home" = 'tampa bay'

Question: What was the date of the game where Ottawa was the home team and Atlanta is the visiting team?
SQL: SELECT "date" FROM nhl_game_stats_7 WHERE "visitor" = 'atlanta' AND "home" = 'ottawa'