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_74 (bronze INTEGER, total VARCHAR, rank VARCHAR, silver VARCHAR, gold VARCHAR)
system
what is the bronze when silver is 1, gold is 0 the rank is 11 and the total is more than 1?
user
SELECT MAX(bronze) FROM table_name_74 WHERE silver = 1 AND gold = 0 AND rank = "11" AND total > 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_74 (bronze INTEGER, total VARCHAR, rank VARCHAR, silver VARCHAR, gold VARCHAR)<|im_end|>
<|im_start|>user
what is the bronze when silver is 1, gold is 0 the rank is 11 and the total is more than 1?<|im_end|>
