user: ### NOW ANSWER:
Question: What is the name of the Player that shows the NHL team of New York Rangers, and a Pick # of 31?
Columns: ['Pick #', 'Player', 'Position', 'Nationality', 'NHL team', 'College/junior/club team']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['17', 'Lorne Henning', 'Centre', 'Canada', 'New York Islanders', 'New Westminster Bruins (WCHL)']
SQL:

assistant: SELECT "Player" FROM "Table" WHERE "NHL team" = 'New York Rangers' AND "Pick #" = '31';