Table: kings_county_nb
Columns: official_name
status
area_km_2
population
census_ranking

Question: If the census ranking is 231 of 5,008, what was the population?
SQL: SELECT "population" FROM kings_county_nb WHERE "census_ranking" = '231 of 5,008'

Question: If the area is 59.73, what is the official name?
SQL: SELECT "official_name" FROM kings_county_nb WHERE "area_km_2" = '59.73'

Question: If the census ranking is 693 of 5,008, what is the status?
SQL: SELECT "status" FROM kings_county_nb WHERE "census_ranking" = '693 of 5,008'

Question: With the official name Quispamsis, what is the census ranking?
SQL: SELECT "census_ranking" FROM kings_county_nb WHERE "official_name" = 'Quispamsis'

Question: What was the population for census ranking 782 of 5,008?
SQL: SELECT "population" FROM kings_county_nb WHERE "census_ranking" = '782 of 5,008'

Question: If the area is 34.73, what is the census ranking?
SQL: SELECT "census_ranking" FROM kings_county_nb WHERE "area_km_2" = '34.73'