CREATE TABLE table_59570 ("Club" CLOB, "Wins" FLOAT, "Byes" FLOAT, "Losses" FLOAT, "Against" FLOAT)

Which Against has Losses larger than 10, and Wins smaller than 4, and a Club of dunolly?
SELECT MIN("Against") FROM table_59570 WHERE "Losses" > '10' AND "Wins" < '4' AND "Club" = 'dunolly'
SELECT MIN("Against") FROM "table_59570" WHERE "Club" = 'dunolly' AND "Losses" > '10' AND "Wins" < '4'