What is the average number of draws that has a played entry of less than 30 and a goal difference greater than 2?
CREATE TABLE table_name_9 (draws INTEGER, goal_difference VARCHAR, played VARCHAR)
SELECT AVG(draws) FROM table_name_9 WHERE goal_difference > 2 AND played < 30
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_9 (draws INTEGER, goal_difference VARCHAR, played VARCHAR) Question: What is the average number of draws that has a played entry of less than 30 and a goal difference greater than 2? [/INST] SELECT AVG(draws) FROM table_name_9 WHERE goal_difference > 2 AND played < 30 </s>