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

What is the sum of Total, when Rank is 8, and when Bronze is less than 1?
SELECT SUM("Total") FROM table_76909 WHERE "Rank" = '8' AND "Bronze" < '1'
SELECT SUM("Total") FROM "table_76909" WHERE "Bronze" < '1' AND "Rank" = '8'