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:
-- Largest population size for Gabon
SELECT population FROM population_years WHERE country = 'Gabon' ORDER BY population DESC LIMIT 1;
-- 10 lowest pop countries 2005
SELECT /*DISTINCT*/ country FROM population_years WHERE year = 2005 AND population NOT NULL ORDER BY population LIMIT 10;
-- distinct pop > 100 mill in 2010
SELECT DISTINCT country, population FROM population_years WHERE population > 1 and YEAR = 2010;
-- countries w word islands
SELECT DISTINCT country FROM population_years WHERE country LIKE "%Islands%";
-- indonesia
--2010
SELECT country, population FROM population_years WHERE country = 'Indonesia' AND year = 2010;
--2000
SELECT country, population FROM population_years WHERE country = 'Indonesia' AND year = 2000;
-- 242.96834 - 214.67661 = 28.29173 million ppl
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.