Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

SELECT country, population FROM population_years
WHERE country = 'Gabon' ORDER by population DESC
LIMIT 1;

----- No 5 incl. year to make sure it's the right one haha-----
SELECT country, population,year FROM population_years
WHERE year ='2005' ORDER by population ASC LIMIT 10;
------ No 6 -----
SELECT DISTINCT country, population FROM population_years
WHERE year ='2010' AND population >100;
---- No 7 ----
SELECT DISTINCT country from population_years
Where country LIKE '%island%';
--- No 8 ---
SELECT * from population_years 
WHERE country = 'Indonesia' AND ((year='2010') OR (year='2000'));