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

What's the highest bronze with a less than 1 Rank?
SELECT MAX("Bronze") FROM table_70570 WHERE "Rank" < '1'
SELECT MAX("Bronze") FROM "table_70570" WHERE "Rank" < '1'