Table: t_103_mile
Columns: name
type
population_2011
population_2006
area_km_2

Question: What is the sum of the area in km with a population of 110 in 2011?
SQL: SELECT SUM("area_km_2") FROM t_103_mile WHERE "population_2011" = 110

Question: What is the average population in 2006 that has more than 5 people in 2011 and an area 5.84km?
SQL: SELECT AVG("population_2006") FROM t_103_mile WHERE "population_2011" > 5 AND "area_km_2" = 5.84