Codecademy export

population_queries.sqlite

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

SELECT * from countries
limit 10;

SELECT * FROM population_years
limit 10;

SELECT COUNT(*) FROM countries;

SELECT COUNT(*) FROM population_years;

SELECT population_years.country_id, population_years.year, countries.continent, population_years.population
FROM countries
join population_years
LIMIT 15;

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

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

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

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

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

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