Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year 
FROM population_years;

-- Add your additional queries below:

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

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

-- Distinct countries with population > 100 mil in 2010:
SELECT DISTINCT country
FROM population_years
WHERE population > 100
AND year = 2010;

-- Countries with 'Islands' in their name:
SELECT DISTINCT country
FROM population_years
WHERE country LIKE '%Islands';

-- Difference in population between 2000 and 2010 in Indonesia:
SELECT population
FROM population_years
WHERE country = 'Indonesia'
AND (year = 2000 OR year = 2010);