Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;
select distinct country from population_years
order by country asc;

-- Add your additional queries below:
select country, population 
from population_years
where country = 'Gabon'
order by population desc
limit 1;

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

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

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

select *
from population_years
where year between 2000 and 2010
and country = 'Indonesia'
order by year asc;