CREATE TABLE table_43801 ("Event" CLOB, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

what is the highest bronze when silver is less than 1 and gold is more than 0?
SELECT MAX("Bronze") FROM table_43801 WHERE "Silver" < '1' AND "Gold" > '0'
SELECT MAX("Bronze") FROM "table_43801" WHERE "Gold" > '0' AND "Silver" < '1'