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

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