-
-
Save codecademydev/164162de4833780c33bdda68483a70bf to your computer and use it in GitHub Desktop.
Codecademy export
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- This is the first query: | |
SELECT DISTINCT year AS 'year range' from population_years; | |
-- Add your additional queries below: | |
--4.What is the largest population size for Gabon in this dataset? | |
SELECT year, country, MAX(population) FROM population_years | |
WHERE country = 'Gabon'; | |
--Answer: 1.55 million in 2010 | |
--5.What were the 10 lowest population countries in 2005? | |
SELECT country, population AS 'smallest 10 populations in 2005' | |
FROM population_years | |
WHERE year = 2005 | |
ORDER BY 2 ASC | |
LIMIT 10; | |
-- | |
--6.What are all the distinct countries with a population of over 100 million in the year 2010? | |
SELECT DISTINCT country, ROUND(population, 2) AS 'population over 100 million in 2010' | |
FROM population_years | |
WHERE year = 2010 | |
AND population > 100 | |
ORDER BY 2 DESC; | |
-- | |
--7.How many countries in this dataset have the word “Islands” in their name? | |
SELECT DISTINCT country AS 'countries with "islands" in name' FROM population_years | |
WHERE country LIKE '%Islands%'; | |
SELECT COUNT(DISTINCT country) AS 'number of countries with "islands" in name' FROM population_years | |
WHERE country LIKE '%Islands%'; | |
--Answer: 9 | |
--8.What is the difference in population between 2000 and 2010 in Indonesia? Note: it’s okay to figure out the difference by hand after pulling the correct data | |
SELECT * FROM population_years | |
WHERE year = 2010 | |
AND country = 'Indonesia'; | |
SELECT * FROM population_years | |
WHERE year = 2000 | |
AND country = 'Indonesia'; | |
--Answer: 28.29 million | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment