CREATE TABLE table_name_39 (bronze NUMBER, total VARCHAR2, gold VARCHAR2)

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_name_39 WHERE total = 78 AND gold < 12
SELECT SUM("bronze") FROM "table_name_39" WHERE "gold" < 12 AND "total" = 78