Who was drafted to the Vancouver Canucks?
CREATE TABLE table_2897457_8 (player VARCHAR, nhl_team VARCHAR)
SELECT player FROM table_2897457_8 WHERE nhl_team = "Vancouver Canucks"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2897457_8 (player VARCHAR, nhl_team VARCHAR) Question: Who was drafted to the Vancouver Canucks? [/INST] SELECT player FROM table_2897457_8 WHERE nhl_team = "Vancouver Canucks" </s>