What is Aundray Bruce's Pick #?
CREATE TABLE table_name_8 (pick__number VARCHAR, name VARCHAR)
SELECT pick__number FROM table_name_8 WHERE name = "aundray bruce"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (pick__number VARCHAR, name VARCHAR) Question: What is Aundray Bruce's Pick #? [/INST] SELECT pick__number FROM table_name_8 WHERE name = "aundray bruce" </s>