https://gist.github.com/e38824c9362bb49be2749dda6cce5b1c

SQL Practice (CodeCademy) - World Population 1 Challenge

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

ELECT MAX(population), year
FROM population_years
WHERE country = 'Gabon';

SELECT * FROM population_years
WHERE year = '2005'
ORDER BY population ASC
limit 10;

SELECT DISTINCT country
 FROM population_years
WHERE population > 100
ORDER BY population DESC;

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

SELECT * FROM population_years
WHERE country = 'Indonesia'
AND year = '2000';

SELECT * FROM population_years
WHERE country = 'Indonesia'
AND year = '2010';