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

what is the highest rank when the bronze is less than 1 and the total is less than 1?
SELECT MAX("Rank") FROM table_56923 WHERE "Bronze" < '1' AND "Total" < '1'
SELECT MAX("Rank") FROM "table_56923" WHERE "Bronze" < '1' AND "Total" < '1'