What's the draw that's played less than 36 and has 42 points?
CREATE TABLE table_name_15 (draw INTEGER, points VARCHAR, played VARCHAR)
SELECT AVG(draw) FROM table_name_15 WHERE points = 42 AND played < 36
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_15 (draw INTEGER, points VARCHAR, played VARCHAR) Question: What's the draw that's played less than 36 and has 42 points? [/INST] SELECT AVG(draw) FROM table_name_15 WHERE points = 42 AND played < 36 </s>