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 for Gabon Country
SELECT population
FROM population_years
WHERE country = 'Gabon'
ORDER BY population DESC
LIMIT 1;
--10 Lowest population countries in 2010
SELECT country
FROM population_years
WHERE year = 2005
ORDER BY population ASC
LIMIT 10;
--distinct countries with a population of over 100 million in the year 2010
SELECT DISTINCT country
FROM population_years
WHERE population > 100.00000 AND year = 2010;
--countries with “Islands” in their name
SELECT DISTINCT country
FROM population_years
WHERE country LIKE '%islands%';
--difference in population between 2000 and 2010 in Indonesia
SELECT * FROM population_years
WHERE year BETWEEN '2000' AND '2011'
AND country = 'Indonesia';
--Optional Queries
SELECT MAX(population)
FROM population_years
WHERE year BETWEEN '2000' AND '2011'
AND country = 'Indonesia';
SELECT MIN(population)
FROM population_years
WHERE year BETWEEN '2000' AND '2011'
AND country = 'Indonesia';
@Rajamanikam

This comment has been minimized.

Copy link

@Rajamanikam Rajamanikam commented Aug 3, 2020

World Populations Challenge Project (SQL)

@Rajamanikam

This comment has been minimized.

Copy link

@Rajamanikam Rajamanikam commented Aug 3, 2020

-- This is the first query:

SELECT DISTINCT year from population_years;

-- Add your additional queries below:

--Largest population for Gabon Country

SELECT population
FROM population_years
WHERE country = 'Gabon'
ORDER BY population DESC
LIMIT 1;

--10 Lowest population countries in 2010

SELECT country
FROM population_years
WHERE year = 2005
ORDER BY population ASC
LIMIT 10;

--distinct countries with a population of over 100 million in the year 2010

SELECT DISTINCT country
FROM population_years
WHERE population > 100.00000 AND year = 2010;

--countries with “Islands” in their name

SELECT DISTINCT country
FROM population_years
WHERE country LIKE '%islands%';

--difference in population between 2000 and 2010 in Indonesia

SELECT * FROM population_years
WHERE year BETWEEN '2000' AND '2011'
AND country = 'Indonesia';

--Optional Queries

SELECT MAX(population)
FROM population_years
WHERE year BETWEEN '2000' AND '2011'
AND country = 'Indonesia';

SELECT MIN(population)
FROM population_years
WHERE year BETWEEN '2000' AND '2011'
AND country = 'Indonesia';

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.