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

Which rank has a total less than 9, less than 2 bronze, and from France?
SELECT "Rank" FROM table_58091 WHERE "Total" < '9' AND "Bronze" < '2' AND "Nation" = 'france'
SELECT "Rank" FROM "table_58091" WHERE "Bronze" < '2' AND "Nation" = 'france' AND "Total" < '9'