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_51 (gold INTEGER, total VARCHAR, silver VARCHAR, rank VARCHAR)
system
What is the sum of gold medals won by teams that won fewer than 3 silver medals, more than 1 total medal, and rank 10?
user
SELECT SUM(gold) FROM table_name_51 WHERE silver < 3 AND rank = "10" AND total > 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_51 (gold INTEGER, total VARCHAR, silver VARCHAR, rank VARCHAR)<|im_end|>
<|im_start|>user
What is the sum of gold medals won by teams that won fewer than 3 silver medals, more than 1 total medal, and rank 10?<|im_end|>
