Codecademy export

population_queries.sqlite

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

SELECT SUM(population_years.population)
FROM population_years
JOIN countries
ON population_years.country_id=countries.id
WHERE countries.continent='Oceania'AND population_years.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 countries.name, MIN(population_years.population)
FROM population_years
JOIN countries
ON population_years.country_id=countries.id
WHERE population_years.year='2007';

SELECT AVG(population_years.population)
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 population_years
JOIN countries
ON population_years.country_id=countries.id
WHERE population_years.year=2010
GROUP BY countries.continent;