Table: gloucester_county
Columns: official_name
status
area_km_2
population
census_ranking

Question: What is the census ranking for the community with an area smaller than 9.94 km2 and a population smaller than 817?
SQL: SELECT "census_ranking" FROM gloucester_county WHERE "area_km_2" < 9.94 AND "population" < 817

Question: What is the area (in km2) for the community that has a status of village, a census ranking of 2,471 of 5,008, and a population of less than 748?
SQL: SELECT SUM("area_km_2") FROM gloucester_county WHERE "status" = 'village' AND "census_ranking" = '2,471 of 5,008' AND "population" < 748

Question: What is the area (in km2) for the village of Paquetville, with a population over 706?
SQL: SELECT AVG("area_km_2") FROM gloucester_county WHERE "status" = 'village' AND "official_name" = 'paquetville' AND "population" > 706