CREATE TABLE table_42742 ("Rank" CLOB, "Nation" CLOB, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

How many totals have 2 for the bronze?
SELECT COUNT("Total") FROM table_42742 WHERE "Bronze" = '2'
SELECT COUNT("Total") FROM "table_42742" WHERE "Bronze" = '2'