Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

-- 4. largest population size for Gabon in this dataset?
select country, population
from population_years
where country like 'Gabon'
order by population DESC
limit 1;

-- 5. 10 lowest population countries in 2005
select *
from population_years
where year = 2005
order by population asc
limit 10;

-- 6. distinct countries with a population of over 100 million in the year 2010
select 
DISTINCT country, 
population
from population_years
where year = 2010 and population > 100;

-- 7. countries in this dataset have the word “Islands” in their name
select 
distinct country
from population_years
where country like  '%Islands%';


-- 8.  difference in population between 2000 and 2010 in Indonesia
SELECT * 
FROM
	(select country, population,year from population_years where country like  'Indonesia' AND YEAR BETWEEN 2000 AND 2010)
WHERE year = 2000  OR YEAR = 2010;