Codecademy export

population_queries.sqlite

SELECT *
FROM countries
LIMIT 5;

SELECT *
FROM population_years
LIMIT 5;

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

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

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


SELECT DISTINCT name, population, year
FROM countries
JOIN population_years
ON countries.id = population_years.country_id
WHERE year = 2007
AND population IS NOT NULL
ORDER BY population ASC
LIMIT 1;

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

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

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