-
-
Save codecademydev/8e65c237c042c0f8f04cb220d9561d46 to your computer and use it in GitHub Desktop.
| -- 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'; |
-- 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';
World Populations Challenge Project (SQL)