Skip to content

Instantly share code, notes, and snippets.

@codecademydev
Created May 24, 2020 05:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save codecademydev/978554cf20c0c9a035fd2d7ee1af8959 to your computer and use it in GitHub Desktop.
Save codecademydev/978554cf20c0c9a035fd2d7ee1af8959 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:
SELECT COUNT(DISTINCT year) from population_years;
SELECT year, country, MAX(population) FROM population_years
WHERE country = 'Gabon';
SELECT country, population FROM population_years
WHERE year = 2005
ORDER BY population ASC
LIMIT 10;
SELECT DISTINCT country FROM population_years
WHERE (population > 100) AND (year = 2010);
SELECT COUNT(country) FROM population_years
WHERE country LIKE '%Islands%';
SELECT year, population FROM population_years
WHERE (year BETWEEN 2000 AND 2010) AND (country = 'Indonesia')
ORDER by year;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment