What is the average overall that has a pick less than 20, North Carolina as the college, with a round less than 8?
CREATE TABLE table_name_69 (overall INTEGER, round VARCHAR, pick VARCHAR, college VARCHAR)
SELECT AVG(overall) FROM table_name_69 WHERE pick < 20 AND college = "north carolina" AND round < 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_69 (overall INTEGER, round VARCHAR, pick VARCHAR, college VARCHAR) Question: What is the average overall that has a pick less than 20, North Carolina as the college, with a round less than 8? [/INST] SELECT AVG(overall) FROM table_name_69 WHERE pick < 20 AND college = "north carolina" AND round < 8 </s>