What are the average number of played with goals of less than 43, more than 9 draws, a higher position than 17 and 30-8 points?
CREATE TABLE table_name_64 (played INTEGER, points VARCHAR, position VARCHAR, goals_for VARCHAR, draws VARCHAR)
SELECT AVG(played) FROM table_name_64 WHERE goals_for < 43 AND draws > 9 AND position > 17 AND points = "30-8"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_64 (played INTEGER, points VARCHAR, position VARCHAR, goals_for VARCHAR, draws VARCHAR) Question: What are the average number of played with goals of less than 43, more than 9 draws, a higher position than 17 and 30-8 points? [/INST] SELECT AVG(played) FROM table_name_64 WHERE goals_for < 43 AND draws > 9 AND position > 17 AND points = "30-8" </s>