Skip to content

Instantly share code, notes, and snippets.

@codecademydev
Created February 27, 2020 16:58
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save codecademydev/6b36398dcd0e0aba6ebf73b993a7ed19 to your computer and use it in GitHub Desktop.
Codecademy export
-- This is the first query:
SELECT DISTINCT year from population_years;
-- Add your additional queries below:
--largest population of Gabon
SELECT *
FROM population_years
WHERE country = 'Gabon'
ORDER BY population DESC
LIMIT 1;
--10 lowest population countries in 2005
SELECT country
FROM population_years
WHERE year = 2005
ORDER BY population ASC
LIMIT 10;
--the distinct countries with a population of over 100 million in the year 2010
SELECT country
FROM population_years
WHERE population >100
AND year = 2010;
--countries having word "Islands" in their name
SELECT COUNT(DISTINCT country) AS n_islands
FROM population_years
WHERE country LIKE '%Islands%';
--the difference in population between 2000 and 2010 in Indonesia
SELECT population
FROM population_years
WHERE
country = 'Indonesia'
AND year = 2010
OR
country = 'Indonesia'
AND year = 2000;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment