How many gold medals were won by the nation that won over 4 silver medals, over 14 bronze, and 97 medals total?
CREATE TABLE table_name_88 (gold VARCHAR, total VARCHAR, silver VARCHAR, bronze VARCHAR)
SELECT COUNT(gold) FROM table_name_88 WHERE silver > 4 AND bronze > 14 AND total = 97
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_88 (gold VARCHAR, total VARCHAR, silver VARCHAR, bronze VARCHAR) Question: How many gold medals were won by the nation that won over 4 silver medals, over 14 bronze, and 97 medals total? [/INST] SELECT COUNT(gold) FROM table_name_88 WHERE silver > 4 AND bronze > 14 AND total = 97 </s>