Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

Select * From population_years;

SelecT DISTINCT Country
FROM population_years;

---Largest population size for Gabon
SELECT MAX (population)
FROM population_years
WHERE country = 'Gabon'

----lowest population countries in 2005
SELECT country
FROM population_years
WHERE year = '2005'
ORDER BY population 
LIMIT 10;

---distinct countris with a population of over 100 million in the year 2010

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

---how many countries in this data set have the word 'Islands' in their name
SELECT count (*) AS  NUMBER
FROM population_years
WHERE country like '%Islands%';

----what is the difference in population between 2000 and 20101 in Indonesia
SELECT population
FROM population_years
WHERE country = 'Indonesia'
AND year = '2010'
MINUS
SELECT population
FROM population_years
WHERE country = 'Indonesia'
AND year = '2000';