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_66 (bronze INTEGER, gold VARCHAR, total VARCHAR, silver VARCHAR)
system
How many bronze medals has a total less than 3 with a silver less than 1 and gold more than 1?
user
SELECT AVG(bronze) FROM table_name_66 WHERE total < 3 AND silver < 1 AND gold > 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_66 (bronze INTEGER, gold VARCHAR, total VARCHAR, silver VARCHAR)<|im_end|>
<|im_start|>user
How many bronze medals has a total less than 3 with a silver less than 1 and gold more than 1?<|im_end|>
