what is the highest points when position is higher than 6, lost is less than 12 and drawn is less than 1?
CREATE TABLE table_name_39 (points INTEGER, drawn VARCHAR, position VARCHAR, lost VARCHAR)
SELECT MAX(points) FROM table_name_39 WHERE position > 6 AND lost < 12 AND drawn < 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_39 (points INTEGER, drawn VARCHAR, position VARCHAR, lost VARCHAR) Question: what is the highest points when position is higher than 6, lost is less than 12 and drawn is less than 1? [/INST] SELECT MAX(points) FROM table_name_39 WHERE position > 6 AND lost < 12 AND drawn < 1 </s>