PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "city" (
"ID" INT,
"Name" CHAR(35),
"Population" INT,
PRIMARY KEY ("ID")
);

CREATE TABLE "country" (
"Code" CHAR(3),
"Name" CHAR(52),
"Continent" TEXT,
"Population" INT,
PRIMARY KEY ("Code")
);





INSERT INTO "city" VALUES ("1", "New York", "8419000");
INSERT INTO "city" VALUES ("2", "Los Angeles", "3980000");
INSERT INTO "city" VALUES ("3", "Chicago", "2716000");
INSERT INTO "city" VALUES ("4", "Houston", "2320000");
INSERT INTO "city" VALUES ("5", "Phoenix", "1660000");
INSERT INTO "city" VALUES ("6", "Philadelphia", "1584000");
INSERT INTO "city" VALUES ("7", "San Antonio", "1532000");
INSERT INTO "city" VALUES ("8", "San Diego", "1420000");
INSERT INTO "city" VALUES ("9", "Dallas", "1340000");
INSERT INTO "city" VALUES ("10", "San Jose", "1030000");
INSERT INTO "city" VALUES ("11", "Austin", "964000");
INSERT INTO "city" VALUES ("12", "Jacksonville", "904000");
INSERT INTO "city" VALUES ("13", "Fort Worth", "895000");
INSERT INTO "city" VALUES ("14", "Columbus", "892000");
INSERT INTO "city" VALUES ("15", "Charlotte", "885000");
INSERT INTO "city" VALUES ("16", "Indianapolis", "876000");
INSERT INTO "city" VALUES ("17", "San Francisco", "870000");
INSERT INTO "city" VALUES ("18", "Seattle", "745000");
INSERT INTO "city" VALUES ("19", "Denver", "727000");
INSERT INTO "city" VALUES ("20", "Washington", "705000");
INSERT INTO "city" VALUES ("21", "Boston", "692000");
INSERT INTO "city" VALUES ("22", "El Paso", "681000");
INSERT INTO "city" VALUES ("23", "Nashville", "670000");
INSERT INTO "city" VALUES ("24", "Detroit", "670000");
INSERT INTO "city" VALUES ("25", "Oklahoma City", "655000");
INSERT INTO "city" VALUES ("26", "Portland", "653000");
INSERT INTO "city" VALUES ("27", "Las Vegas", "644000");
INSERT INTO "city" VALUES ("28", "Memphis", "651000");
INSERT INTO "city" VALUES ("29", "Louisville", "617000");
INSERT INTO "city" VALUES ("30", "Baltimore", "602000");
INSERT INTO "city" VALUES ("31", "Milwaukee", "592000");
INSERT INTO "city" VALUES ("32", "Albuquerque", "560000");
INSERT INTO "city" VALUES ("33", "Tucson", "545000");
INSERT INTO "city" VALUES ("34", "Fresno", "530000");
INSERT INTO "city" VALUES ("35", "Sacramento", "513000");
INSERT INTO "city" VALUES ("36", "Mesa", "508000");
INSERT INTO "city" VALUES ("37", "Atlanta", "498000");
INSERT INTO "city" VALUES ("38", "Kansas City", "491000");
INSERT INTO "city" VALUES ("39", "Colorado Springs", "478000");
INSERT INTO "city" VALUES ("40", "Miami", "470000");
INSERT INTO "city" VALUES ("41", "Raleigh", "469000");
INSERT INTO "city" VALUES ("42", "Omaha", "466000");
INSERT INTO "city" VALUES ("43", "Long Beach", "462000");
INSERT INTO "city" VALUES ("44", "Virginia Beach", "450000");
INSERT INTO "city" VALUES ("45", "Oakland", "433000");
INSERT INTO "city" VALUES ("46", "Minneapolis", "429000");
INSERT INTO "city" VALUES ("47", "Tulsa", "401000");
INSERT INTO "city" VALUES ("48", "Arlington", "398000");
INSERT INTO "city" VALUES ("49", "New Orleans", "391000");
INSERT INTO "city" VALUES ("50", "Wichita", "389000");
INSERT INTO "city" VALUES ("51", "Cleveland", "381000");
INSERT INTO "city" VALUES ("52", "Bakersfield", "380000");
INSERT INTO "city" VALUES ("53", "Aurora", "374000");
INSERT INTO "city" VALUES ("54", "Anaheim", "359000");
INSERT INTO "city" VALUES ("55", "Honolulu", "350000");
INSERT INTO "city" VALUES ("56", "Santa Ana", "332000");
INSERT INTO "city" VALUES ("57", "Riverside", "327000");
INSERT INTO "city" VALUES ("58", "Corpus Christi", "325000");
INSERT INTO "city" VALUES ("59", "Lexington", "323000");
INSERT INTO "city" VALUES ("60", "St. Louis", "300000");
INSERT INTO "city" VALUES ("61", "Stockton", "310000");
INSERT INTO "city" VALUES ("62", "Pittsburgh", "302000");
INSERT INTO "city" VALUES ("63", "Cincinnati", "302000");
INSERT INTO "city" VALUES ("64", "Anchorage", "291000");
INSERT INTO "city" VALUES ("65", "Henderson", "310000");
INSERT INTO "city" VALUES ("66", "Greensboro", "296000");
INSERT INTO "city" VALUES ("67", "Plano", "287000");
INSERT INTO "city" VALUES ("68", "Newark", "282000");
INSERT INTO "city" VALUES ("69", "Orlando", "287000");
INSERT INTO "city" VALUES ("70", "Lincoln", "287000");
INSERT INTO "city" VALUES ("71", "Toledo", "272000");
INSERT INTO "city" VALUES ("72", "Fort Wayne", "267000");
INSERT INTO "city" VALUES ("73", "St. Petersburg", "265000");
INSERT INTO "city" VALUES ("74", "Jersey City", "262000");
INSERT INTO "city" VALUES ("75", "Chula Vista", "272000");
INSERT INTO "city" VALUES ("76", "Buffalo", "255000");
INSERT INTO "city" VALUES ("77", "Durham", "278000");
INSERT INTO "city" VALUES ("78", "Madison", "258000");
INSERT INTO "city" VALUES ("79", "Fort Lauderdale", "182000");
INSERT INTO "city" VALUES ("80", "Reno", "255000");
INSERT INTO "city" VALUES ("81", "Lubbock", "255000");
INSERT INTO "city" VALUES ("82", "North Las Vegas", "249000");
INSERT INTO "city" VALUES ("83", "Chesapeake", "244000");
INSERT INTO "city" VALUES ("84", "Gilbert", "247000");
INSERT INTO "city" VALUES ("85", "Glendale", "246000");
INSERT INTO "city" VALUES ("86", "Chandler", "257000");
INSERT INTO "city" VALUES ("87", "Scottsdale", "255000");
INSERT INTO "city" VALUES ("88", "Norfolk", "245000");
INSERT INTO "city" VALUES ("89", "Winston-Salem", "247000");
INSERT INTO "city" VALUES ("90", "Irving", "240000");
INSERT INTO "city" VALUES ("91", "Hialeah", "238000");
INSERT INTO "city" VALUES ("92", "Garland", "238000");
INSERT INTO "city" VALUES ("93", "Fremont", "237000");
INSERT INTO "city" VALUES ("94", "Richmond", "228000");
INSERT INTO "city" VALUES ("95", "Boise", "228000");
INSERT INTO "city" VALUES ("96", "Baton Rouge", "220000");
INSERT INTO "city" VALUES ("97", "Spokane", "222000");
INSERT INTO "city" VALUES ("98", "Des Moines", "217000");
INSERT INTO "city" VALUES ("99", "Tacoma", "215000");
INSERT INTO "city" VALUES ("100", "San Bernardino", "216000");
INSERT INTO "city" VALUES ("101", "Fontana", "210000");
INSERT INTO "city" VALUES ("102", "Modesto", "214000");
INSERT INTO "city" VALUES ("103", "Fayetteville", "209000");
INSERT INTO "city" VALUES ("104", "Oxnard", "208000");
INSERT INTO "city" VALUES ("105", "Shreveport", "188000");
INSERT INTO "city" VALUES ("106", "Augusta", "196000");
INSERT INTO "city" VALUES ("107", "Grand Rapids", "198000");
INSERT INTO "city" VALUES ("108", "Huntsville", "199000");
INSERT INTO "city" VALUES ("109", "Mobile", "188000");
INSERT INTO "city" VALUES ("110", "Montgomery", "200000");
INSERT INTO "city" VALUES ("111", "Little Rock", "197000");
INSERT INTO "city" VALUES ("112", "Springfield", "167000");
INSERT INTO "city" VALUES ("113", "Chattanooga", "182000");
INSERT INTO "city" VALUES ("114", "Knoxville", "187000");
INSERT INTO "city" VALUES ("115", "Akron", "190000");
INSERT INTO "city" VALUES ("116", "Dayton", "140000");
INSERT INTO "city" VALUES ("117", "Tallahassee", "193000");
INSERT INTO "city" VALUES ("118", "Port St. Lucie", "195000");
INSERT INTO "city" VALUES ("119", "Cape Coral", "194000");
INSERT INTO "city" VALUES ("120", "Sioux Falls", "187000");
INSERT INTO "city" VALUES ("121", "Overland Park", "195000");
INSERT INTO "city" VALUES ("122", "Kansas City", "150000");
INSERT INTO "city" VALUES ("123", "Topeka", "125000");
INSERT INTO "city" VALUES ("124", "Olathe", "140000");
INSERT INTO "city" VALUES ("125", "Waco", "138000");
INSERT INTO "city" VALUES ("126", "Killeen", "150000");
INSERT INTO "city" VALUES ("127", "Denton", "140000");
INSERT INTO "city" VALUES ("128", "Mesquite", "140000");
INSERT INTO "city" VALUES ("129", "Pasadena", "150000");
INSERT INTO "city" VALUES ("130", "McKinney", "190000");
INSERT INTO "city" VALUES ("131", "Frisco", "190000");
INSERT INTO "city" VALUES ("132", "Naperville", "140000");
INSERT INTO "city" VALUES ("133", "Joliet", "140000");
INSERT INTO "city" VALUES ("134", "Rockford", "140000");
INSERT INTO "city" VALUES ("135", "Springfield", "115000");
INSERT INTO "city" VALUES ("136", "Peoria", "110000");
INSERT INTO "city" VALUES ("137", "Evansville", "118000");
INSERT INTO "city" VALUES ("138", "South Bend", "102000");
INSERT INTO "city" VALUES ("139", "Carmel", "92000");
INSERT INTO "city" VALUES ("140", "Fishers", "95000");
INSERT INTO "city" VALUES ("141", "Muncie", "70000");
INSERT INTO "city" VALUES ("142", "Terre Haute", "60000");
INSERT INTO "city" VALUES ("143", "Bloomington", "85000");
INSERT INTO "city" VALUES ("144", "Gary", "75000");
INSERT INTO "city" VALUES ("145", "Hammond", "80000");
INSERT INTO "city" VALUES ("146", "Lafayette", "70000");
INSERT INTO "city" VALUES ("147", "Anderson", "55000");
INSERT INTO "city" VALUES ("148", "Kokomo", "50000");
INSERT INTO "city" VALUES ("149", "Richmond", "35000");
INSERT INTO "city" VALUES ("150", "Columbus", "45000");
INSERT INTO "city" VALUES ("151", "Elkhart", "50000");
INSERT INTO "city" VALUES ("152", "Mishawaka", "48000");
INSERT INTO "city" VALUES ("153", "Lawrence", "48000");
INSERT INTO "city" VALUES ("154", "Greenwood", "58000");
INSERT INTO "city" VALUES ("155", "Plainfield", "30000");
INSERT INTO "city" VALUES ("156", "Brownsburg", "25000");
INSERT INTO "city" VALUES ("157", "Avon", "20000");
INSERT INTO "city" VALUES ("158", "Zionsville", "25000");
INSERT INTO "city" VALUES ("159", "Westfield", "40000");
INSERT INTO "city" VALUES ("160", "Noblesville", "60000");
INSERT INTO "city" VALUES ("161", "Fishers", "95000");
INSERT INTO "city" VALUES ("162", "Carmel", "92000");
INSERT INTO "city" VALUES ("163", "Greenwood", "58000");
INSERT INTO "city" VALUES ("164", "Lawrence", "48000");
INSERT INTO "city" VALUES ("165", "Plainfield", "30000");
INSERT INTO "city" VALUES ("166", "Brownsburg", "25000");
INSERT INTO "city" VALUES ("167", "Avon", "20000");
INSERT INTO "city" VALUES ("168", "Zionsville", "25000");
INSERT INTO "city" VALUES ("169", "Westfield", "40000");
INSERT INTO "city" VALUES ("170", "Noblesville", "60000");
INSERT INTO "city" VALUES ("171", "Fishers", "95000");
INSERT INTO "city" VALUES ("172", "Carmel", "92000");
INSERT INTO "city" VALUES ("173", "Greenwood", "58000");
INSERT INTO "city" VALUES ("174", "Lawrence", "48000");
INSERT INTO "city" VALUES ("175", "Plainfield", "30000");
INSERT INTO "city" VALUES ("176", "Brownsburg", "25000");
INSERT INTO "city" VALUES ("177", "Avon", "20000");
INSERT INTO "city" VALUES ("178", "Zionsville", "25000");
INSERT INTO "city" VALUES ("179", "Westfield", "40000");
INSERT INTO "city" VALUES ("180", "Noblesville", "60000");
INSERT INTO "city" VALUES ("181", "Fishers", "95000");
INSERT INTO "city" VALUES ("182", "Carmel", "92000");
INSERT INTO "city" VALUES ("183", "Greenwood", "58000");
INSERT INTO "city" VALUES ("184", "Lawrence", "48000");
INSERT INTO "city" VALUES ("185", "Plainfield", "30000");
INSERT INTO "city" VALUES ("186", "Brownsburg", "25000");
INSERT INTO "city" VALUES ("187", "Avon", "20000");
INSERT INTO "city" VALUES ("188", "Zionsville", "25000");
INSERT INTO "city" VALUES ("189", "Westfield", "40000");
INSERT INTO "city" VALUES ("190", "Noblesville", "60000");
INSERT INTO "city" VALUES ("191", "Fishers", "95000");
INSERT INTO "city" VALUES ("192", "Carmel", "92000");
INSERT INTO "city" VALUES ("193", "Greenwood", "58000");
INSERT INTO "city" VALUES ("194", "Lawrence", "48000");
INSERT INTO "city" VALUES ("195", "Plainfield", "30000");
INSERT INTO "city" VALUES ("196", "Brownsburg", "25000");
INSERT INTO "city" VALUES ("197", "Avon", "20000");
INSERT INTO "city" VALUES ("198", "Zionsville", "25000");
INSERT INTO "city" VALUES ("199", "Westfield", "40000");
INSERT INTO "city" VALUES ("200", "Noblesville", "60000");
INSERT INTO "country" VALUES ("USA", "United States", "North America", "331000000");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "38000000");
INSERT INTO "country" VALUES ("MEX", "Mexico", "North America", "128000000");
INSERT INTO "country" VALUES ("BRA", "Brazil", "South America", "212000000");
INSERT INTO "country" VALUES ("ARG", "Argentina", "South America", "45000000");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "Europe", "67000000");
INSERT INTO "country" VALUES ("FRA", "France", "Europe", "65000000");
INSERT INTO "country" VALUES ("DEU", "Germany", "Europe", "83000000");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "1440000000");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "1380000000");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "25000000");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "102000000");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Africa", "206000000");