Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

SELECT MAX(population) AS 'Maximum Pop of Gabon', 
year
FROM population_years
WHERE country = 'Gabon';

SELECT country AS 'Poorly Populated in 2005', 
population
FROM population_years
WHERE year = 2005
ORDER BY 2
LIMIT 10;

SELECT DISTINCT country AS 'Vastly Populated'
FROM population_years
WHERE population > 100
AND year = 2010
ORDER BY population DESC;

SELECT COUNT(DISTINCT country) AS 'Number of Islanders'
FROM population_years
WHERE country LIKE '%Islands%';

SELECT population
FROM population_years
WHERE country = 'Indonesia'
AND (
  year = 2000
  OR
  year = 2010
);