CREATE TABLE table_50471 ("Rank" FLOAT, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

What is the total for the team with fewer than 2 bronze, ranked less than 4 and fewer than 1 silver?
SELECT COUNT("Total") FROM table_50471 WHERE "Bronze" < '2' AND "Rank" < '4' AND "Silver" < '1'
SELECT COUNT("Total") FROM "table_50471" WHERE "Bronze" < '2' AND "Rank" < '4' AND "Silver" < '1'