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

How much gold when silver, bronze and total is smaller than 1?
SELECT MAX("Gold") FROM table_42234 WHERE "Silver" < '1' AND "Bronze" = '1' AND "Total" < '1'
SELECT MAX("Gold") FROM "table_42234" WHERE "Bronze" = '1' AND "Silver" < '1' AND "Total" < '1'