Name the average goal difference for draw of 7 and played more than 18
CREATE TABLE table_name_2 (goal_difference INTEGER, draw VARCHAR, played VARCHAR)
SELECT AVG(goal_difference) FROM table_name_2 WHERE draw = 7 AND played > 18
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (goal_difference INTEGER, draw VARCHAR, played VARCHAR) Question: Name the average goal difference for draw of 7 and played more than 18 [/INST] SELECT AVG(goal_difference) FROM table_name_2 WHERE draw = 7 AND played > 18 </s>