Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

select max(population) [gabon_pop]
from population_years
where country = 'Gabon';

select country
from population_years
where year = '2005'
order by population asc
limit 10;

select distinct country
from population_years
where population > 100
and year = '2010';

select count(*) [island_countries]
from population_years
where country like '%Islands%';

select (select population from population_years where country='Indonesia' and year='2010') - (select population from population_years where country='Indonesia' and year='2000') [indo_diff];