Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:
-- Question #4
SELECT * FROM population_years WHERE country = 'Gabon' ORDER BY population DESC LIMIT 1;

-- Question #5
SELECT country, population 
FROM population_years
WHERE year = 2005
ORDER BY population
LIMIT 10;

-- Question #6
SELECT DISTINCT country 
FROM population_years 
WHERE year = 2010 AND population > 100 ORDER BY country;

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

--Question #8
SELECT population, year 
FROM population_years
WHERE country = 'Indonesia' AND year BETWEEN 2000 and 2010 ORDER BY year;