Which Player has a Draft of 1994, a Pick larger than 8, a Round of 10, and a Nationality of canada?
CREATE TABLE table_name_89 (player VARCHAR, nationality VARCHAR, round VARCHAR, draft VARCHAR, pick VARCHAR)
SELECT player FROM table_name_89 WHERE draft = 1994 AND pick > 8 AND round = "10" AND nationality = "canada"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_89 (player VARCHAR, nationality VARCHAR, round VARCHAR, draft VARCHAR, pick VARCHAR) Question: Which Player has a Draft of 1994, a Pick larger than 8, a Round of 10, and a Nationality of canada? [/INST] SELECT player FROM table_name_89 WHERE draft = 1994 AND pick > 8 AND round = "10" AND nationality = "canada" </s>