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_99 (gold INTEGER, nation VARCHAR, silver VARCHAR)
system
What is the average Gold where the Nation is Russia (rus) and the number of silver is less than 2?
user
SELECT AVG(gold) FROM table_name_99 WHERE nation = "russia (rus)" AND silver < 2
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_99 (gold INTEGER, nation VARCHAR, silver VARCHAR)<|im_end|>
<|im_start|>user
What is the average Gold where the Nation is Russia (rus) and the number of silver is less than 2?<|im_end|>
