CREATE TABLE table_name_23 (wins NUMBER, games VARCHAR2, losses VARCHAR2, teams VARCHAR2)

what is the highest wins when the losses is less than 1, team is rams and the games is more than 8?
SELECT MAX(wins) FROM table_name_23 WHERE losses < 1 AND teams = "rams" AND games > 8
SELECT MAX("wins") FROM "table_name_23" WHERE "games" > 8 AND "losses" < 1 AND "rams" = "teams"