CREATE TABLE table_47695 ("Rank" CLOB, "Nation" CLOB, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

Which Bronze has a Total of 4, and a Gold smaller than 1?
SELECT MIN("Bronze") FROM table_47695 WHERE "Total" = '4' AND "Gold" < '1'
SELECT MIN("Bronze") FROM "table_47695" WHERE "Gold" < '1' AND "Total" = '4'