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_38 (silver INTEGER, bronze VARCHAR, rank VARCHAR, total VARCHAR)
system
On average, what is the number of silver medals for nations ranking higher than 7, with a total of 6 medals and fewer than 2 bronze medals?
user
SELECT AVG(silver) FROM table_name_38 WHERE rank > 7 AND total = 6 AND bronze < 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_38 (silver INTEGER, bronze VARCHAR, rank VARCHAR, total VARCHAR)<|im_end|>
<|im_start|>user
On average, what is the number of silver medals for nations ranking higher than 7, with a total of 6 medals and fewer than 2 bronze medals?<|im_end|>
