-
-
Save codecademydev/f6127f305032a3909cd240057d64f3be 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: | |
SELECT population FROM population_years | |
ORDER BY country = 'Gabon' DESC | |
LIMIT 5; | |
SELECT country FROM population_years | |
WHERE year = 2005 | |
ORDER BY population ASC | |
LIMIT 10; | |
SELECT country FROM population_years | |
WHERE population > 100 AND year = 2010; | |
SELECT DISTINCT country FROM population_years | |
WHERE country LIKE '%Islands%'; | |
SELECT population, year FROM population_years | |
WHERE country = 'Indonesia' | |
AND year BETWEEN 2000 AND 2011 | |
ORDER BY year asc; |
-- 4 --
SELECT country, MAX(population) as max_pop_gabon
FROM population_years
WHERE country="Gabon";
-- 5 --
SELECT country, MIN(population) as min_pop
FROM population_years
WHERE year='2005'
GROUP BY country
ORDER BY min_pop
LIMIT 10;
-- 6 --
SELECT DISTINCT country as large_countries
FROM population_years
WHERE population>100 AND year='2010';
-- 7 --
SELECT DISTINCT country as islands
FROM population_years
WHERE country LIKE '%Islands%';
-- 8 --
SELECT year, population, population - LAG(population, 1) OVER(ORDER BY year) AS difference
FROM population_years
WHERE country="Indonesia" AND (year="2000" OR year="2010");
--Some different queries with useful results:
SELECT MAX(population)
FROM population_years
WHERE country = 'Gabon';
SELECT *
FROM population_years
WHERE year = 2005
ORDER BY population LIMIT 10;
SELECT DISTINCT country, population
FROM population_years
WHERE population > 100 AND year = 2010;
SELECT DISTINCT country
FROM population_years
WHERE country LIKE '%Islands%';
SELECT COUNT(DISTINCT country)
FROM population_years
WHERE country LIKE '%Islands%';
SELECT population
FROM population_years
WHERE country = 'Indonesia' AND year IN (2000, 2010);
This is my first attempt at writing my own SQL code
SELECT * FROM population_years
WHERE country = 'Gabon'
ORDER BY population DESC
LIMIT 1;
SELECT * FROM population_years
WHERE year = 2005
ORDER BY population
LIMIT 10;
SELECT * FROM population_years
WHERE year = 2010
AND population > 100;
SELECT DISTINCT country from population_years
WHERE country LIKE '%ISLANDS%';
SELECT * FROM population_years
WHERE country = 'Indonesia'
AND year BETWEEN 2000 AND 2010
ORDER BY year;