HOW MANY ROUNDS HAD A PICK OF 7?
CREATE TABLE table_name_11 (round VARCHAR, pick VARCHAR)
SELECT COUNT(round) FROM table_name_11 WHERE pick = "7"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_11 (round VARCHAR, pick VARCHAR) Question: HOW MANY ROUNDS HAD A PICK OF 7? [/INST] SELECT COUNT(round) FROM table_name_11 WHERE pick = "7" </s>