How many Picks have a College of hawaii, and an Overall smaller than 122?
CREATE TABLE table_name_51 (pick VARCHAR, college VARCHAR, overall VARCHAR)
SELECT COUNT(pick) FROM table_name_51 WHERE college = "hawaii" AND overall < 122
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_51 (pick VARCHAR, college VARCHAR, overall VARCHAR) Question: How many Picks have a College of hawaii, and an Overall smaller than 122? [/INST] SELECT COUNT(pick) FROM table_name_51 WHERE college = "hawaii" AND overall < 122 </s>