Codecademy export

population_queries.sqlite

-- This is the first query:

-- SELECT DISTINCT year from population_years;

-- Add your additional queries below:

--(4) This is the largest population size for Gabon
SELECT * FROM population_years
WHERE country = 'Gabon'
ORDER BY  population DESC;

--(5) The 10 lowest population countries in 2005
SELECT * FROM population_years
WHERE year = '2005'
ORDER BY population ASC
LIMIT 10;

---(6) Distinct countries with a population of over 100 million in the year 2010
SELECT DISTINCT country, population FROM population_years 
WHERE year = '2010'
AND population > 100 
ORDER BY population ASC;


--(7) Countries in this dataset have the word “Islands” in their name
SELECT DISTINCT country FROM population_years
WHERE country LIKE '% Islands%';

----The difference in population between 2000 and 2010 in Indonesia 
--Therefore 2010-2000 = 28.29173, hence difference in Indonesia population = 28.29173

SELECT population, year  FROM population_years
WHERE country = 'Indonesia'
AND year BETWEEN '2000' AND '2010'
ORDER BY population ASC;