Which average Against has Points of 6, and a Played smaller than 9?
CREATE TABLE table_name_65 (against INTEGER, points VARCHAR, played VARCHAR)
SELECT AVG(against) FROM table_name_65 WHERE points = 6 AND played < 9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_65 (against INTEGER, points VARCHAR, played VARCHAR) Question: Which average Against has Points of 6, and a Played smaller than 9? [/INST] SELECT AVG(against) FROM table_name_65 WHERE points = 6 AND played < 9 </s>