Codecademy export

population_queries.sqlite

select *
from countries
limit 10;

select *
from population_years
limit 5;

select count(*)
from countries
where continent='Africa';

select year, sum(population), countries.continent 
FROM population_years 
JOIN countries 
on population_years.country_id = countries.id 
WHERE population_years.year = 2005 
AND countries.continent = 'Oceania';

select year, avg(population), countries.continent 
FROM population_years 
join countries
on population_years.country_id = countries.id 
WHERE population_years.year = 2003
AND countries.continent = 'South America';

select year, min(population), countries.name
from population_years
join countries
on population_years.country_id = countries.id 
WHERE population_years.year = 2007;

select countries.name, avg(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 year, sum(population), countries.continent 
FROM population_years 
JOIN countries 
on population_years.country_id = countries.id 
WHERE population_years.year = 2010
group by countries.continent;