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),
PRIMARY KEY ("ID")
);

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





INSERT INTO "city" VALUES ("1", "Kabul");
INSERT INTO "city" VALUES ("2", "Qandahar");
INSERT INTO "city" VALUES ("3", "Herat");
INSERT INTO "city" VALUES ("4", "Mazar-e-Sharif");
INSERT INTO "city" VALUES ("5", "Amsterdam");
INSERT INTO "city" VALUES ("6", "Rotterdam");
INSERT INTO "city" VALUES ("7", "The Hague");
INSERT INTO "city" VALUES ("8", "Utrecht");
INSERT INTO "city" VALUES ("9", "Eindhoven");
INSERT INTO "city" VALUES ("10", "Tilburg");
INSERT INTO "city" VALUES ("11", "Groningen");
INSERT INTO "city" VALUES ("12", "Breda");
INSERT INTO "city" VALUES ("13", "Apeldoorn");
INSERT INTO "city" VALUES ("14", "Arnhem");
INSERT INTO "city" VALUES ("15", "Haarlem");
INSERT INTO "city" VALUES ("16", "Enschede");
INSERT INTO "city" VALUES ("17", "Amersfoort");
INSERT INTO "city" VALUES ("18", "Zaanstad");
INSERT INTO "city" VALUES ("19", "Den Bosch");
INSERT INTO "city" VALUES ("20", "Nijmegen");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "Southern and Central Asia", "22720000", "45.9");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "Europe", "Western Europe", "15970000", "78.4");
INSERT INTO "country" VALUES ("AGO", "Angola", "Africa", "Central Africa", "12878000", "38.3");
INSERT INTO "country" VALUES ("CAF", "Central African Republic", "Africa", "Central Africa", "3700000", "44.0");
INSERT INTO "country" VALUES ("COD", "Congo, The Democratic Republic of the", "Africa", "Central Africa", "50000000", "48.0");
INSERT INTO "country" VALUES ("COG", "Congo", "Africa", "Central Africa", "2900000", "48.7");
INSERT INTO "country" VALUES ("CMR", "Cameroon", "Africa", "Central Africa", "15000000", "50.4");
INSERT INTO "country" VALUES ("GAB", "Gabon", "Africa", "Central Africa", "1200000", "56.0");
INSERT INTO "country" VALUES ("GNQ", "Equatorial Guinea", "Africa", "Central Africa", "450000", "49.0");
INSERT INTO "country" VALUES ("STP", "Sao Tome and Principe", "Africa", "Central Africa", "150000", "65.0");
INSERT INTO "country" VALUES ("TCD", "Chad", "Africa", "Central Africa", "7500000", "49.8");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "Africa", "Eastern Africa", "10000000", "37.2");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "Africa", "Eastern Africa", "11000000", "37.8");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "Southern Africa", "43000000", "48.7");
INSERT INTO "country" VALUES ("DZA", "Algeria", "Africa", "Northern Africa", "31000000", "69.7");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "Northern Africa", "68000000", "67.0");
INSERT INTO "country" VALUES ("MAR", "Morocco", "Africa", "Northern Africa", "29000000", "69.1");
INSERT INTO "country" VALUES ("TUN", "Tunisia", "Africa", "Northern Africa", "9500000", "73.1");
INSERT INTO "country" VALUES ("SDN", "Sudan", "Africa", "Northern Africa", "35000000", "56.5");
INSERT INTO "country" VALUES ("LBY", "Libya", "Africa", "Northern Africa", "5500000", "75.5");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "Africa", "Eastern Africa", "4000000", "54.0");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "Africa", "Eastern Africa", "62000000", "45.2");
INSERT INTO "country" VALUES ("SOM", "Somalia", "Africa", "Eastern Africa", "10000000", "47.0");
INSERT INTO "country" VALUES ("DJI", "Djibouti", "Africa", "Eastern Africa", "600000", "50.8");
INSERT INTO "country" VALUES ("KEN", "Kenya", "Africa", "Eastern Africa", "30000000", "48.0");
INSERT INTO "country" VALUES ("UGA", "Uganda", "Africa", "Eastern Africa", "23000000", "42.8");
INSERT INTO "country" VALUES ("RWA", "Rwanda", "Africa", "Eastern Africa", "8000000", "42.0");
INSERT INTO "country" VALUES ("BDI", "Burundi", "Africa", "Eastern Africa", "6500000", "42.0");
INSERT INTO "country" VALUES ("TZA", "Tanzania", "Africa", "Eastern Africa", "34000000", "46.2");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "Africa", "Eastern Africa", "18000000", "37.5");
INSERT INTO "country" VALUES ("MDG", "Madagascar", "Africa", "Eastern Africa", "16000000", "55.0");
INSERT INTO "country" VALUES ("COM", "Comoros", "Africa", "Eastern Africa", "600000", "59.0");
INSERT INTO "country" VALUES ("MUS", "Mauritius", "Africa", "Eastern Africa", "1200000", "71.0");
INSERT INTO "country" VALUES ("SYC", "Seychelles", "Africa", "Eastern Africa", "80000", "74.0");
INSERT INTO "country" VALUES ("MWI", "Malawi", "Africa", "Eastern Africa", "11000000", "37.6");
INSERT INTO "country" VALUES ("BWA", "Botswana", "Africa", "Southern Africa", "1600000", "39.3");
INSERT INTO "country" VALUES ("NAM", "Namibia", "Africa", "Southern Africa", "1800000", "42.0");
INSERT INTO "country" VALUES ("LSO", "Lesotho", "Africa", "Southern Africa", "2000000", "49.8");
INSERT INTO "country" VALUES ("SWZ", "Swaziland", "Africa", "Southern Africa", "1000000", "40.4");
INSERT INTO "country" VALUES ("BEN", "Benin", "Africa", "Western Africa", "6000000", "50.4");
INSERT INTO "country" VALUES ("BFA", "Burkina Faso", "Africa", "Western Africa", "11000000", "44.0");
INSERT INTO "country" VALUES ("CPV", "Cape Verde", "Africa", "Western Africa", "400000", "69.0");
INSERT INTO "country" VALUES ("CIV", "Cote d'Ivoire", "Africa", "Western Africa", "16000000", "45.2");
INSERT INTO "country" VALUES ("GMB", "Gambia", "Africa", "Western Africa", "1300000", "53.0");
INSERT INTO "country" VALUES ("GHA", "Ghana", "Africa", "Western Africa", "19000000", "57.4");
INSERT INTO "country" VALUES ("GIN", "Guinea", "Africa", "Western Africa", "7500000", "45.6");
INSERT INTO "country" VALUES ("GNB", "Guinea-Bissau", "Africa", "Western Africa", "1200000", "49.0");
INSERT INTO "country" VALUES ("LBR", "Liberia", "Africa", "Western Africa", "3000000", "48.0");
INSERT INTO "country" VALUES ("MLI", "Mali", "Africa", "Western Africa", "11000000", "47.0");
INSERT INTO "country" VALUES ("MRT", "Mauritania", "Africa", "Western Africa", "2700000", "50.8");
INSERT INTO "country" VALUES ("NER", "Niger", "Africa", "Western Africa", "10000000", "42.0");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Africa", "Western Africa", "120000000", "51.6");
INSERT INTO "country" VALUES ("SEN", "Senegal", "Africa", "Western Africa", "9000000", "50.0");
INSERT INTO "country" VALUES ("SLE", "Sierra Leone", "Africa", "Western Africa", "5000000", "38.0");
INSERT INTO "country" VALUES ("TGO", "Togo", "Africa", "Western Africa", "4700000", "50.0");
INSERT INTO "country" VALUES ("MEX", "Mexico", "North America", "Central America", "98000000", "71.5");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "North America", "31000000", "79.4");
INSERT INTO "country" VALUES ("USA", "United States", "North America", "North America", "278000000", "77.1");
INSERT INTO "country" VALUES ("BRA", "Brazil", "South America", "South America", "170000000", "62.9");
INSERT INTO "country" VALUES ("ARG", "Argentina", "South America", "South America", "37000000", "75.1");
INSERT INTO "country" VALUES ("COL", "Colombia", "South America", "South America", "42000000", "70.3");
INSERT INTO "country" VALUES ("PER", "Peru", "South America", "South America", "27000000", "70.0");
INSERT INTO "country" VALUES ("CHL", "Chile", "South America", "South America", "15000000", "75.7");
INSERT INTO "country" VALUES ("ECU", "Ecuador", "South America", "South America", "12000000", "71.1");
INSERT INTO "country" VALUES ("VEN", "Venezuela", "South America", "South America", "24000000", "73.1");
INSERT INTO "country" VALUES ("BOL", "Bolivia", "South America", "South America", "8000000", "63.7");
INSERT INTO "country" VALUES ("PRY", "Paraguay", "South America", "South America", "5500000", "71.0");
INSERT INTO "country" VALUES ("URY", "Uruguay", "South America", "South America", "3300000", "75.2");
INSERT INTO "country" VALUES ("GUY", "Guyana", "South America", "South America", "800000", "64.0");
INSERT INTO "country" VALUES ("SUR", "Suriname", "South America", "South America", "400000", "71.4");
INSERT INTO "country" VALUES ("FRA", "France", "Europe", "Western Europe", "59000000", "78.7");
INSERT INTO "country" VALUES ("DEU", "Germany", "Europe", "Western Europe", "82000000", "77.4");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "Europe", "Western Europe", "59000000", "77.7");
INSERT INTO "country" VALUES ("ITA", "Italy", "Europe", "Southern Europe", "57000000", "79.0");
INSERT INTO "country" VALUES ("ESP", "Spain", "Europe", "Southern Europe", "39000000", "78.8");
INSERT INTO "country" VALUES ("PRT", "Portugal", "Europe", "Southern Europe", "10000000", "76.8");
INSERT INTO "country" VALUES ("GRC", "Greece", "Europe", "Southern Europe", "10000000", "78.2");
INSERT INTO "country" VALUES ("AUT", "Austria", "Europe", "Western Europe", "8000000", "77.7");
INSERT INTO "country" VALUES ("BEL", "Belgium", "Europe", "Western Europe", "10000000", "77.8");
INSERT INTO "country" VALUES ("CHE", "Switzerland", "Europe", "Western Europe", "7000000", "79.6");
INSERT INTO "country" VALUES ("IRL", "Ireland", "Europe", "Northern Europe", "3800000", "76.8");
INSERT INTO "country" VALUES ("DNK", "Denmark", "Europe", "Northern Europe", "5300000", "76.5");
INSERT INTO "country" VALUES ("NOR", "Norway", "Europe", "Northern Europe", "4500000", "78.7");
INSERT INTO "country" VALUES ("SWE", "Sweden", "Europe", "Northern Europe", "8900000", "79.8");
INSERT INTO "country" VALUES ("FIN", "Finland", "Europe", "Northern Europe", "5100000", "77.4");
INSERT INTO "country" VALUES ("ISL", "Iceland", "Europe", "Northern Europe", "280000", "79.7");
INSERT INTO "country" VALUES ("EST", "Estonia", "Europe", "Eastern Europe", "1400000", "69.0");
INSERT INTO "country" VALUES ("LVA", "Latvia", "Europe", "Eastern Europe", "2400000", "68.4");
INSERT INTO "country" VALUES ("LTU", "Lithuania", "Europe", "Eastern Europe", "3700000", "69.1");
INSERT INTO "country" VALUES ("POL", "Poland", "Europe", "Eastern Europe", "38000000", "73.2");
INSERT INTO "country" VALUES ("CZE", "Czech Republic", "Europe", "Eastern Europe", "10000000", "74.5");
INSERT INTO "country" VALUES ("SVK", "Slovakia", "Europe", "Eastern Europe", "5400000", "73.7");
INSERT INTO "country" VALUES ("HUN", "Hungary", "Europe", "Eastern Europe", "10000000", "71.4");
INSERT INTO "country" VALUES ("ROU", "Romania", "Europe", "Eastern Europe", "22000000", "69.9");
INSERT INTO "country" VALUES ("BGR", "Bulgaria", "Europe", "Eastern Europe", "8000000", "70.9");
INSERT INTO "country" VALUES ("ALB", "Albania", "Europe", "Southern Europe", "3400000", "71.6");
INSERT INTO "country" VALUES ("BIH", "Bosnia and Herzegovina", "Europe", "Southern Europe", "3900000", "71.5");
INSERT INTO "country" VALUES ("HRV", "Croatia", "Europe", "Southern Europe", "4400000", "73.7");
INSERT INTO "country" VALUES ("MKD", "Macedonia", "Europe", "Southern Europe", "2000000", "72.2");
INSERT INTO "country" VALUES ("SVN", "Slovenia", "Europe", "Southern Europe", "2000000", "74.9");
INSERT INTO "country" VALUES ("YUG", "Yugoslavia", "Europe", "Southern Europe", "10000000", "72.4");
INSERT INTO "country" VALUES ("RUS", "Russian Federation", "Europe", "Eastern Europe", "147000000", "67.2");
INSERT INTO "country" VALUES ("UKR", "Ukraine", "Europe", "Eastern Europe", "50000000", "66.0");
INSERT INTO "country" VALUES ("BLR", "Belarus", "Europe", "Eastern Europe", "10000000", "68.0");
INSERT INTO "country" VALUES ("MDA", "Moldova", "Europe", "Eastern Europe", "4300000", "64.5");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Asia", "Western Asia", "5400000", "64.5");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Asia", "Western Asia", "3800000", "66.8");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "Asia", "Western Asia", "8000000", "62.9");
INSERT INTO "country" VALUES ("KAZ", "Kazakstan", "Asia", "Central Asia", "16000000", "63.2");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "Asia", "Central Asia", "4800000", "63.4");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "Asia", "Central Asia", "6000000", "63.7");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "Asia", "Central Asia", "4500000", "60.9");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "Central Asia", "24000000", "63.7");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "Eastern Asia", "1277000000", "71.4");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "Southern and Central Asia", "1013000000", "62.5");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "Asia", "Southeast Asia", "212000000", "68.0");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "Asia", "Southern and Central Asia", "156000000", "61.1");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "Southern and Central Asia", "128000000", "60.2");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "Eastern Asia", "126000000", "80.7");
INSERT INTO "country" VALUES ("PHL", "Philippines", "Asia", "Southeast Asia", "76000000", "67.5");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "Asia", "Southeast Asia", "79000000", "69.3");
INSERT INTO "country" VALUES ("IRN", "Iran", "Asia", "Southern and Central Asia", "67000000", "69.5");
INSERT INTO "country" VALUES ("TUR", "Turkey", "Asia", "Western Asia", "66000000", "71.8");
INSERT INTO "country" VALUES ("THA", "Thailand", "Asia", "Southeast Asia", "61000000", "69.1");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "Asia", "Southeast Asia", "45000000", "54.9");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Asia", "Eastern Asia", "47000000", "74.4");
INSERT INTO "country" VALUES ("PRK", "North Korea", "Asia", "Eastern Asia", "24000000", "66.8");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "Asia", "Southeast Asia", "22000000", "70.8");
INSERT INTO "country" VALUES ("NPL", "Nepal", "Asia", "Southern and Central Asia", "23000000", "57.8");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "Central Asia", "24000000", "63.7");
INSERT INTO "country" VALUES ("LAO", "Laos", "Asia", "Southeast Asia", "5400000", "53.1");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "Asia", "Southeast Asia", "11000000", "56.5");
INSERT INTO "country" VALUES ("LKA", "Sri Lanka", "Asia", "Southern and Central Asia", "19000000", "71.5");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Asia", "Southeast Asia", "3500000", "80.1");
INSERT INTO "country" VALUES ("HKG", "Hong Kong", "Asia", "Eastern Asia", "6700000", "82.2");
INSERT INTO "country" VALUES ("TWN", "Taiwan", "Asia", "Eastern Asia", "22000000", "76.4");
INSERT INTO "country" VALUES ("ISR", "Israel", "Asia", "Middle East", "6200000", "78.6");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "Asia", "Middle East", "21000000", "67.8");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "Asia", "Middle East", "2900000", "74.1");
INSERT INTO "country" VALUES ("SYR", "Syria", "Asia", "Middle East", "16000000", "68.5");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "Asia", "Middle East", "23000000", "66.5");
INSERT INTO "country" VALUES ("YEM", "Yemen", "Asia", "Middle East", "18000000", "59.8");
INSERT INTO "country" VALUES ("OMN", "Oman", "Asia", "Middle East", "2500000", "71.8");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "Asia", "Middle East", "2000000", "74.9");
INSERT INTO "country" VALUES ("JOR", "Jordan", "Asia", "Middle East", "4900000", "72.5");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "Asia", "Middle East", "3300000", "71.3");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Asia", "Middle East", "700000", "72.4");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "Asia", "Middle East", "600000", "73.0");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "Asia", "Middle East", "700000", "76.7");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "Australia and New Zealand", "18000000", "79.8");
INSERT INTO "country" VALUES ("NZL", "New Zealand", "Oceania", "Australia and New Zealand", "3800000", "77.5");
INSERT INTO "country" VALUES ("PNG", "Papua New Guinea", "Oceania", "Melanesia", "4800000", "59.4");
INSERT INTO "country" VALUES ("FJI", "Fiji", "Oceania", "Melanesia", "800000", "67.9");
INSERT INTO "country" VALUES ("SLB", "Solomon Islands", "Oceania", "Melanesia", "400000", "62.0");
INSERT INTO "country" VALUES ("VUT", "Vanuatu", "Oceania", "Melanesia", "200000", "60.6");
INSERT INTO "country" VALUES ("NCL", "New Caledonia", "Oceania", "Melanesia", "200000", "72.0");
INSERT INTO "country" VALUES ("PYF", "French Polynesia", "Oceania", "Polynesia", "200000", "74.0");
INSERT INTO "country" VALUES ("WSM", "Samoa", "Oceania", "Polynesia", "170000", "69.2");
INSERT INTO "country" VALUES ("TON", "Tonga", "Oceania", "Polynesia", "100000", "67.9");
INSERT INTO "country" VALUES ("KIR", "Kiribati", "Oceania", "Micronesia", "90000", "60.0");
INSERT INTO "country" VALUES ("FSM", "Micronesia, Federated States of", "Oceania", "Micronesia", "100000", "68.0");
INSERT INTO "country" VALUES ("MHL", "Marshall Islands", "Oceania", "Micronesia", "60000", "65.0");
INSERT INTO "country" VALUES ("PLW", "Palau", "Oceania", "Micronesia", "20000", "69.0");
INSERT INTO "country" VALUES ("NRU", "Nauru", "Oceania", "Micronesia", "10000", "60.0");
INSERT INTO "country" VALUES ("TUV", "Tuvalu", "Oceania", "Polynesia", "10000", "66.0");
INSERT INTO "country" VALUES ("COK", "Cook Islands", "Oceania", "Polynesia", "20000", "71.0");
INSERT INTO "country" VALUES ("NIU", "Niue", "Oceania", "Polynesia", "2000", "68.0");
INSERT INTO "country" VALUES ("TKL", "Tokelau", "Oceania", "Polynesia", "2000", "60.0");
INSERT INTO "country" VALUES ("WLF", "Wallis and Futuna", "Oceania", "Polynesia", "10000", "67.0");
INSERT INTO "country" VALUES ("ASM", "American Samoa", "Oceania", "Polynesia", "60000", "75.0");
INSERT INTO "country" VALUES ("GUM", "Guam", "Oceania", "Micronesia", "160000", "77.0");
INSERT INTO "country" VALUES ("MNP", "Northern Mariana Islands", "Oceania", "Micronesia", "70000", "76.0");
INSERT INTO "country" VALUES ("PCN", "Pitcairn", "Oceania", "Polynesia", "50", "70.0");
INSERT INTO "country" VALUES ("SJM", "Svalbard and Jan Mayen", "Europe", "Northern Europe", "3000", "78.0");
INSERT INTO "country" VALUES ("GRL", "Greenland", "North America", "North America", "50000", "68.0");
INSERT INTO "country" VALUES ("SPM", "Saint Pierre and Miquelon", "North America", "North America", "7000", "78.0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "Antarctica", "0", "NULL");