Can you tell me the highest Played that has the Points larger than 11, and the Lost larger than 7?
CREATE TABLE table_name_36 (played INTEGER, points VARCHAR, lost VARCHAR)
SELECT MAX(played) FROM table_name_36 WHERE points > 11 AND lost > 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_36 (played INTEGER, points VARCHAR, lost VARCHAR) Question: Can you tell me the highest Played that has the Points larger than 11, and the Lost larger than 7? [/INST] SELECT MAX(played) FROM table_name_36 WHERE points > 11 AND lost > 7 </s>