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:
-- 2000 through 2010 are covered in the dataset
select max(population) from
population_years;
select distinct country from
population_years
order by population asc
limit 10;
select distinct country from
population_years
where population > 100;
select distinct country from population_years
where country like '%Islands%';
-- 9 Countries like this
select population from
population_years
where country = 'Indonesia'
and year = 2000;
select population from
population_years
where country = 'Indonesia'
and year = 2010;
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.