What is the number of bronze medals when the total medals were 78 and there were less than 12 golds?
CREATE TABLE table_name_39 (bronze INTEGER, total VARCHAR, gold VARCHAR)
SELECT SUM(bronze) FROM table_name_39 WHERE total = 78 AND gold < 12
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_39 (bronze INTEGER, total VARCHAR, gold VARCHAR) Question: What is the number of bronze medals when the total medals were 78 and there were less than 12 golds? [/INST] SELECT SUM(bronze) FROM table_name_39 WHERE total = 78 AND gold < 12 </s>