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, bronze VARCHAR, silver VARCHAR, nation VARCHAR)
system
What is the average number of golds for nations with less than 2 silver, named uzbekistan, and less than 4 bronze?
user
SELECT AVG(gold) FROM table_name_51 WHERE silver < 2 AND nation = "uzbekistan" AND bronze < 4
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, bronze VARCHAR, silver VARCHAR, nation VARCHAR)<|im_end|>
<|im_start|>user
What is the average number of golds for nations with less than 2 silver, named uzbekistan, and less than 4 bronze?<|im_end|>
