Table: charlotte_county_nb
Columns: official_name
status
area_km_2
population
census_ranking

Question: What is the Status of the Paris with a Census Ranking of 3,474 of 5,008?
SQL: SELECT "status" FROM charlotte_county_nb WHERE "census_ranking" = '3,474 of 5,008'

Question: What is the Population of the Parish with an Area km 2 of 236.76?
SQL: SELECT MIN("population") FROM charlotte_county_nb WHERE "area_km_2" = 236.76

Question: What is the Area of the Parish with a Population of 71?
SQL: SELECT "area_km_2" FROM charlotte_county_nb WHERE "population" = 71