Codecademy export

population_queries.sqlite

-- This is the first query:
SELECT  COUNT(DISTINCT year) AS numofyears 
FROM population_years;


-- Add your additional queries below:
-- 2 
SELECT * 
FROM population_years
WHERE country = 'Gabon'
ORDER BY population DESC;

-- 3
SELECT  DISTINCT country, population, year
FROM population_years
WHERE population NOT NULL AND year = 2005
ORDER BY population ASC
LIMIT 10;

-- 4
SELECT DISTINCT country, population
FROM population_years
WHERE (population > 100) AND (year = 2010);


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

-- 6

SELECT *
FROM population_years
WHERE (country = 'Indonesia') AND (year BETWEEN 2000 AND 2010)
ORDER BY population DESC;