Codecademy export

population_queries.sqlite

SELECT COUNT(*)
FROM countries
WHERE continent = 'Africa';

SELECT SUM (population_years.population)
FROM countries
JOIN population_years
  ON countries.id = population_years.country_id
WHERE countries.continent = 'Oceania' AND
population_years.year = 2005;

SELECT AVG (population_years.population)
FROM countries
JOIN population_years
  ON countries.id = population_years.country_id
WHERE countries.continent = 'South America' AND
population_years.year = 2003;

SELECT MIN(population), country_id
FROM population_years
WHERE year = 2007;

SELECT AVG(population_years.population)
FROM population_years
JOIN countries
  ON countries.id = population_years.country_id
WHERE countries.name= 'Poland';

SELECT COUNT(*)
FROM countries
WHERE name LIKE '%The%';

SELECT countries.continent, SUM(population_years.population)
FROM countries
JOIN population_years
  ON countries.id = population_years.country_id
WHERE population_years.year = 2010
GROUP BY countries.continent;