Table: rangers_season_19
Columns: game
january
opponent
score
record

Question: What was the score when the Rangers were playing against the Vancouver Canucks?
SQL: SELECT "score" FROM rangers_season_19 WHERE "opponent" = 'vancouver canucks'

Question: Who were the opponents on January 27?
SQL: SELECT "opponent" FROM rangers_season_19 WHERE "january" = 27

Question: Who was the opponent for game number less than 47 and a record of 24-13-4?
SQL: SELECT "opponent" FROM rangers_season_19 WHERE "game" < 47 AND "record" = '24-13-4'

Question: What is the average january number when the game number was higher than 39 and the opponent was the Vancouver Canucks?
SQL: SELECT AVG("january") FROM rangers_season_19 WHERE "opponent" = 'vancouver canucks' AND "game" > 39