Codecademy export

population_queries.sqlite

-- This is the first query

SELECT DISTINCT year
FROM population_years;

-- Largest population size for Gabon

SELECT population
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 population > 100
 AND year = 2010
 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 country = 'Indonesia'
  AND year = 2010;