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) UNIQUE,
"Name" CHAR(52),
"Continent" TEXT,
"Population" INT,
"GNP" FLOAT,
PRIMARY KEY ("Code")
);

CREATE TABLE "countrylanguage" (
"CountryCode" CHAR(3),
"Language" CHAR(30),
"IsOfficial" TEXT,
"Percentage" FLOAT,
PRIMARY KEY ("CountryCode", "Language"),
FOREIGN KEY ("CountryCode") REFERENCES "country"("Code")
);





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", "127800");
INSERT INTO "city" VALUES ("5", "Amsterdam", "731200");
INSERT INTO "city" VALUES ("6", "Rotterdam", "593321");
INSERT INTO "city" VALUES ("7", "Haag", "440900");
INSERT INTO "city" VALUES ("8", "Utrecht", "234323");
INSERT INTO "city" VALUES ("9", "Eindhoven", "201843");
INSERT INTO "city" VALUES ("10", "Groningen", "172700");
INSERT INTO "city" VALUES ("11", "Tripoli", "1800000");
INSERT INTO "city" VALUES ("12", "Benghazi", "850000");
INSERT INTO "city" VALUES ("13", "Misratah", "200000");
INSERT INTO "city" VALUES ("14", "Al-Bayda", "100000");
INSERT INTO "city" VALUES ("15", "Tokyo", "7980000");
INSERT INTO "city" VALUES ("16", "Yokohama", "3300000");
INSERT INTO "city" VALUES ("17", "Osaka", "2500000");
INSERT INTO "city" VALUES ("18", "Nagoya", "2100000");
INSERT INTO "city" VALUES ("19", "Sapporo", "1800000");
INSERT INTO "city" VALUES ("20", "Fukuoka", "1300000");
INSERT INTO "city" VALUES ("21", "Seoul", "9980000");
INSERT INTO "city" VALUES ("22", "Busan", "3500000");
INSERT INTO "city" VALUES ("23", "Incheon", "2700000");
INSERT INTO "city" VALUES ("24", "Daegu", "2400000");
INSERT INTO "city" VALUES ("25", "Daejeon", "1500000");
INSERT INTO "city" VALUES ("26", "Gwangju", "1400000");
INSERT INTO "city" VALUES ("27", "Ulsan", "1100000");
INSERT INTO "city" VALUES ("28", "Suwon", "1000000");
INSERT INTO "city" VALUES ("29", "Cairo", "6789000");
INSERT INTO "city" VALUES ("30", "Alexandria", "3500000");
INSERT INTO "city" VALUES ("31", "Giza", "2500000");
INSERT INTO "city" VALUES ("32", "Shubra al-Khaymah", "1000000");
INSERT INTO "city" VALUES ("33", "Port Said", "500000");
INSERT INTO "city" VALUES ("34", "Suez", "450000");
INSERT INTO "city" VALUES ("35", "Luxor", "400000");
INSERT INTO "city" VALUES ("36", "Aswan", "300000");
INSERT INTO "city" VALUES ("37", "Asyut", "250000");
INSERT INTO "city" VALUES ("38", "Faiyum", "200000");
INSERT INTO "city" VALUES ("39", "Ismailia", "150000");
INSERT INTO "city" VALUES ("40", "Zagazig", "100000");
INSERT INTO "city" VALUES ("41", "Tanta", "90000");
INSERT INTO "city" VALUES ("42", "Damietta", "80000");
INSERT INTO "city" VALUES ("43", "Minya", "70000");
INSERT INTO "city" VALUES ("44", "Damanhur", "60000");
INSERT INTO "city" VALUES ("45", "Sohag", "50000");
INSERT INTO "city" VALUES ("46", "Beni Suef", "40000");
INSERT INTO "city" VALUES ("47", "Qena", "30000");
INSERT INTO "city" VALUES ("48", "Kafr el-Sheikh", "20000");
INSERT INTO "city" VALUES ("49", "Marsa Matruh", "10000");
INSERT INTO "city" VALUES ("50", "Arish", "5000");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "22720000", "5976.00");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "Europe", "15988000", "371362.00");
INSERT INTO "country" VALUES ("LBY", "Libyan Arab Jamahiriya", "Africa", "5670000", "10000.00");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "126714000", "3787042.00");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Asia", "46844000", "426067.00");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "68470000", "82710.00");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "1277558000", "1192376.00");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "1013662000", "447114.00");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "Asia", "212107000", "283455.00");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "Asia", "156483000", "61289.00");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "129155000", "40000.00");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "Asia", "79832000", "28628.00");
INSERT INTO "country" VALUES ("PHL", "Philippines", "Asia", "75967000", "72283.00");
INSERT INTO "country" VALUES ("THA", "Thailand", "Asia", "61399000", "116457.00");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "Asia", "45611000", "10000.00");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "Asia", "22244000", "97469.00");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "24318000", "13793.00");
INSERT INTO "country" VALUES ("KAZ", "Kazakstan", "Asia", "16223000", "17250.00");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "Asia", "21607000", "137000.00");
INSERT INTO "country" VALUES ("IRN", "Iran", "Asia", "67702000", "162300.00");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "Asia", "23115000", "5912.00");
INSERT INTO "country" VALUES ("YEM", "Yemen", "Asia", "18112000", "6041.00");
INSERT INTO "country" VALUES ("SYR", "Syria", "Asia", "16125000", "18230.00");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "Asia", "2441000", "60734.00");
INSERT INTO "country" VALUES ("ISR", "Israel", "Asia", "6217000", "97477.00");
INSERT INTO "country" VALUES ("JOR", "Jordan", "Asia", "5083000", "7526.00");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "Asia", "3286000", "17000.00");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "Asia", "1972000", "29350.00");
INSERT INTO "country" VALUES ("OMN", "Oman", "Asia", "2542000", "16880.00");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Asia", "769000", "11400.00");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "Asia", "617000", "6366.00");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "Asia", "759000", "11200.00");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Asia", "5404000", "6060.00");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Asia", "3520000", "1832.00");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "Asia", "7734000", "4127.00");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "Asia", "4518000", "4397.00");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "Asia", "4690000", "1626.00");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "Asia", "6188000", "1996.00");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "Asia", "2654000", "1043.00");
INSERT INTO "country" VALUES ("PRK", "North Korea", "Asia", "23348000", "5300.00");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Asia", "3567000", "85900.00");
INSERT INTO "country" VALUES ("HKG", "Hong Kong", "Asia", "6782000", "166448.00");
INSERT INTO "country" VALUES ("TWN", "Taiwan", "Asia", "22256000", "251460.00");
INSERT INTO "country" VALUES ("BRN", "Brunei", "Asia", "336000", "3563.00");
INSERT INTO "country" VALUES ("MAC", "Macao", "Asia", "473000", "5749.00");
INSERT INTO "country" VALUES ("TLS", "East Timor", "Asia", "885000", "0.00");
INSERT INTO "country" VALUES ("LAO", "Laos", "Asia", "5493000", "1292.00");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "Asia", "11168000", "2923.00");
INSERT INTO "country" VALUES ("MHL", "Marshall Islands", "Oceania", "68000", "0.00");
INSERT INTO "country" VALUES ("FSM", "Micronesia, Federated States of", "Oceania", "119000", "210.00");
INSERT INTO "country" VALUES ("PLW", "Palau", "Oceania", "19000", "100.00");
INSERT INTO "country" VALUES ("NRU", "Nauru", "Oceania", "10000", "18.00");
INSERT INTO "country" VALUES ("KIR", "Kiribati", "Oceania", "83000", "40.00");
INSERT INTO "country" VALUES ("TUV", "Tuvalu", "Oceania", "11000", "12.00");
INSERT INTO "country" VALUES ("WSM", "Samoa", "Oceania", "180000", "283.00");
INSERT INTO "country" VALUES ("TON", "Tonga", "Oceania", "99000", "146.00");
INSERT INTO "country" VALUES ("FJI", "Fiji Islands", "Oceania", "817000", "1868.00");
INSERT INTO "country" VALUES ("VUT", "Vanuatu", "Oceania", "190000", "271.00");
INSERT INTO "country" VALUES ("SLB", "Solomon Islands", "Oceania", "442000", "182.00");
INSERT INTO "country" VALUES ("PNG", "Papua New Guinea", "Oceania", "4807000", "4922.00");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "18886000", "351100.00");
INSERT INTO "country" VALUES ("NZL", "New Zealand", "Oceania", "3862000", "58531.00");
INSERT INTO "country" VALUES ("PYF", "French Polynesia", "Oceania", "235000", "4725.00");
INSERT INTO "country" VALUES ("NCL", "New Caledonia", "Oceania", "210000", "3500.00");
INSERT INTO "country" VALUES ("WLF", "Wallis and Futuna", "Oceania", "15000", "0.00");
INSERT INTO "country" VALUES ("NIU", "Niue", "Oceania", "2000", "0.00");
INSERT INTO "country" VALUES ("COK", "Cook Islands", "Oceania", "20000", "100.00");
INSERT INTO "country" VALUES ("TKL", "Tokelau", "Oceania", "2000", "0.00");
INSERT INTO "country" VALUES ("PCN", "Pitcairn", "Oceania", "50", "0.00");
INSERT INTO "country" VALUES ("HMD", "Heard and McDonald Islands", "Antarctica", "0", "0.00");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0", "0.00");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0", "0.00");
INSERT INTO "country" VALUES ("ATF", "French Southern territories", "Antarctica", "0", "0.00");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0", "0.00");
INSERT INTO "country" VALUES ("SPM", "Saint Pierre and Miquelon", "North America", "7000", "0.00");
INSERT INTO "country" VALUES ("GRL", "Greenland", "North America", "56000", "0.00");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "31147000", "653020.00");
INSERT INTO "country" VALUES ("USA", "United States", "North America", "278357000", "8510700.00");
INSERT INTO "country" VALUES ("MEX", "Mexico", "North America", "98881000", "417215.00");
INSERT INTO "country" VALUES ("BLZ", "Belize", "North America", "241000", "630.00");
INSERT INTO "country" VALUES ("GTM", "Guatemala", "North America", "11385000", "19000.00");
INSERT INTO "country" VALUES ("SLV", "El Salvador", "North America", "6218000", "11800.00");
INSERT INTO "country" VALUES ("HND", "Honduras", "North America", "6485000", "5333.00");
INSERT INTO "country" VALUES ("NIC", "Nicaragua", "North America", "5074000", "2188.00");
INSERT INTO "country" VALUES ("CRI", "Costa Rica", "North America", "4023000", "10211.00");
INSERT INTO "country" VALUES ("PAN", "Panama", "North America", "2856000", "9133.00");
INSERT INTO "country" VALUES ("CUB", "Cuba", "North America", "11201000", "18700.00");
INSERT INTO "country" VALUES ("JAM", "Jamaica", "North America", "2583000", "6870.00");
INSERT INTO "country" VALUES ("HTI", "Haiti", "North America", "8222000", "3630.00");
INSERT INTO "country" VALUES ("DOM", "Dominican Republic", "North America", "8495000", "16000.00");
INSERT INTO "country" VALUES ("PRI", "Puerto Rico", "North America", "3860000", "34100.00");
INSERT INTO "country" VALUES ("GLP", "Guadeloupe", "North America", "431000", "0.00");
INSERT INTO "country" VALUES ("MTQ", "Martinique", "North America", "395000", "0.00");
INSERT INTO "country" VALUES ("BLM", "Saint Barthélemy", "North America", "7000", "0.00");
INSERT INTO "country" VALUES ("MAF", "Saint Martin", "North America", "30000", "0.00");
INSERT INTO "country" VALUES ("AIA", "Anguilla", "North America", "10000", "100.00");
INSERT INTO "country" VALUES ("KNA", "Saint Kitts and Nevis", "North America", "40000", "290.00");
INSERT INTO "country" VALUES ("ATG", "Antigua and Barbuda", "North America", "68000", "612.00");
INSERT INTO "country" VALUES ("MSR", "Montserrat", "North America", "10000", "0.00");
INSERT INTO "country" VALUES ("DMA", "Dominica", "North America", "71000", "256.00");
INSERT INTO "country" VALUES ("LCA", "Saint Lucia", "North America", "154000", "571.00");
INSERT INTO "country" VALUES ("VCT", "Saint Vincent and the Grenadines", "North America", "114000", "310.00");
INSERT INTO "country" VALUES ("BRB", "Barbados", "North America", "270000", "2261.00");
INSERT INTO "country" VALUES ("GRD", "Grenada", "North America", "94000", "320.00");
INSERT INTO "country" VALUES ("TTO", "Trinidad and Tobago", "North America", "1295000", "6232.00");
INSERT INTO "country" VALUES ("ABW", "Aruba", "North America", "103000", "1773.00");
INSERT INTO "country" VALUES ("ANT", "Netherlands Antilles", "North America", "217000", "1941.00");
INSERT INTO "country" VALUES ("BHS", "Bahamas", "North America", "307000", "3527.00");
INSERT INTO "country" VALUES ("TCA", "Turks and Caicos Islands", "North America", "17000", "0.00");
INSERT INTO "country" VALUES ("CYM", "Cayman Islands", "North America", "38000", "1263.00");
INSERT INTO "country" VALUES ("BMU", "Bermuda", "North America", "65000", "2320.00");
INSERT INTO "country" VALUES ("VGB", "Virgin Islands, British", "North America", "21000", "0.00");
INSERT INTO "country" VALUES ("VIR", "Virgin Islands, U.S.", "North America", "112000", "0.00");
INSERT INTO "country" VALUES ("KNA", "Saint Kitts and Nevis", "North America", "40000", "290.00");
INSERT INTO "country" VALUES ("ATG", "Antigua and Barbuda", "North America", "68000", "612.00");
INSERT INTO "country" VALUES ("MSR", "Montserrat", "North America", "10000", "0.00");
INSERT INTO "country" VALUES ("DMA", "Dominica", "North America", "71000", "256.00");
INSERT INTO "country" VALUES ("LCA", "Saint Lucia", "North America", "154000", "571.00");
INSERT INTO "country" VALUES ("VCT", "Saint Vincent and the Grenadines", "North America", "114000", "310.00");
INSERT INTO "country" VALUES ("BRB", "Barbados", "North America", "270000", "2261.00");
INSERT INTO "country" VALUES ("GRD", "Grenada", "North America", "94000", "320.00");
INSERT INTO "country" VALUES ("TTO", "Trinidad and Tobago", "North America", "1295000", "6232.00");
INSERT INTO "country" VALUES ("ABW", "Aruba", "North America", "103000", "1773.00");
INSERT INTO "country" VALUES ("ANT", "Netherlands Antilles", "North America", "217000", "1941.00");
INSERT INTO "country" VALUES ("BHS", "Bahamas", "North America", "307000", "3527.00");
INSERT INTO "country" VALUES ("TCA", "Turks and Caicos Islands", "North America", "17000", "0.00");
INSERT INTO "country" VALUES ("CYM", "Cayman Islands", "North America", "38000", "1263.00");
INSERT INTO "country" VALUES ("BMU", "Bermuda", "North America", "65000", "2320.00");
INSERT INTO "country" VALUES ("VGB", "Virgin Islands, British", "North America", "21000", "0.00");
INSERT INTO "country" VALUES ("VIR", "Virgin Islands, U.S.", "North America", "112000", "0.00");
INSERT INTO "country" VALUES ("ARG", "Argentina", "South America", "37032000", "340238.00");
INSERT INTO "country" VALUES ("BOL", "Bolivia", "South America", "8329000", "8574.00");
INSERT INTO "country" VALUES ("BRA", "Brazil", "South America", "170115000", "776739.00");
INSERT INTO "country" VALUES ("CHL", "Chile", "South America", "15211000", "72784.00");
INSERT INTO "country" VALUES ("COL", "Colombia", "South America", "42321000", "102877.00");
INSERT INTO "country" VALUES ("ECU", "Ecuador", "South America", "12646000", "13991.00");
INSERT INTO "country" VALUES ("FLK", "Falkland Islands", "South America", "2000", "0.00");
INSERT INTO "country" VALUES ("GUF", "French Guiana", "South America", "181000", "0.00");
INSERT INTO "country" VALUES ("GUY", "Guyana", "South America", "751000", "722.00");
INSERT INTO "country" VALUES ("PRY", "Paraguay", "South America", "5496000", "7848.00");
INSERT INTO "country" VALUES ("PER", "Peru", "South America", "25662000", "64207.00");
INSERT INTO "country" VALUES ("SUR", "Suriname", "South America", "417000", "870.00");
INSERT INTO "country" VALUES ("URY", "Uruguay", "South America", "3337000", "20831.00");
INSERT INTO "country" VALUES ("VEN", "Venezuela", "South America", "24170000", "95029.00");
INSERT INTO "country" VALUES ("FRA", "France", "Europe", "59225000", "1424285.00");
INSERT INTO "country" VALUES ("DEU", "Germany", "Europe", "82164000", "2133367.00");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "Europe", "59623000", "1378330.00");
INSERT INTO "country" VALUES ("ITA", "Italy", "Europe", "57679000", "1161483.00");
INSERT INTO "country" VALUES ("ESP", "Spain", "Europe", "39441000", "553233.00");
INSERT INTO "country" VALUES ("POL", "Poland", "Europe", "38625000", "151697.00");
INSERT INTO "country" VALUES ("ROU", "Romania", "Europe", "22455000", "38158.00");
INSERT INTO "country" VALUES ("UKR", "Ukraine", "Europe", "50456000", "42914.00");
INSERT INTO "country" VALUES ("RUS", "Russian Federation", "Europe", "146934000", "276608.00");