Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

-- 4. Largest population size for Gabon
SELECT country, population
FROM population_years
WHERE country = 'Gabon'
ORDER BY population DESC
LIMIT 1;

-- 5. Lowest 10 population countries in 2005
SELECT country, population
FROM population_years
WHERE population IS NOT NULL AND year = 2005
ORDER BY population ASC 
LIMIT 10;

-- 6. Distinct countries with >100m pop in 2010
SELECT DISTINCT country, population
FROM population_years
WHERE year = 2010
AND population > 100
ORDER BY population DESC;

-- 7. How many countries have Islands in their name
SELECT DISTINCT country
FROM population_years
WHERE country LIKE '%Islands%';

-- 8. Difference in population for Indonesia between 2000 and 2010
SELECT country, population, year
FROM population_years
WHERE country = 'Indonesia'
AND year = 2000
OR country = 'Indonesia'
AND year = 2010;