CREATE TABLE table_name_78 (bronze VARCHAR, total VARCHAR, rank VARCHAR, gold VARCHAR)

How many bronzes for nations ranked above 7, under 3 golds, and under 10 total medals?
SELECT COUNT(bronze) FROM table_name_78 WHERE rank < 7 AND gold < 3 AND total < 10
SELECT COUNT("bronze") FROM "table_name_78" WHERE "gold" < 3 AND "rank" < 7 AND "total" < 10