WHAT IS THE HIGHEST WINS WITH AGAINST SMALLER THAN 924, LOSSES SMALLER THAN 2?
CREATE TABLE table_name_72 (wins INTEGER, against VARCHAR, losses VARCHAR)
SELECT MAX(wins) FROM table_name_72 WHERE against < 924 AND losses < 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_72 (wins INTEGER, against VARCHAR, losses VARCHAR) Question: WHAT IS THE HIGHEST WINS WITH AGAINST SMALLER THAN 924, LOSSES SMALLER THAN 2? [/INST] SELECT MAX(wins) FROM table_name_72 WHERE against < 924 AND losses < 2 </s>