What is the highest number of games drawn, where the games played was less than 7?
CREATE TABLE table_name_86 (drawn INTEGER, games INTEGER)
SELECT MAX(drawn) FROM table_name_86 WHERE games < 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_86 (drawn INTEGER, games INTEGER) Question: What is the highest number of games drawn, where the games played was less than 7? [/INST] SELECT MAX(drawn) FROM table_name_86 WHERE games < 7 </s>