What's the overall average that has a round less than 7, and a Pick # of 4?
CREATE TABLE table_name_63 (overall INTEGER, round VARCHAR, pick__number VARCHAR)
SELECT AVG(overall) FROM table_name_63 WHERE round < 7 AND pick__number = 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_63 (overall INTEGER, round VARCHAR, pick__number VARCHAR) Question: What's the overall average that has a round less than 7, and a Pick # of 4? [/INST] SELECT AVG(overall) FROM table_name_63 WHERE round < 7 AND pick__number = 4 </s>