what is the highest wins when the losses is less than 1, team is rams and the games is more than 8?
CREATE TABLE table_name_23 (wins INTEGER, games VARCHAR, losses VARCHAR, teams VARCHAR)
SELECT MAX(wins) FROM table_name_23 WHERE losses < 1 AND teams = "rams" AND games > 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (wins INTEGER, games VARCHAR, losses VARCHAR, teams VARCHAR) Question: what is the highest wins when the losses is less than 1, team is rams and the games is more than 8? [/INST] SELECT MAX(wins) FROM table_name_23 WHERE losses < 1 AND teams = "rams" AND games > 8 </s>