You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_name_88 (gold VARCHAR, total VARCHAR, silver VARCHAR, bronze VARCHAR)
system
How many gold medals were won by the nation that won over 4 silver medals, over 14 bronze, and 97 medals total?
user
SELECT COUNT(gold) FROM table_name_88 WHERE silver > 4 AND bronze > 14 AND total = 97
assistant
<|im_start|>system
You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_name_88 (gold VARCHAR, total VARCHAR, silver VARCHAR, bronze VARCHAR)<|im_end|>
<|im_start|>user
How many gold medals were won by the nation that won over 4 silver medals, over 14 bronze, and 97 medals total?<|im_end|>
