Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;
SELECT *
FROM population_years
WHERE country = 'Gabon';
SELECT *
FROM population_years
WHERE population IS NOT NULL
  AND year = 2005
ORDER BY population ASC
LIMIT 10;
SELECT DISTINCT country
FROM population_years
WHERE population > 100.00000
  AND year = 2010;
SELECT *
FROM population_years
WHERE country LIKE '%Islands%';
SELECT *
FROM population_years
WHERE country = 'Indonesia'
  AND year = 2000;
SELECT *
FROM population_years
WHERE country = 'Indonesia'
  AND year = 2010;


-- Add your additional queries below: