Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:
-- Largest population size for Gabon
SELECT population FROM population_years WHERE country = 'Gabon' ORDER BY population DESC LIMIT 1;
-- 10 lowest pop countries 2005
SELECT /*DISTINCT*/ country FROM population_years WHERE year = 2005 AND population NOT NULL ORDER BY population LIMIT 10;

-- distinct pop > 100 mill in 2010
SELECT DISTINCT country, population FROM population_years WHERE population > 1 and YEAR = 2010;

-- countries w word islands
SELECT DISTINCT country FROM population_years WHERE country LIKE "%Islands%";

-- indonesia
  --2010
SELECT country, population FROM population_years WHERE country = 'Indonesia' AND year = 2010;
  --2000
SELECT country, population FROM population_years WHERE country = 'Indonesia' AND year = 2000;
 -- 242.96834 - 214.67661 = 28.29173 million ppl