Table: albert_county_nb
Columns: official_name
status
area_km_2
population
census_ranking

Question: What is the official name of the land with an area of 276.84 km2?
SQL: SELECT "official_name" FROM albert_county_nb WHERE "area_km_2" = '276.84'

Question: What is the total number of population in the land with an area of 149.32 km2?
SQL: SELECT COUNT("population") FROM albert_county_nb WHERE "area_km_2" = '149.32'

Question: What is the maximum population of the land with an area of 276.84 km2?
SQL: SELECT MAX("population") FROM albert_county_nb WHERE "area_km_2" = '276.84'

Question: What is the land area of Hopewell parish in km2?
SQL: SELECT "area_km_2" FROM albert_county_nb WHERE "official_name" = 'Hopewell'