What is the pick number for the player(s) drafted in round 8?
CREATE TABLE table_name_31 (pick__number VARCHAR, round VARCHAR)
SELECT pick__number FROM table_name_31 WHERE round = "round 8"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_31 (pick__number VARCHAR, round VARCHAR) Question: What is the pick number for the player(s) drafted in round 8? [/INST] SELECT pick__number FROM table_name_31 WHERE round = "round 8" </s>