What's the average draft pick number from Carson-Newman College before Round 7?
CREATE TABLE table_name_21 (pick__number INTEGER, college VARCHAR, round VARCHAR)
SELECT AVG(pick__number) FROM table_name_21 WHERE college = "carson-newman" AND round < 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_21 (pick__number INTEGER, college VARCHAR, round VARCHAR) Question: What's the average draft pick number from Carson-Newman College before Round 7? [/INST] SELECT AVG(pick__number) FROM table_name_21 WHERE college = "carson-newman" AND round < 7 </s>