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

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

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

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

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

SELECT countries.continent,SUM(population_years.population)
FROM population_years JOIN countries
ON population_years.country_id = countries.id
GROUP BY 1
ORDER BY 2 DESC;