CREATE TABLE table_name_98 (total VARCHAR2, silver VARCHAR2, bronze VARCHAR2, rank VARCHAR2)

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_name_98 WHERE bronze < 2 AND rank < 4 AND silver < 1
SELECT COUNT("total") FROM "table_name_98" WHERE "bronze" < 2 AND "rank" < 4 AND "silver" < 1