Which Goals Against has a Drawn larger than 9, a Lost larger than 15, a Position of 24, and a Played smaller than 46?
CREATE TABLE table_name_50 (goals_against INTEGER, played VARCHAR, position VARCHAR, drawn VARCHAR, lost VARCHAR)
SELECT AVG(goals_against) FROM table_name_50 WHERE drawn > 9 AND lost > 15 AND position = 24 AND played < 46
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_50 (goals_against INTEGER, played VARCHAR, position VARCHAR, drawn VARCHAR, lost VARCHAR) Question: Which Goals Against has a Drawn larger than 9, a Lost larger than 15, a Position of 24, and a Played smaller than 46? [/INST] SELECT AVG(goals_against) FROM table_name_50 WHERE drawn > 9 AND lost > 15 AND position = 24 AND played < 46 </s>