what is the average points when position is more than 5 and played is less than 10?
CREATE TABLE table_name_55 (points INTEGER, position VARCHAR, played VARCHAR)
SELECT AVG(points) FROM table_name_55 WHERE position > 5 AND played < 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_55 (points INTEGER, position VARCHAR, played VARCHAR) Question: what is the average points when position is more than 5 and played is less than 10? [/INST] SELECT AVG(points) FROM table_name_55 WHERE position > 5 AND played < 10 </s>