Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

-- 4) Largest Gabon population size:
SELECT MAX(population)
FROM population_years
WHERE country = 'Gabon';

-- 5) 10 lowest population countries in 2005:
SELECT country
FROM population_years
WHERE year = 2005
ORDER BY population
LIMIT 10;

-- 6) countries with population > 100million in 2010:
SELECT DISTINCT country
FROM population_years
WHERE population > 100 AND 
year = 2010;

-- 7) countries with word 'Islands' in name:
SELECT COUNT(*)
FROM population_years
WHERE country LIKE '%Islands%';

-- 8) Diff in population between 2000 and 2010:
SELECT SUM(population)
FROM population_years
WHERE country = 'Indonesia' 
AND 2000<= year <= 2010;