How many Picks have an Overall smaller than 304, and a Position of g, and a Round smaller than 11?
CREATE TABLE table_name_86 (pick VARCHAR, round VARCHAR, overall VARCHAR, position VARCHAR)
SELECT COUNT(pick) FROM table_name_86 WHERE overall < 304 AND position = "g" AND round < 11
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_86 (pick VARCHAR, round VARCHAR, overall VARCHAR, position VARCHAR) Question: How many Picks have an Overall smaller than 304, and a Position of g, and a Round smaller than 11? [/INST] SELECT COUNT(pick) FROM table_name_86 WHERE overall < 304 AND position = "g" AND round < 11 </s>