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_69 (nation VARCHAR, rank VARCHAR, bronze VARCHAR, total VARCHAR, silver VARCHAR)
system
Which nation has total medals under 63, less than 2 silver, more than 2 bronze, and a rank of 8?
user
SELECT nation FROM table_name_69 WHERE total < 63 AND silver < 2 AND bronze > 2 AND rank = "8"
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_69 (nation VARCHAR, rank VARCHAR, bronze VARCHAR, total VARCHAR, silver VARCHAR)<|im_end|>
<|im_start|>user
Which nation has total medals under 63, less than 2 silver, more than 2 bronze, and a rank of 8?<|im_end|>
