WHAT IS THE TOTAL PICK FOR BOSTON COLLEGE?
CREATE TABLE table_name_32 (pick VARCHAR, college VARCHAR)
SELECT COUNT(pick) FROM table_name_32 WHERE college = "boston college"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_32 (pick VARCHAR, college VARCHAR) Question: WHAT IS THE TOTAL PICK FOR BOSTON COLLEGE? [/INST] SELECT COUNT(pick) FROM table_name_32 WHERE college = "boston college" </s>