Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

Select * from population_years
where country='Gabon'
order by population desc;

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

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

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

select population from population_years where country = 'Indonesia' and year = '2000';
select population from population_years where country = 'Indonesia' and year = '2010';