Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

-- 2000 through 2010 are covered in the dataset 

select max(population) from
population_years;
 
select distinct country from 
population_years
order by population asc
limit 10;

select distinct country from
population_years
where population > 100;

select distinct country from population_years
where country like '%Islands%';
-- 9 Countries like this

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

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