Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Codecademy export
-- This is the first query:
SELECT DISTINCT year from population_years;
-- Add your additional queries below:
SELECT COUNT (DISTINCT year)
from population_years;
SELECT country, population, year
FROM population_years
WHERE country = 'Gabon'
ORDER BY population DESC;
SELECT country, MAX (population), year
FROM population_years
WHERE country = 'Gabon'
ORDER BY population DESC;
SELECT country, population, year
FROM population_years
WHERE year = 2005
ORDER BY population ASC
LIMIT 10;
SELECT country, population
FROM population_years
WHERE year = 2010
AND population > 100
ORDER BY population DESC;
SELECT DISTINCT country
FROM population_years
WHERE country LIKE '%Islands%'
ORDER BY country ASC;
SELECT COUNT (DISTINCT country)
FROM population_years
WHERE country LIKE '%Islands%'
ORDER BY country ASC;
SELECT population AS 'Population Indonesia', year
FROM population_years
WHERE country = 'Indonesia'
AND year BETWEEN 2000 AND 2010;
SELECT
(SELECT population_years.population FROM population_years WHERE country = 'Indonesia' AND year=2000) AS 'Population 2000',
(SELECT population_years.population FROM population_years WHERE country = 'Indonesia' AND year=2010) AS 'Population 2010',
(SELECT population_years.population FROM population_years WHERE country = 'Indonesia' AND year=2000) -
(SELECT population_years.population FROM population_years WHERE country = 'Indonesia' AND year=2010) AS difference;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.