CREATE TABLE table_55761 ("Sport" CLOB, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

What is the lowest Total that has a Gold larger than 0, Silver smaller than 4, Sport of football, and a Bronze larger than 1?
SELECT MIN("Total") FROM table_55761 WHERE "Gold" > '0' AND "Silver" < '4' AND "Sport" = 'football' AND "Bronze" > '1'
SELECT MIN("Total") FROM "table_55761" WHERE "Bronze" > '1' AND "Gold" > '0' AND "Silver" < '4' AND "Sport" = 'football'