Table: hockey_game_results_6
Columns: date
visitor
score
home
record

Question: What team was home, when the record was 24–16–6?
SQL: SELECT "home" FROM hockey_game_results_6 WHERE "record" = '24–16–6'

Question: What date was the visitor the Boston Bruins, and the record was 4–0–1?
SQL: SELECT "date" FROM hockey_game_results_6 WHERE "visitor" = 'boston bruins' AND "record" = '4–0–1'