Codecademy export

population_queries.sqlite

-- This is the first query:

-- SELECT DISTINCT year from population_years;

-- Add your additional queries below:

-- Question 4
-- SELECT population from population_years WHERE country = 'Gabon'
-- ORDER BY population DESC LIMIT 1;

-- Question 5
-- SELECT * FROM population_years WHERE year = 2005
-- ORDER BY population ASC LIMIT 10;

-- Question 6
-- SELECT DISTINCT * FROM population_years WHERE year = 2010
-- AND population > 100;

-- Question 7
-- SELECT DISTINCT country FROM population_years WHERE country LIKE '%Islands%';

-- Question 8
SELECT * FROM population_years WHERE country = 'Indonesia'
AND year = 2000;
SELECT * FROM population_years WHERE country = 'Indonesia'
AND year = 2010;