Skip to content

Instantly share code, notes, and snippets.

@mallory-jpg

mallory-jpg/population_queries.sqlite

Created May 11, 2020 23:00
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mallory-jpg/4e7a44a1eaa45afcda8065993ce2f5df to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mallory-jpg/4e7a44a1eaa45afcda8065993ce2f5df to your computer and use it in GitHub Desktop.
Download ZIP
Codeacademy Export
Raw
population_queries.sqlite
-- This is the first query:
SELECT DISTINCT year from population_years;
-- Add your additional queries below:
SELECT MAX(population)
FROM population_years
WHERE country = 'Gabon';
SELECT country, population
FROM population_years
WHERE year = 2005
ORDER BY 2 ASC;
SELECT DISTINCT country
FROM population_years
WHERE population > 100 AND year = 2010;
SELECT DISTINCT country
FROM population_years
WHERE country LIKE '%islands%';
SELECT country, population, year
FROM population_years
WHERE year = 2000 AND country = 'Indonesia'
OR year = 2010 AND country = 'Indonesia';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment