What is the average population in 2006 that has more than 5 people in 2011 and an area 5.84km?
CREATE TABLE "list" (
  "name" text,
  "type" text,
  "population_2011" real,
  "population_2006" real,
  "area_km_2" real
);
SELECT AVG("population_2006") FROM "list" WHERE "population_2011">5 AND "area_km_2"=5.84;