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

What is the largest total when the rank is 6 and there's less than 1 gold?
SELECT MAX("Total") FROM table_7055 WHERE "Rank" = '6' AND "Gold" < '1'
SELECT MAX("Total") FROM "table_7055" WHERE "Gold" < '1' AND "Rank" = '6'