Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- What is the largest population size for Gabon in this dataset?:

select * from population_years
where country = 'Gabon'
order by population desc
limit 3;

--What were the 10 lowest population countries in 2005?
select * from population_years
where year = 2005
order by population asc
limit 10;

--What are all the distinct countries with a population of over 100 million in the year 2010?
select * from population_years
where year = 2010 and population > 100.0;

--How many countries in this dataset have the word “Islands” in their name?

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

--What is the difference in population between 2000 and 2010 in Indonesia?

select * from population_years
where country = 'Indonesia'
and year >= 2000 
and year <= 2010;