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_95 (rank INTEGER, bronze VARCHAR, gold VARCHAR, silver VARCHAR)
system
What is the lowest rank of a nation with fewer than 3 gold medals, more than 2 bronze medals, and 0 silver medals?
user
SELECT MIN(rank) FROM table_name_95 WHERE gold < 3 AND silver = 0 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_95 (rank INTEGER, bronze VARCHAR, gold VARCHAR, silver VARCHAR)<|im_end|>
<|im_start|>user
What is the lowest rank of a nation with fewer than 3 gold medals, more than 2 bronze medals, and 0 silver medals?<|im_end|>
