What is the highest Game, when Opponents is less than 80, and when Record is "1-0"?
CREATE TABLE table_name_98 (game INTEGER, opponents VARCHAR, record VARCHAR)
SELECT MAX(game) FROM table_name_98 WHERE opponents < 80 AND record = "1-0"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_98 (game INTEGER, opponents VARCHAR, record VARCHAR) Question: What is the highest Game, when Opponents is less than 80, and when Record is "1-0"? [/INST] SELECT MAX(game) FROM table_name_98 WHERE opponents < 80 AND record = "1-0" </s>