How many Gold medals were won by the Nation that had more than 12 Bronze medals and less than 124 Total medals?
CREATE TABLE table_name_56 (gold VARCHAR, bronze VARCHAR, total VARCHAR)
SELECT COUNT(gold) FROM table_name_56 WHERE bronze > 12 AND total < 124
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_56 (gold VARCHAR, bronze VARCHAR, total VARCHAR) Question: How many Gold medals were won by the Nation that had more than 12 Bronze medals and less than 124 Total medals? [/INST] SELECT COUNT(gold) FROM table_name_56 WHERE bronze > 12 AND total < 124 </s>