Codecademy export

population_queries.sqlite

--Q3
SELECT DISTINCT year from population_years;

--Q4
select *
from population_years
where country = 'Gabon'
order by population Desc;

--Q5
select *
from population_years
where year = 2005
order by population 
limit 10;

--Q6
select *
from population_years
where population >= 100 and year = 2010;

--Q7
select distinct country
from population_years
where country like '%Islands%';

--Q8
select *
from population_years
where year = 2000 and country = 'Indonesia';
select *
from population_years
where year = 2010 and country = 'Indonesia';