Codecademy export

population_queries.sqlite

-- This is the first query:

-- SELECT DISTINCT year from population_years;

-- Add your additional queries below:

-- 4 : Largest pop size for Gabon
-- SELECT country, population
-- FROM population_years
-- WHERE country = 'Gabon'
-- ORDER BY population DESC;

-- 5 : 10 Lowest population countries in 2005
-- SELECT *
-- FROM population_years
-- WHERE year = 2005
-- ORDER BY population
-- LIMIT 10;

-- 6 : Distinct countries with population > 100mill in 2010
-- SELECT DISTINCT country
-- FROM population_years
-- WHERE population > 100 AND year = 2010;

-- 7 : Countries with 'Islands' in name
-- SELECT DISTINCT country
-- FROM population_years
-- WHERE country LIKE '%Islands%';

-- 8 : Difference in pop for Indonesia 2000 vs 2010
SELECT *
FROM population_years
WHERE country = 'Indonesia' AND year = 2000 OR country = 'Indonesia' AND year = 2010;