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

What is the number of bronze medals when the total medals were 78 and there were less than 12 golds?
SELECT SUM("Bronze") FROM table_76042 WHERE "Total" = '78' AND "Gold" < '12'
SELECT SUM("Bronze") FROM "table_76042" WHERE "Gold" < '12' AND "Total" = '78'