World Populations Challenge Project (SQL) - My Solution

solution.sql

-- This is the first query:

SELECT DISTINCT year FROM population_years;

-- Add your additional queries below:

-- Question 4

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

-- Question 5

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

-- Question 6

SELECT DISTINCT country, population FROM population_years
WHERE year = 2010
AND population > 100
ORDER BY population DESC;

-- Question 7

SELECT DISTINCT country FROM population_years
WHERE country LIKE '%Islands%';

-- Question 8

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

-- The Differenz between 2000 and 2010 in population in Indonesia is 28.29173 million people.