Position of defensive tackle, and a Round of 4, and a Pick # smaller than 36 has what overall average?
CREATE TABLE table_name_47 (overall INTEGER, pick__number VARCHAR, position VARCHAR, round VARCHAR)
SELECT AVG(overall) FROM table_name_47 WHERE position = "defensive tackle" AND round = 4 AND pick__number < 36
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (overall INTEGER, pick__number VARCHAR, position VARCHAR, round VARCHAR) Question: Position of defensive tackle, and a Round of 4, and a Pick # smaller than 36 has what overall average? [/INST] SELECT AVG(overall) FROM table_name_47 WHERE position = "defensive tackle" AND round = 4 AND pick__number < 36 </s>