Codecademy export

population_queries.sqlite

SELECT DISTINCT name
FROM countries
WHERE continent = 'Africa';

SELECT sum(population_years.population)
FROM population_years
CROSS JOIN countries
WHERE countries.continent = 'Oceania'
AND population_years.year = '2005';

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

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

SELECT *
FROM countries
JOIN population_years
ON countries.id = population_years.country_id
WHERE population_years.year ='2007'
ORDER BY population_years.population ASC
LIMIT 2;

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



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

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