Codecademy export

population_queries.sqlite

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

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

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

SELECT name
FROM countries
JOIN population_years
ON countries.id = population_years.country_id
WHERE population IS NOT NULL
ORDER BY population
LIMIT 1;

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

SELECT COUNT(*)
FROM countries
JOIN population_years
ON countries.id = population_years.country_id
WHERE name LIKE '% The';

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