CREATE TABLE table_6899 ("Peel" CLOB, "Wins" FLOAT, "Byes" FLOAT, "Losses" FLOAT, "Draws" FLOAT, "Against" FLOAT)

Which Losses has a Wins of 6, and an Against smaller than 1741?
SELECT MIN("Losses") FROM table_6899 WHERE "Wins" = '6' AND "Against" < '1741'
SELECT MIN("Losses") FROM "table_6899" WHERE "Against" < '1741' AND "Wins" = '6'