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_62 (nation VARCHAR, bronze VARCHAR, total VARCHAR, gold VARCHAR)
system
What is the Nation when there is a total less than 27, gold is less than 1, and bronze is more than 1?
user
SELECT nation FROM table_name_62 WHERE total < 27 AND gold < 1 AND bronze > 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_62 (nation VARCHAR, bronze VARCHAR, total VARCHAR, gold VARCHAR)<|im_end|>
<|im_start|>user
What is the Nation when there is a total less than 27, gold is less than 1, and bronze is more than 1?<|im_end|>
