Table: queens_county_nb
Columns: official_name
status
area_km_2
population
census_ranking

Question: What rank is the parish with 482.81 km^2?
SQL: SELECT "census_ranking" FROM queens_county_nb WHERE "area_km_2" = '482.81'

Question: What status doe the area with a census ranking of 2,290 of 5,008 have?
SQL: SELECT "status" FROM queens_county_nb WHERE "census_ranking" = '2,290 of 5,008'

Question: How many statuses are listed for the parish officially named Gagetown?
SQL: SELECT COUNT("status") FROM queens_county_nb WHERE "official_name" = 'Gagetown'

Question: What is Petersville's census ranking?
SQL: SELECT "census_ranking" FROM queens_county_nb WHERE "official_name" = 'Petersville'