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_90 (gold INTEGER, silver VARCHAR, nation VARCHAR, total VARCHAR, bronze VARCHAR)
system
What is the average number of gold medals Switzerland received when they ranked larger than 1st and received fewer than 10 bronze medals and more than 1 silver medal?
user
SELECT AVG(gold) FROM table_name_90 WHERE total > 1 AND bronze < 10 AND nation = "switzerland" AND silver > 1
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_90 (gold INTEGER, silver VARCHAR, nation VARCHAR, total VARCHAR, bronze VARCHAR)<|im_end|>
<|im_start|>user
What is the average number of gold medals Switzerland received when they ranked larger than 1st and received fewer than 10 bronze medals and more than 1 silver medal?<|im_end|>
