Table: raptors_game_stats_31
Columns: game
date
team
score
high_points
high_rebounds
high_assists
location_attendance
record

Question: What was the record of the game played on November 7?
SQL: SELECT "record" FROM raptors_game_stats_31 WHERE "game" < 7 AND "date" = 'november 7'

Question: What was the game number of the game played against Charlotte?
SQL: SELECT COUNT("game") FROM raptors_game_stats_31 WHERE "team" = 'charlotte'