Codecademy export

population_queries.sqlite

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:
SELECT *
FROM POPULATION_YEARS
WHERE COUNTRY = 'Gabon'
ORDER BY POPULATION DESC
LIMIT 1;

SELECT *
FROM POPULATION_YEARS
WHERE YEAR = 2010
ORDER BY POPULATION ASC
LIMIT 10;

SELECT DISTINCT COUNTRY
FROM POPULATION_YEARS
WHERE YEAR = 2010 AND POPULATION > 100;

SELECT DISTINCT COUNTRY
FROM POPULATION_YEARS
WHERE COUNTRY LIKE '% ISLANDS%';

SELECT POPULATION, YEAR
FROM POPULATION_YEARS
WHERE COUNTRY = 'Indonesia' AND YEAR IN (2000,2010);