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_21 (rank INTEGER, county_and_state VARCHAR, capacity__thousands_of_metric_tons_ VARCHAR)
system
In Silver Bow County, Montana, when the capicity is more than 45 tons, what's the highest rank found?
user
SELECT MAX(rank) FROM table_name_21 WHERE county_and_state = "silver bow county, montana" AND capacity__thousands_of_metric_tons_ > 45
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_21 (rank INTEGER, county_and_state VARCHAR, capacity__thousands_of_metric_tons_ VARCHAR)<|im_end|>
<|im_start|>user
In Silver Bow County, Montana, when the capicity is more than 45 tons, what's the highest rank found?<|im_end|>
