Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

-- 4. What is the largest population size for Gabon in this dataset?

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

-- 5. What is the largest population size for Gabon in this dataset?

SELECT country
FROM population_years
WHERE year = 2005
ORDER BY population ASC
LIMIT 10;

-- 6. What is the largest population size for Gabon in this dataset?

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

  -- 7. How many countries in this dataset have the word “Islands” in their name?

SELECT COUNT(DISTINCT country) AS "islands_name" 
FROM population_years
WHERE country LIKE '%islands%';

  -- 8. HWhat is the difference in population between 2000 and 2010 in Indonesia?

  -- Note: it’s okay to figure out the difference by hand after pulling the correct data.
  
SELECT *
from population_years
WHERE country = "Indonesia" AND 
(year = 2000 OR
year = 2010);

-- take the difference of 242.96834 and 214.67661 = 28.29173