Codecademy export

population_queries.sqlite

SELECT count(*) FROM countries
WHERE continent = 'Africa'; 
SELECT id, count(*) FROM countries
WHERE continent = 'Oceania'; 

SELECT * FROM population_years
limit 10;
SELECT * from population_years
where year = '2005' and country_id = 213;

SELECT id, count(*) FROM countries
Where continent = 'South America';

SELECT * from population_years
where year = '2003' and country_id = 48;

SELECT country_id, MIN(population) FROM population_years
where year = 2007;

SELECT * FROM countries
where continent = 'Europe' and name = 'Poland';

SELECT AVG(population) FROM population_years
where country_id = 76;

SELECT * FROM countries
where name like '%the%';

SELECT * FROM population_years
where year = 2010
group by country_id;

SELECT count(id),continent FROM countries
group by continent;

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