CREATE TABLE table_name_40 (total VARCHAR, bronze VARCHAR)

How many totals have 2 for the bronze?
SELECT COUNT(total) FROM table_name_40 WHERE bronze = 2
SELECT COUNT("total") FROM "table_name_40" WHERE "bronze" = 2