What is the highest draws when more than 6 are played and the points against are 54?
CREATE TABLE table_name_92 (drawn INTEGER, against VARCHAR, played VARCHAR)
SELECT MAX(drawn) FROM table_name_92 WHERE against = 54 AND played > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_92 (drawn INTEGER, against VARCHAR, played VARCHAR) Question: What is the highest draws when more than 6 are played and the points against are 54? [/INST] SELECT MAX(drawn) FROM table_name_92 WHERE against = 54 AND played > 6 </s>