Which Round has a College of appalachian state, and an Overall smaller than 156?
CREATE TABLE table_name_64 (round VARCHAR, college VARCHAR, overall VARCHAR)
SELECT COUNT(round) FROM table_name_64 WHERE college = "appalachian state" AND overall < 156
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_64 (round VARCHAR, college VARCHAR, overall VARCHAR) Question: Which Round has a College of appalachian state, and an Overall smaller than 156? [/INST] SELECT COUNT(round) FROM table_name_64 WHERE college = "appalachian state" AND overall < 156 </s>