What is the name of the Player that shows the NHL team of new york rangers, and a Pick # of 31?
CREATE TABLE table_name_22 (player VARCHAR, nhl_team VARCHAR, pick__number VARCHAR)
SELECT player FROM table_name_22 WHERE nhl_team = "new york rangers" AND pick__number = "31"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_22 (player VARCHAR, nhl_team VARCHAR, pick__number VARCHAR) Question: What is the name of the Player that shows the NHL team of new york rangers, and a Pick # of 31? [/INST] SELECT player FROM table_name_22 WHERE nhl_team = "new york rangers" AND pick__number = "31" </s>