Table: york_county_nb
Columns: official_name
status
area_km_2
population
census_ranking

Question: What is the Population of the Rural Community
SQL: SELECT "population" FROM york_county_nb WHERE "status" = 'rural community'

Question: What is the Area km 2 with a Census Ranking of 1,773 of 5,008?
SQL: SELECT SUM("area_km_2") FROM york_county_nb WHERE "census_ranking" = '1,773 of 5,008'

Question: With an Area km 2 of less than 130.68, what is McAdam's Population?
SQL: SELECT SUM("population") FROM york_county_nb WHERE "area_km_2" < 130.68 AND "official_name" = 'mcadam'