Name the pick for matthew scorsune
CREATE TABLE table_2840500_8 (pick VARCHAR, player VARCHAR)
SELECT pick FROM table_2840500_8 WHERE player = "Matthew Scorsune"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2840500_8 (pick VARCHAR, player VARCHAR) Question: Name the pick for matthew scorsune [/INST] SELECT pick FROM table_2840500_8 WHERE player = "Matthew Scorsune" </s>