Codecademy export

population_queries.sqlite

-- task #4
SELECT *
FROM population_years
WHERE country = 'Gabon'
ORDER BY population DESC
LIMIT 1

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

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

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

-- task #8
SELECT *
FROM population_years
WHERE country = 'Indonesia'
AND year BETWEEN 2000 AND 2010
ORDER BY year ASC;