Codecademy export

population_queries.sqlite

-- This is the first query:
SELECT DISTINCT year from population_years;

-- Add your additional queries below:
--Q4 What is the largest population size for Gabon in this dataset?:
select country, population
from population_years
where country = 'Gabon'
order by population DESC
limit 1; 

--Q5 What were the 10 lowest population countries in 2005?:
select country, population
from population_years
where population is not null
and year = 2005
order by population
limit 10;

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

--Q7 How many countries in this dataset have the word “Islands” in their name?:
select count(country)
from population_years
where country like '%Islands%';

--Q8 --What is the difference in population between 2000 and 2010 in Indonesia?:
select country, population, year
from population_years
where year between 2000 and 2010
and country = 'Indonesia';

-- 242.96834 - 214.67661 =  28.29173 million: