What is the average points with less than 30 played?
CREATE TABLE table_name_77 (points INTEGER, played INTEGER)
SELECT AVG(points) FROM table_name_77 WHERE played < 30
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_77 (points INTEGER, played INTEGER) Question: What is the average points with less than 30 played? [/INST] SELECT AVG(points) FROM table_name_77 WHERE played < 30 </s>