Name the average goals conceded with draw bigger than 7 and goals scored more than 24
CREATE TABLE table_name_26 (goals_conceded INTEGER, draw VARCHAR, goals_scored VARCHAR)
SELECT AVG(goals_conceded) FROM table_name_26 WHERE draw > 7 AND goals_scored > 24
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_26 (goals_conceded INTEGER, draw VARCHAR, goals_scored VARCHAR) Question: Name the average goals conceded with draw bigger than 7 and goals scored more than 24 [/INST] SELECT AVG(goals_conceded) FROM table_name_26 WHERE draw > 7 AND goals_scored > 24 </s>