Table: northern_america_geography
Columns: country_or_territory
area_km
population
population_density_per_km
capital

Question: What's the sum of the population with a population density (per km²) of 24.8?
SQL: SELECT SUM("population") FROM northern_america_geography WHERE "population_density_per_km" = 24.8

Question: What's the average area in canada with a population density (per km²) larger than 3.4?
SQL: SELECT AVG("area_km") FROM northern_america_geography WHERE "country_or_territory" = 'canada' AND "population_density_per_km" > 3.4

Question: What capital has an area of 2166086?
SQL: SELECT "capital" FROM northern_america_geography WHERE "area_km" = 2166086

Question: What's the highest population density for a population less than 6000?
SQL: SELECT MAX("population_density_per_km") FROM northern_america_geography WHERE "population" < 6000

Question: What's the lowest population with a population density (per km²) larger than 1203.7?
SQL: SELECT MIN("population") FROM northern_america_geography WHERE "population_density_per_km" > 1203.7