user: ### NOW ANSWER:
Question: When the Vancouver Canucks were visiting, what was the record when the score was 4-2?
Columns: ['Date', 'Visitor', 'Score', 'Home', 'Record']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['October 7', 'Chicago Black Hawks', '6–4', 'St. Louis Blues', '1–0–0']
SQL:

assistant: SELECT "Record" FROM "Table" WHERE "Score" = '4-2' AND "Visitor" = 'Vancouver Canucks';