Table: kings_county_nb
Columns: official_name
status
area_km_2
population
census_ranking

Question: What is the population in Westfield?
SQL: SELECT COUNT("population") FROM kings_county_nb WHERE "official_name" = 'Westfield'

Question: What is the Area KM 2 of the place that has a Census ranking of 1,016 of 5,008?
SQL: SELECT "area_km_2" FROM kings_county_nb WHERE "census_ranking" = '1,016 of 5,008'

Question: What is the Area KM 2 of the place that has a Census ranking of 1,608 of 5,008?
SQL: SELECT "area_km_2" FROM kings_county_nb WHERE "census_ranking" = '1,608 of 5,008'

Question: What is the Area KM 2 of Rothesay?
SQL: SELECT COUNT("area_km_2") FROM kings_county_nb WHERE "official_name" = 'Rothesay'

Question: What's the official name of the place with an Area KM 2 of 295.07
SQL: SELECT "official_name" FROM kings_county_nb WHERE "area_km_2" = '295.07'

Question: What is the population of Cardwell?
SQL: SELECT MIN("population") FROM kings_county_nb WHERE "official_name" = 'Cardwell'