Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

--4
SELECT MAX(population)
FROM population_years
WHERE country = 'Gabon';

--5
SELECT DISTINCT country
FROM population_years
WHERE population IS NOT NULL AND year = 2005
ORDER BY population ASC
LIMIT 10;

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

--7
SELECT COUNT(DISTINCT country) AS 'Number of Countries'
FROM population_years
WHERE country LIKE '%Islands%';

--8
SELECT population, year
FROM population_years
WHERE country = 'Indonesia' AND 
(year = 2000 OR year = 2010);