Table: charlotte_county_nb
Columns: official_name
status
area_km_2
population
census_ranking

Question: What is the status for Saint George? 
SQL: SELECT "status" FROM charlotte_county_nb WHERE "official_name" = 'Saint George'

Question: What is the area in km2 for Dufferin? 
SQL: SELECT "area_km_2" FROM charlotte_county_nb WHERE "official_name" = 'Dufferin'

Question: How many areas are named West Isles? 
SQL: SELECT COUNT("area_km_2") FROM charlotte_county_nb WHERE "official_name" = 'West Isles'

Question: How many areas of 375.06 km 2 have a census ranking? 
SQL: SELECT COUNT("census_ranking") FROM charlotte_county_nb WHERE "area_km_2" = '375.06'

Question: What is the census ranking when the area is 78.67 ?
SQL: SELECT "census_ranking" FROM charlotte_county_nb WHERE "area_km_2" = '78.67'