Skip to content

Instantly share code, notes, and snippets.

View AlistairBrownlee's full-sized avatar

Alistair Brownlee AlistairBrownlee

View GitHub Profile
@AlistairBrownlee
AlistairBrownlee / World Populations SQL Practice II
Created August 27, 2020 06:49
SELECT COUNT(*)
FROM countries
WHERE continent = 'Africa';
SELECT COUNT(*)
FROM countries
WHERE continent = 'Africa';
SELECT id, continent
FROM countries
@AlistairBrownlee
AlistairBrownlee / Codecademy - World Population SQL practice
Created August 5, 2020 16:53
-- This is the first query:
SELECT DISTINCT year from population_years;
-- Add your additional queries below:
SELECT *
FROM population_years
WHERE country = 'Gabon'
ORDER BY population DESC