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")
);

CREATE TABLE "countrylanguage" (
"CountryCode" CHAR(3),
"Language" CHAR(30),
PRIMARY KEY ("CountryCode", "Language")
);





INSERT INTO "city" VALUES ("1", "Kabul", "1780000");
INSERT INTO "city" VALUES ("2", "Qandahar", "237500");
INSERT INTO "city" VALUES ("3", "Herat", "186800");
INSERT INTO "city" VALUES ("4", "Mazar-e-Sharif", "237600");
INSERT INTO "city" VALUES ("5", "Amsterdam", "731200");
INSERT INTO "city" VALUES ("6", "Rotterdam", "593321");
INSERT INTO "city" VALUES ("7", "The Hague", "440900");
INSERT INTO "city" VALUES ("8", "Utrecht", "234323");
INSERT INTO "city" VALUES ("9", "Eindhoven", "201843");
INSERT INTO "city" VALUES ("10", "Tilburg", "193238");
INSERT INTO "city" VALUES ("11", "Groningen", "172710");
INSERT INTO "city" VALUES ("12", "Breda", "160397");
INSERT INTO "city" VALUES ("13", "Apeldoorn", "153491");
INSERT INTO "city" VALUES ("14", "Nijmegen", "152463");
INSERT INTO "city" VALUES ("15", "Enschede", "149527");
INSERT INTO "city" VALUES ("16", "Haarlem", "148764");
INSERT INTO "city" VALUES ("17", "Almere", "142465");
INSERT INTO "city" VALUES ("18", "Arnhem", "138020");
INSERT INTO "city" VALUES ("19", "Zaanstad", "135621");
INSERT INTO "city" VALUES ("20", "Amersfoort", "126270");
INSERT INTO "city" VALUES ("21", "Haarlemmermeer", "126270");
INSERT INTO "city" VALUES ("22", "s-Hertogenbosch", "124300");
INSERT INTO "city" VALUES ("23", "Dordrecht", "119811");
INSERT INTO "city" VALUES ("24", "Leiden", "117196");
INSERT INTO "city" VALUES ("25", "Maastricht", "122087");
INSERT INTO "city" VALUES ("26", "Zoetermeer", "110915");
INSERT INTO "city" VALUES ("27", "Zwolle", "105801");
INSERT INTO "city" VALUES ("28", "Ede", "101574");
INSERT INTO "city" VALUES ("29", "Delft", "96095");
INSERT INTO "city" VALUES ("30", "Heerlen", "95053");
INSERT INTO "city" VALUES ("31", "Venlo", "92403");
INSERT INTO "city" VALUES ("32", "Leeuwarden", "91818");
INSERT INTO "city" VALUES ("33", "Alkmaar", "89634");
INSERT INTO "city" VALUES ("34", "Emmen", "88432");
INSERT INTO "city" VALUES ("35", "Westland", "83358");
INSERT INTO "city" VALUES ("36", "Delft", "96095");
INSERT INTO "city" VALUES ("37", "Heerlen", "95053");
INSERT INTO "city" VALUES ("38", "Venlo", "92403");
INSERT INTO "city" VALUES ("39", "Leeuwarden", "91818");
INSERT INTO "city" VALUES ("40", "Alkmaar", "89634");
INSERT INTO "city" VALUES ("41", "Emmen", "88432");
INSERT INTO "city" VALUES ("42", "Westland", "83358");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "22720000");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "Europe", "15864000");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "Africa", "11669000");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "Africa", "9169000");
INSERT INTO "country" VALUES ("AGO", "Angola", "Africa", "12878000");
INSERT INTO "country" VALUES ("BDI", "Burundi", "Africa", "6695000");
INSERT INTO "country" VALUES ("BFA", "Burkina Faso", "Africa", "11937000");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "129155000");
INSERT INTO "country" VALUES ("BTN", "Bhutan", "Asia", "2120000");
INSERT INTO "country" VALUES ("CAF", "Central African Republic", "Africa", "3695000");
INSERT INTO "country" VALUES ("CMR", "Cameroon", "Africa", "15085000");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "1277558000");
INSERT INTO "country" VALUES ("COD", "Congo, The Democratic Republic of the", "Africa", "50458000");
INSERT INTO "country" VALUES ("COG", "Congo", "Africa", "2943000");
INSERT INTO "country" VALUES ("CIV", "Cote d'Ivoire", "Africa", "14782000");
INSERT INTO "country" VALUES ("DJI", "Djibouti", "Africa", "691000");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "68470000");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "Africa", "3850000");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "Africa", "62565000");
INSERT INTO "country" VALUES ("GAB", "Gabon", "Africa", "1226000");
INSERT INTO "country" VALUES ("GHA", "Ghana", "Africa", "20212000");
INSERT INTO "country" VALUES ("GIN", "Guinea", "Africa", "7494000");
INSERT INTO "country" VALUES ("GMB", "Gambia", "Africa", "1305000");
INSERT INTO "country" VALUES ("GNB", "Guinea-Bissau", "Africa", "1213000");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "1013662000");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "Asia", "212107000");
INSERT INTO "country" VALUES ("IRN", "Iran, Islamic Republic of", "Asia", "67191000");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "Asia", "23115000");
INSERT INTO "country" VALUES ("ISR", "Israel", "Asia", "6217000");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "126714000");
INSERT INTO "country" VALUES ("KEN", "Kenya", "Africa", "30339000");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Asia", "46844000");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "Asia", "1972000");
INSERT INTO "country" VALUES ("LAO", "Lao People's Democratic Republic", "Asia", "5417000");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "Asia", "3286000");
INSERT INTO "country" VALUES ("LBR", "Liberia", "Africa", "3154000");
INSERT INTO "country" VALUES ("LBY", "Libyan Arab Jamahiriya", "Africa", "5670000");
INSERT INTO "country" VALUES ("LSO", "Lesotho", "Africa", "2153000");
INSERT INTO "country" VALUES ("MDG", "Madagascar", "Africa", "15942000");
INSERT INTO "country" VALUES ("MLI", "Mali", "Africa", "11241000");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "Asia", "45611000");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "Asia", "2654000");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "Africa", "17938000");
INSERT INTO "country" VALUES ("MRT", "Mauritania", "Africa", "2670000");
INSERT INTO "country" VALUES ("MWI", "Malawi", "Africa", "10470000");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "Asia", "22244000");
INSERT INTO "country" VALUES ("NAM", "Namibia", "Africa", "1726000");
INSERT INTO "country" VALUES ("NER", "Niger", "Africa", "10146000");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Africa", "111506000");
INSERT INTO "country" VALUES ("OMN", "Oman", "Asia", "2441000");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "Asia", "156487000");
INSERT INTO "country" VALUES ("PHL", "Philippines", "Asia", "75974000");
INSERT INTO "country" VALUES ("PRK", "North Korea", "Asia", "23479000");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Asia", "599000");
INSERT INTO "country" VALUES ("RWA", "Rwanda", "Africa", "7733000");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "Asia", "21607000");
INSERT INTO "country" VALUES ("SDN", "Sudan", "Africa", "30921000");
INSERT INTO "country" VALUES ("SEN", "Senegal", "Africa", "9481000");
INSERT INTO "country" VALUES ("SLE", "Sierra Leone", "Africa", "4843000");
INSERT INTO "country" VALUES ("SOM", "Somalia", "Africa", "10100000");
INSERT INTO "country" VALUES ("SYR", "Syrian Arab Republic", "Asia", "16227000");
INSERT INTO "country" VALUES ("TGO", "Togo", "Africa", "4625000");
INSERT INTO "country" VALUES ("THA", "Thailand", "Asia", "61399000");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "Asia", "6188000");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "Asia", "4518000");
INSERT INTO "country" VALUES ("TUN", "Tunisia", "Africa", "9586000");
INSERT INTO "country" VALUES ("TUR", "Turkey", "Asia", "66591000");
INSERT INTO "country" VALUES ("UGA", "Uganda", "Africa", "21778000");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "Asia", "2441000");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "24318000");
INSERT INTO "country" VALUES ("VNM", "Viet Nam", "Asia", "79832000");
INSERT INTO "country" VALUES ("YEM", "Yemen", "Asia", "18112000");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "40350000");
INSERT INTO "country" VALUES ("COM", "Comoros", "Africa", "578000");
INSERT INTO "country" VALUES ("CPV", "Cape Verde", "Africa", "435000");
INSERT INTO "country" VALUES ("SWZ", "Swaziland", "Africa", "1083000");
INSERT INTO "country" VALUES ("STP", "Sao Tome and Principe", "Africa", "147000");
INSERT INTO "country" VALUES ("REU", "Reunion", "Africa", "720000");
INSERT INTO "country" VALUES ("MYT", "Mayotte", "Africa", "163000");
INSERT INTO "country" VALUES ("MUS", "Mauritius", "Africa", "1168000");
INSERT INTO "country" VALUES ("MDV", "Maldives", "Asia", "307000");
INSERT INTO "country" VALUES ("LCA", "Saint Lucia", "North America", "154000");
INSERT INTO "country" VALUES ("KIR", "Kiribati", "Oceania", "83000");
INSERT INTO "country" VALUES ("KNA", "Saint Kitts and Nevis", "North America", "38000");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "Asia", "11168000");
INSERT INTO "country" VALUES ("JOR", "Jordan", "Asia", "4823000");
INSERT INTO "country" VALUES ("JAM", "Jamaica", "North America", "2583000");
INSERT INTO "country" VALUES ("IRL", "Ireland", "Europe", "3788000");
INSERT INTO "country" VALUES ("ISL", "Iceland", "Europe", "279000");
INSERT INTO "country" VALUES ("HND", "Honduras", "North America", "6485000");
INSERT INTO "country" VALUES ("GUY", "Guyana", "South America", "760000");
INSERT INTO "country" VALUES ("GTM", "Guatemala", "North America", "11385000");
INSERT INTO "country" VALUES ("GRD", "Grenada", "North America", "94000");
INSERT INTO "country" VALUES ("GRC", "Greece", "Europe", "10545000");
INSERT INTO "country" VALUES ("GIB", "Gibraltar", "Europe", "25000");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Asia", "5404000");
INSERT INTO "country" VALUES ("DEU", "Germany", "Europe", "82164000");
INSERT INTO "country" VALUES ("FRA", "France", "Europe", "59226000");
INSERT INTO "country" VALUES ("FIN", "Finland", "Europe", "5171000");
INSERT INTO "country" VALUES ("FJI", "Fiji Islands", "Oceania", "817000");
INSERT INTO "country" VALUES ("EST", "Estonia", "Europe", "1439000");
INSERT INTO "country" VALUES ("ESP", "Spain", "Europe", "39441700");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "Africa", "3850000");
INSERT INTO "country" VALUES ("DNK", "Denmark", "Europe", "5330000");
INSERT INTO "country" VALUES ("DOM", "Dominican Republic", "North America", "8495000");
INSERT INTO "country" VALUES ("DMA", "Dominica", "North America", "71000");
INSERT INTO "country" VALUES ("CZE", "Czech Republic", "Europe", "10278100");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "Asia", "759000");
INSERT INTO "country" VALUES ("CUB", "Cuba", "North America", "11187000");
INSERT INTO "country" VALUES ("HRV", "Croatia", "Europe", "4473000");
INSERT INTO "country" VALUES ("CRI", "Costa Rica", "North America", "3773000");
INSERT INTO "country" VALUES ("COL", "Colombia", "South America", "42321000");
INSERT INTO "country" VALUES ("CHL", "Chile", "South America", "15211000");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "31147000");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("BRN", "Brunei Darussalam", "Asia", "336000");
INSERT INTO "country" VALUES ("BRA", "Brazil", "South America", "170115000");
INSERT INTO "country" VALUES ("BLZ", "Belize", "North America", "241000");
INSERT INTO "country" VALUES ("BLR", "Belarus", "Europe", "10366000");
INSERT INTO "country" VALUES ("BEL", "Belgium", "Europe", "10239000");
INSERT INTO "country" VALUES ("BHS", "Bahamas", "North America", "307000");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "Asia", "617000");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "129155000");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "Asia", "7734000");
INSERT INTO "country" VALUES ("AUT", "Austria", "Europe", "8091000");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "18886000");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Asia", "3520000");
INSERT INTO "country" VALUES ("ARG", "Argentina", "South America", "37032000");
INSERT INTO "country" VALUES ("ATG", "Antigua and Barbuda", "North America", "68000");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("AND", "Andorra", "Europe", "78000");
INSERT INTO "country" VALUES ("ALB", "Albania", "Europe", "3401000");
INSERT INTO "country" VALUES ("DZA", "Algeria", "Africa", "31471000");
INSERT INTO "country" VALUES ("ASM", "American Samoa", "Oceania", "68000");
INSERT INTO "country" VALUES ("SMR", "San Marino", "Europe", "27000");
INSERT INTO "country" VALUES ("VAT", "Holy See Vatican City State", "Europe", "1000");
INSERT INTO "country" VALUES ("MCO", "Monaco", "Europe", "34000");
INSERT INTO "country" VALUES ("LIE", "Liechtenstein", "Europe", "32000");
INSERT INTO "country" VALUES ("MLT", "Malta", "Europe", "380000");
INSERT INTO "country" VALUES ("LUX", "Luxembourg", "Europe", "435000");
INSERT INTO "country" VALUES ("ISL", "Iceland", "Europe", "279000");
INSERT INTO "country" VALUES ("FRO", "Faroe Islands", "Europe", "43000");
INSERT INTO "country" VALUES ("GIB", "Gibraltar", "Europe", "25000");
INSERT INTO "country" VALUES ("AND", "Andorra", "Europe", "78000");
INSERT INTO "country" VALUES ("SJM", "Svalbard and Jan Mayen", "Europe", "32000");
INSERT INTO "country" VALUES ("GGY", "Guernsey", "Europe", "64000");
INSERT INTO "country" VALUES ("JEY", "Jersey", "Europe", "89000");
INSERT INTO "country" VALUES ("IMN", "Isle of Man", "Europe", "73000");
INSERT INTO "country" VALUES ("ALA", "Aland Islands", "Europe", "26000");
INSERT INTO "country" VALUES ("GRL", "Greenland", "North America", "56000");
INSERT INTO "country" VALUES ("SPM", "Saint Pierre and Miquelon", "North America", "7000");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("NFK", "Norfolk Island", "Oceania", "2000");
INSERT INTO "country" VALUES ("PCN", "Pitcairn", "Oceania", "50");
INSERT INTO "country" VALUES ("TKL", "Tokelau", "Oceania", "1500");
INSERT INTO "country" VALUES ("WLF", "Wallis and Futuna", "Oceania", "15000");
INSERT INTO "country" VALUES ("NIU", "Niue", "Oceania", "2000");
INSERT INTO "country" VALUES ("COK", "Cook Islands", "Oceania", "20000");
INSERT INTO "country" VALUES ("TUV", "Tuvalu", "Oceania", "11000");
INSERT INTO "country" VALUES ("NRU", "Nauru", "Oceania", "10000");
INSERT INTO "country" VALUES ("MHL", "Marshall Islands", "Oceania", "64000");
INSERT INTO "country" VALUES ("FSM", "Micronesia, Federated States of", "Oceania", "119000");
INSERT INTO "country" VALUES ("PLW", "Palau", "Oceania", "19000");
INSERT INTO "country" VALUES ("MNP", "Northern Mariana Islands", "Oceania", "78000");
INSERT INTO "country" VALUES ("GUM", "Guam", "Oceania", "168000");
INSERT INTO "country" VALUES ("ASM", "American Samoa", "Oceania", "68000");
INSERT INTO "country" VALUES ("PYF", "French Polynesia", "Oceania", "235000");
INSERT INTO "country" VALUES ("NCL", "New Caledonia", "Oceania", "210000");
INSERT INTO "country" VALUES ("VUT", "Vanuatu", "Oceania", "190000");
INSERT INTO "country" VALUES ("SLB", "Solomon Islands", "Oceania", "442000");
INSERT INTO "country" VALUES ("PNG", "Papua New Guinea", "Oceania", "4800000");
INSERT INTO "country" VALUES ("TLS", "East Timor", "Asia", "885000");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Asia", "3567000");
INSERT INTO "country" VALUES ("BRN", "Brunei Darussalam", "Asia", "336000");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "Asia", "617000");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Asia", "599000");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "Asia", "2441000");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "Asia", "1972000");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "Asia", "3286000");
INSERT INTO "country" VALUES ("ISR", "Israel", "Asia", "6217000");
INSERT INTO "country" VALUES ("JOR", "Jordan", "Asia", "4823000");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "Asia", "759000");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Asia", "3520000");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Asia", "5404000");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "Asia", "7734000");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "Asia", "4699000");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "Asia", "6188000");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "Asia", "4518000");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "24318000");
INSERT INTO "country" VALUES ("KAZ", "Kazakstan", "Asia", "16223000");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "Asia", "2654000");
INSERT INTO "country" VALUES ("PRK", "North Korea", "Asia", "23479000");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Asia", "46844000");
INSERT INTO "country" VALUES ("TWN", "Taiwan", "Asia", "22287000");
INSERT INTO "country" VALUES ("HKG", "Hong Kong", "Asia", "6782000");
INSERT INTO "country" VALUES ("MAC", "Macao", "Asia", "473000");
INSERT INTO "country" VALUES ("LAO", "Lao People's Democratic Republic", "Asia", "5417000");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "Asia", "11168000");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "Asia", "45611000");
INSERT INTO "country" VALUES ("BTN", "Bhutan", "Asia", "2120000");
INSERT INTO "country" VALUES ("NPL", "Nepal", "Asia", "23949000");
INSERT INTO "country" VALUES ("LKA", "Sri Lanka", "Asia", "18827000");
INSERT INTO "country" VALUES ("MDV", "Maldives", "Asia", "307000");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "129155000");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "22720000");
INSERT INTO "country" VALUES ("IRN", "Iran, Islamic Republic of", "Asia", "67191000");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "Asia", "23115000");