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