Tell me the total number of picks for position of m of williams college
CREATE TABLE table_name_9 (pick__number VARCHAR, position VARCHAR, affiliation VARCHAR)
SELECT COUNT(pick__number) FROM table_name_9 WHERE position = "m" AND affiliation = "williams college"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_9 (pick__number VARCHAR, position VARCHAR, affiliation VARCHAR) Question: Tell me the total number of picks for position of m of williams college [/INST] SELECT COUNT(pick__number) FROM table_name_9 WHERE position = "m" AND affiliation = "williams college" </s>