Codecademy export

population_queries.sqlite

-- Years covered in this dataset:

SELECT DISTINCT year FROM population_years;

-- The largest population size for Gabon:

SELECT * FROM population_years
WHERE country = 'Gabon'
ORDER BY population DESC
LIMIT 1;

-- Smallest 2005 countries by population:

SELECT country, population
FROM population_years
WHERE year = 2005
ORDER BY population ASC
LIMIT 10;

-- Countries with >100M population in 2010:

SELECT country, population
FROM population_years
WHERE year = 2010
AND population > 100
ORDER BY population DESC;

-- Countries containing "islands":

SELECT DISTINCT country FROM population_years
WHERE country LIKE "%islands%";

-- Difference in population in Indonesia:

SELECT year, population FROM population_years
WHERE country = 'Indonesia'
AND (year = 2000 OR year = 2010);