Table: westmorland_county
Columns: official_name
status
area_km_2
population
census_ranking

Question: How many status are there for Moncton?
SQL: SELECT COUNT("status") FROM westmorland_county WHERE "official_name" = 'Moncton'

Question: What is the census ranking of the location with population of 959?
SQL: SELECT "census_ranking" FROM westmorland_county WHERE "population" = 959

Question: What is the name of the place with 582.20 square km area?
SQL: SELECT "official_name" FROM westmorland_county WHERE "area_km_2" = '582.20'

Question: What is the name of the place where area is 578.28 square km?
SQL: SELECT "official_name" FROM westmorland_county WHERE "area_km_2" = '578.28'