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_20 (silver VARCHAR, nation VARCHAR, gold VARCHAR, total VARCHAR)
system
How many silver medals did Estonia, which won more than 1 gold and less than 97 medals total, win?
user
SELECT silver FROM table_name_20 WHERE gold > 1 AND total < 97 AND nation = "estonia"
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_20 (silver VARCHAR, nation VARCHAR, gold VARCHAR, total VARCHAR)<|im_end|>
<|im_start|>user
How many silver medals did Estonia, which won more than 1 gold and less than 97 medals total, win?<|im_end|>
