DROP TABLE IF EXISTS populations;
CREATE TABLE populations (
    city_id int,
    year int,
    population int
);
DROP TABLE IF EXISTS cities;
CREATE TABLE cities (
    id int,
    name text
);
INSERT INTO cities (id, name) VALUES (0, 'Philadelphia');
INSERT INTO populations (city_id, year, population) VALUES (0, 1790, 29);
INSERT INTO populations (city_id, year, population) VALUES (0, 1800, 41);
INSERT INTO populations (city_id, year, population) VALUES (0, 1810, 54);
INSERT INTO populations (city_id, year, population) VALUES (0, 1820, 64);
INSERT INTO populations (city_id, year, population) VALUES (0, 1830, 80);
INSERT INTO populations (city_id, year, population) VALUES (0, 1840, 94);
INSERT INTO populations (city_id, year, population) VALUES (0, 1850, 121);
INSERT INTO populations (city_id, year, population) VALUES (0, 1860, 566);
INSERT INTO populations (city_id, year, population) VALUES (0, 1870, 674);
INSERT INTO populations (city_id, year, population) VALUES (0, 1880, 847);
INSERT INTO populations (city_id, year, population) VALUES (0, 1890, 1049);
INSERT INTO populations (city_id, year, population) VALUES (0, 1900, 1293);
INSERT INTO populations (city_id, year, population) VALUES (0, 1910, 1549);
INSERT INTO populations (city_id, year, population) VALUES (0, 1920, 1824);
INSERT INTO populations (city_id, year, population) VALUES (0, 1930, 1951);
INSERT INTO populations (city_id, year, population) VALUES (0, 1940, 1931);
INSERT INTO populations (city_id, year, population) VALUES (0, 1950, 2072);
INSERT INTO populations (city_id, year, population) VALUES (0, 1960, 2003);
INSERT INTO populations (city_id, year, population) VALUES (0, 1970, 1949);
INSERT INTO populations (city_id, year, population) VALUES (0, 1980, 1688);
INSERT INTO populations (city_id, year, population) VALUES (0, 1990, 1586);
INSERT INTO populations (city_id, year, population) VALUES (0, 2000, 1517);
INSERT INTO cities (id, name) VALUES (1, 'New Orleans');
INSERT INTO populations (city_id, year, population) VALUES (1, 1790, 0);
INSERT INTO populations (city_id, year, population) VALUES (1, 1800, 0);
INSERT INTO populations (city_id, year, population) VALUES (1, 1810, 17);
INSERT INTO populations (city_id, year, population) VALUES (1, 1820, 27);
INSERT INTO populations (city_id, year, population) VALUES (1, 1830, 46);
INSERT INTO populations (city_id, year, population) VALUES (1, 1840, 102);
INSERT INTO populations (city_id, year, population) VALUES (1, 1850, 116);
INSERT INTO populations (city_id, year, population) VALUES (1, 1860, 169);
INSERT INTO populations (city_id, year, population) VALUES (1, 1870, 191);
INSERT INTO populations (city_id, year, population) VALUES (1, 1880, 216);
INSERT INTO populations (city_id, year, population) VALUES (1, 1890, 242);
INSERT INTO populations (city_id, year, population) VALUES (1, 1900, 287);
INSERT INTO populations (city_id, year, population) VALUES (1, 1910, 330);
INSERT INTO populations (city_id, year, population) VALUES (1, 1920, 387);
INSERT INTO populations (city_id, year, population) VALUES (1, 1930, 459);
INSERT INTO populations (city_id, year, population) VALUES (1, 1940, 495);
INSERT INTO populations (city_id, year, population) VALUES (1, 1950, 570);
INSERT INTO populations (city_id, year, population) VALUES (1, 1960, 628);
INSERT INTO populations (city_id, year, population) VALUES (1, 1970, 593);
INSERT INTO populations (city_id, year, population) VALUES (1, 1980, 558);
INSERT INTO populations (city_id, year, population) VALUES (1, 1990, 497);
INSERT INTO populations (city_id, year, population) VALUES (1, 2000, 485);

