Table: towns_pei
Columns: county
population_2011
population_2006
change
area_km
population_density

Question: What is the Population density that has a Change (%) higher than 10.4, and a Population (2011) less than 8574, in the County of Queens?
SQL: SELECT AVG("population_density") FROM towns_pei WHERE "change" > 10.4 AND "county" = 'queens' AND "population_2011" < 8574

Question: What was the Population (2011) when the Population (2006) was less than 7083, and the Population density less than 342.8, and the Change (%) of 5, and an Area (km²) larger than 4.5?
SQL: SELECT COUNT("population_2011") FROM towns_pei WHERE "population_2006" < 7083 AND "population_density" < 342.8 AND "change" = 5 AND "area_km" > 4.5

Question: What was the Area (km²) when the Population (2011) was 8574, and the Population density was larger than 381.4?
SQL: SELECT AVG("area_km") FROM towns_pei WHERE "population_2011" = 8574 AND "population_density" > 381.4

Question: In the County of Prince, what was the highest Population density when the Area (km²) was larger than 3.02, and the Population (2006) was larger than 786, and the Population (2011) was smaller than 1135?
SQL: SELECT MAX("population_density") FROM towns_pei WHERE "county" = 'prince' AND "area_km" > 3.02 AND "population_2006" > 786 AND "population_2011" < 1135