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

what is the highest rank with a total less than 1?
SELECT MAX("Rank") FROM table_10566 WHERE "Total" < '1'
SELECT MAX("Rank") FROM "table_10566" WHERE "Total" < '1'