Codecademy export

population_queries.sqlite

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

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

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

SELECT name
FROM countries
JOIN population_years
  ON countries.id = population_years.country_id
WHERE year = 2007
ORDER BY population ASC
LIMIT 1;


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

SELECT DISTINCT countries.name
FROM countries
JOIN population_years 
  ON countries.id = population_years.country_id 
WHERE countries.name LIKE '%The%';

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