Codecademy export

population_queries.sqlite

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

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

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

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

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

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

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