Codecademy export

population_queries.sqlite

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

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

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

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

SELECT MIN(year), MAX(year)
FROM population_years;

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

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

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