Name the highest Played of Goals Scored smaller than 18 and a Lost larger than 10?
CREATE TABLE table_name_23 (played INTEGER, goals_scored VARCHAR, lost VARCHAR)
SELECT MAX(played) FROM table_name_23 WHERE goals_scored < 18 AND lost > 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (played INTEGER, goals_scored VARCHAR, lost VARCHAR) Question: Name the highest Played of Goals Scored smaller than 18 and a Lost larger than 10? [/INST] SELECT MAX(played) FROM table_name_23 WHERE goals_scored < 18 AND lost > 10 </s>