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_171356_2 (census_ranking VARCHAR, area_km_2 VARCHAR)
system
What rank is the parish with 482.81 km^2?
user
SELECT census_ranking FROM table_171356_2 WHERE area_km_2 = "482.81"
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_171356_2 (census_ranking VARCHAR, area_km_2 VARCHAR)<|im_end|>
<|im_start|>user
What rank is the parish with 482.81 km^2?<|im_end|>
