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 year = '2005'
AND continent = 'Oceania';

SELECT ROUND(AVG(population), 2)
FROM population_years
JOIN countries
  ON population_years.country_id = countries.id
WHERE year = '2003'
AND continent = 'Oceania';

SELECT MIN(population), name
FROM population_years
JOIN countries
  ON population_years.country_id = countries.id
  WHERE year = '2007';

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

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

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