CREATE TABLE table_name_1 (rank VARCHAR2, gold VARCHAR2, bronze VARCHAR2, total VARCHAR2)

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_name_1 WHERE bronze < 8 AND total < 7 AND gold < 1
SELECT COUNT("rank") FROM "table_name_1" WHERE "bronze" < 8 AND "gold" < 1 AND "total" < 7