Codecademy export

population_queries.sqlite

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


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


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


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


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

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


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