Table: leafs_game_stats_5
Columns: game
date
opponent
score
location
attendance
record
points

Question: What is Location, when Game is 42?
SQL: SELECT "location" FROM leafs_game_stats_5 WHERE "game" = 42

Question: What is Date, when Opponent is @ Carolina Hurricanes?
SQL: SELECT "date" FROM leafs_game_stats_5 WHERE "opponent" = '@ carolina hurricanes'

Question: What is the average Attendance, when Opponent is @ Philadelphia Flyers, and when Game is less than 42?
SQL: SELECT AVG("attendance") FROM leafs_game_stats_5 WHERE "opponent" = '@ philadelphia flyers' AND "game" < 42