Codecademy export

population_queries.sqlite

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

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

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

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

SELECT name
FROM countries
WHERE name LIKE '%The%';

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