Skip to content

Instantly share code, notes, and snippets.

View lackenbacher's full-sized avatar

Andrew lackenbacher

  • Phoenix
View GitHub Profile
@pamelafox
pamelafox / countries_and_territories.sql
Last active July 2, 2024 19:32
countries_and_territories.sql
/*
Countries and dependent territories, 2020
Data adapted from
http://www.worldometers.info/world-population/population-by-country/
Does not include rows which had "N.A." values, so some territories are missing.
*/
CREATE TABLE countries(
name TEXT PRIMARY KEY,
population INTEGER,