Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:
--Problem 4
select *
from population_years
where country = 'Gabon'
order by population DESC;

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

--Problem 6
select distinct country
from population_years
where population > 100
and year = 2010;

--Problem 7
select *
from population_years
where country like '%Islands%';

--Problem 8
select *
from population_years
where country = 'Indonesia'
and year = 2000
or 
country = 'Indonesia'
and 
year = 2010;