Which Drawn is the average one that has a Position smaller than 9, and Points smaller than 22, and a Lost smaller than 9, and an Against larger than 29?
CREATE TABLE table_name_76 (drawn INTEGER, against VARCHAR, lost VARCHAR, position VARCHAR, points VARCHAR)
SELECT AVG(drawn) FROM table_name_76 WHERE position < 9 AND points < 22 AND lost < 9 AND against > 29
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_76 (drawn INTEGER, against VARCHAR, lost VARCHAR, position VARCHAR, points VARCHAR) Question: Which Drawn is the average one that has a Position smaller than 9, and Points smaller than 22, and a Lost smaller than 9, and an Against larger than 29? [/INST] SELECT AVG(drawn) FROM table_name_76 WHERE position < 9 AND points < 22 AND lost < 9 AND against > 29 </s>