What is the total overall for the pick that went before round 4, who went to Tennessee for college, and was picked at a number bigger than 9?
CREATE TABLE table_name_60 (overall INTEGER, pick__number VARCHAR, round VARCHAR, college VARCHAR)
SELECT SUM(overall) FROM table_name_60 WHERE round < 4 AND college = "tennessee" AND pick__number > 9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_60 (overall INTEGER, pick__number VARCHAR, round VARCHAR, college VARCHAR) Question: What is the total overall for the pick that went before round 4, who went to Tennessee for college, and was picked at a number bigger than 9? [/INST] SELECT SUM(overall) FROM table_name_60 WHERE round < 4 AND college = "tennessee" AND pick__number > 9 </s>