What is Arkansas State's total pick number with an overal lower than 242?
CREATE TABLE table_name_96 (pick__number VARCHAR, college VARCHAR, overall VARCHAR)
SELECT COUNT(pick__number) FROM table_name_96 WHERE college = "arkansas state" AND overall < 242
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_96 (pick__number VARCHAR, college VARCHAR, overall VARCHAR) Question: What is Arkansas State's total pick number with an overal lower than 242? [/INST] SELECT COUNT(pick__number) FROM table_name_96 WHERE college = "arkansas state" AND overall < 242 </s>