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

what is the highest silver when the total is 4 and bronze is less than 1?
SELECT MAX("Silver") FROM table_64068 WHERE "Total" = '4' AND "Bronze" < '1'
SELECT MAX("Silver") FROM "table_64068" WHERE "Bronze" < '1' AND "Total" = '4'