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

How many ranks have a Bronze smaller than 8, and a Total smaller than 7, and a Gold smaller than 1?
SELECT COUNT("Rank") FROM table_5455 WHERE "Bronze" < '8' AND "Total" < '7' AND "Gold" < '1'
SELECT COUNT("Rank") FROM "table_5455" WHERE "Bronze" < '8' AND "Gold" < '1' AND "Total" < '7'