What is the highest games from a game with points less than 4, drawn of 1 and a lost less than 6?
CREATE TABLE table_name_58 (games INTEGER, lost VARCHAR, points VARCHAR, drawn VARCHAR)
SELECT MAX(games) FROM table_name_58 WHERE points < 4 AND drawn = 1 AND lost < 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_58 (games INTEGER, lost VARCHAR, points VARCHAR, drawn VARCHAR) Question: What is the highest games from a game with points less than 4, drawn of 1 and a lost less than 6? [/INST] SELECT MAX(games) FROM table_name_58 WHERE points < 4 AND drawn = 1 AND lost < 6 </s>