Codecademy export

population_queries.sqlite

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

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

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

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

-------------------------------

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

-------------------------------

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

------------------------------

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