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