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", "200000");
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", "Tilburg", "193238");
INSERT INTO "city" VALUES ("11", "Groningen", "172711");
INSERT INTO "city" VALUES ("12", "Breda", "162053");
INSERT INTO "city" VALUES ("13", "Apeldoorn", "153491");
INSERT INTO "city" VALUES ("14", "Nijmegen", "152463");
INSERT INTO "city" VALUES ("15", "Enschede", "149544");
INSERT INTO "city" VALUES ("16", "Haarlem", "148764");
INSERT INTO "city" VALUES ("17", "Arnhem", "138020");
INSERT INTO "city" VALUES ("18", "Zaanstad", "135621");
INSERT INTO "city" VALUES ("19", "Amersfoort", "126270");
INSERT INTO "city" VALUES ("20", "Den Bosch", "124600");
INSERT INTO "city" VALUES ("21", "Maastricht", "122087");
INSERT INTO "city" VALUES ("22", "Dordrecht", "119811");
INSERT INTO "city" VALUES ("23", "Leiden", "117196");
INSERT INTO "city" VALUES ("24", "Zoetermeer", "110915");
INSERT INTO "city" VALUES ("25", "Emmen", "105972");
INSERT INTO "city" VALUES ("26", "Almere", "142465");
INSERT INTO "city" VALUES ("27", "Zwolle", "105819");
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", "Alkmaar", "92713");
INSERT INTO "city" VALUES ("32", "Leeuwarden", "91818");
INSERT INTO "city" VALUES ("33", "Lausanne", "114900");
INSERT INTO "city" VALUES ("34", "Geneve", "173500");
INSERT INTO "city" VALUES ("35", "Zuerich", "336800");
INSERT INTO "city" VALUES ("36", "Basel", "166000");
INSERT INTO "city" VALUES ("37", "Bern", "122700");
INSERT INTO "city" VALUES ("38", "Winterthur", "87700");
INSERT INTO "city" VALUES ("39", "St Gallen", "67900");
INSERT INTO "city" VALUES ("40", "Lugano", "26000");
INSERT INTO "city" VALUES ("41", "Baku", "1787800");
INSERT INTO "city" VALUES ("42", "Ganja", "299700");
INSERT INTO "city" VALUES ("43", "Sumqayit", "283000");
INSERT INTO "city" VALUES ("44", "Mingaçevir", "93900");
INSERT INTO "city" VALUES ("45", "Naxçivan", "60000");
INSERT INTO "city" VALUES ("46", "Hongkong", "7055071");
INSERT INTO "city" VALUES ("47", "Macau", "429600");
INSERT INTO "city" VALUES ("48", "Singaporen", "4017733");
INSERT INTO "city" VALUES ("49", "Atyrau", "142400");
INSERT INTO "city" VALUES ("50", "Qaraghandy", "436900");
INSERT INTO "city" VALUES ("51", "Qostanay", "221500");
INSERT INTO "city" VALUES ("52", "Astana", "270800");
INSERT INTO "city" VALUES ("53", "Almaty", "1129400");
INSERT INTO "city" VALUES ("54", "Shymkent", "370600");
INSERT INTO "city" VALUES ("55", "Taraz", "330100");
INSERT INTO "city" VALUES ("56", "Öskemen", "344400");
INSERT INTO "city" VALUES ("57", "Pavlodar", "315300");
INSERT INTO "city" VALUES ("58", "Semey", "282400");
INSERT INTO "city" VALUES ("59", "Aqtau", "143400");
INSERT INTO "city" VALUES ("60", "Aktöbe", "253000");
INSERT INTO "city" VALUES ("61", "Petropavl", "203500");
INSERT INTO "city" VALUES ("62", "Oral", "195000");
INSERT INTO "city" VALUES ("63", "Temirtau", "170500");
INSERT INTO "city" VALUES ("64", "Kyzylorda", "157400");
INSERT INTO "city" VALUES ("65", "Köksetau", "123400");
INSERT INTO "city" VALUES ("66", "Taldyqorghan", "97900");
INSERT INTO "city" VALUES ("67", "Rudnyy", "109500");
INSERT INTO "city" VALUES ("68", "Zhezqazghan", "90000");
INSERT INTO "city" VALUES ("69", "Dhaka", "9672000");
INSERT INTO "city" VALUES ("70", "Chittagong", "2953400");
INSERT INTO "city" VALUES ("71", "Khulna", "921700");
INSERT INTO "city" VALUES ("72", "Rajshahi", "328600");
INSERT INTO "city" VALUES ("73", "Barisal", "231700");
INSERT INTO "city" VALUES ("74", "Rangpur", "209000");
INSERT INTO "city" VALUES ("75", "Sylhet", "189000");
INSERT INTO "city" VALUES ("76", "Tong", "157600");
INSERT INTO "city" VALUES ("77", "Mymensingh", "147500");
INSERT INTO "city" VALUES ("78", "Comilla", "138600");
INSERT INTO "city" VALUES ("79", "Jessore", "126800");
INSERT INTO "city" VALUES ("80", "Narayanganj", "120700");
INSERT INTO "city" VALUES ("81", "Dinajpur", "118500");
INSERT INTO "city" VALUES ("82", "Bogra", "112800");
INSERT INTO "city" VALUES ("83", "Savar", "108100");
INSERT INTO "city" VALUES ("84", "Paracin", "30273");
INSERT INTO "city" VALUES ("85", "Pozarevac", "41736");
INSERT INTO "city" VALUES ("86", "Pirot", "40800");
INSERT INTO "city" VALUES ("87", "Zrenjanin", "81300");
INSERT INTO "city" VALUES ("88", "Valjevo", "62300");
INSERT INTO "city" VALUES ("89", "Vranje", "62100");
INSERT INTO "city" VALUES ("90", "Bor", "37800");
INSERT INTO "city" VALUES ("91", "Cacak", "77200");
INSERT INTO "city" VALUES ("92", "Jagodina", "35600");
INSERT INTO "city" VALUES ("93", "Kraljevo", "84100");
INSERT INTO "city" VALUES ("94", "Krusevac", "73300");
INSERT INTO "city" VALUES ("95", "Leskovac", "63000");
INSERT INTO "city" VALUES ("96", "Loznica", "22500");
INSERT INTO "city" VALUES ("97", "Negotin", "17700");
INSERT INTO "city" VALUES ("98", "Nis", "175400");
INSERT INTO "city" VALUES ("99", "Novi Pazar", "68500");
INSERT INTO "city" VALUES ("100", "Novi Sad", "179600");
INSERT INTO "city" VALUES ("101", "Obrenovac", "23000");
INSERT INTO "city" VALUES ("102", "Pancevo", "84700");
INSERT INTO "city" VALUES ("103", "Smederevo", "65300");
INSERT INTO "city" VALUES ("104", "Sombor", "51500");
INSERT INTO "city" VALUES ("105", "Sremska Mitrovica", "39000");
INSERT INTO "city" VALUES ("106", "Subotica", "100300");
INSERT INTO "city" VALUES ("107", "Užice", "63600");
INSERT INTO "city" VALUES ("108", "Kragujevac", "147500");
INSERT INTO "city" VALUES ("109", "Belgrad", "1168438");
INSERT INTO "city" VALUES ("110", "Sabac", "55200");
INSERT INTO "city" VALUES ("111", "Gornji Milanovac", "22000");
INSERT INTO "city" VALUES ("112", "Kikinda", "41800");
INSERT INTO "city" VALUES ("113", "Kosovska Mitrovica", "33900");
INSERT INTO "city" VALUES ("114", "Kursumlija", "17000");
INSERT INTO "city" VALUES ("115", "Lazarevac", "24000");
INSERT INTO "city" VALUES ("116", "Prokuplje", "28100");
INSERT INTO "city" VALUES ("117", "Smederevska Palanka", "26000");
INSERT INTO "city" VALUES ("118", "Stara Pazova", "20000");
INSERT INTO "city" VALUES ("119", "Trstenik", "17200");
INSERT INTO "city" VALUES ("120", "Vrsac", "36200");
INSERT INTO "city" VALUES ("121", "Zagubica", "4000");
INSERT INTO "city" VALUES ("122", "Zajecar", "39500");
INSERT INTO "city" VALUES ("123", "Arandjelovac", "24900");
INSERT INTO "city" VALUES ("124", "Becej", "27300");
INSERT INTO "city" VALUES ("125", "Danilovgrad", "5200");
INSERT INTO "city" VALUES ("126", "Herceg Novi", "12700");
INSERT INTO "city" VALUES ("127", "Kotor", "5700");
INSERT INTO "city" VALUES ("128", "Nikšic", "58200");
INSERT INTO "city" VALUES ("129", "Podgorica", "117875");
INSERT INTO "city" VALUES ("130", "Pljevlja", "20400");
INSERT INTO "city" VALUES ("131", "Tivat", "8200");
INSERT INTO "city" VALUES ("132", "Ulcinj", "9200");
INSERT INTO "city" VALUES ("133", "Cetinje", "15100");
INSERT INTO "city" VALUES ("134", "Bar", "11000");
INSERT INTO "city" VALUES ("135", "Bijelo Polje", "15400");
INSERT INTO "city" VALUES ("136", "Budva", "9600");
INSERT INTO "city" VALUES ("137", "Berane", "11300");
INSERT INTO "city" VALUES ("138", "Sarajevo", "362000");
INSERT INTO "city" VALUES ("139", "Banja Luka", "143000");
INSERT INTO "city" VALUES ("140", "Zenica", "96000");
INSERT INTO "city" VALUES ("141", "Tuzla", "83700");
INSERT INTO "city" VALUES ("142", "Mostar", "75800");
INSERT INTO "city" VALUES ("143", "Bihać", "29000");
INSERT INTO "city" VALUES ("144", "Brcko", "20000");
INSERT INTO "city" VALUES ("145", "Bijeljina", "30000");
INSERT INTO "city" VALUES ("146", "Trebinje", "22000");
INSERT INTO "city" VALUES ("147", "Dubrovnik", "28500");
INSERT INTO "city" VALUES ("148", "Osijek", "109500");
INSERT INTO "city" VALUES ("149", "Pula", "62300");
INSERT INTO "city" VALUES ("150", "Rijeka", "167900");
INSERT INTO "city" VALUES ("151", "Split", "189000");
INSERT INTO "city" VALUES ("152", "Zadar", "69400");
INSERT INTO "city" VALUES ("153", "Zagreb", "776900");
INSERT INTO "city" VALUES ("154", "Sibenik", "37000");
INSERT INTO "city" VALUES ("155", "Varazdin", "41800");
INSERT INTO "city" VALUES ("156", "Karlovac", "53100");
INSERT INTO "city" VALUES ("157", "Sisak", "35700");
INSERT INTO "city" VALUES ("158", "Vukovar", "31000");
INSERT INTO "city" VALUES ("159", "Koprivnica", "24900");
INSERT INTO "city" VALUES ("160", "Vinkovci", "36000");
INSERT INTO "city" VALUES ("161", "Bjelovar", "27800");
INSERT INTO "city" VALUES ("162", "Kutina", "14900");
INSERT INTO "city" VALUES ("163", "Porec", "7600");
INSERT INTO "city" VALUES ("164", "Rovinj", "13400");
INSERT INTO "city" VALUES ("165", "Makarska", "12000");
INSERT INTO "city" VALUES ("166", "Opatija", "7900");
INSERT INTO "city" VALUES ("167", "Blagoevgrad", "71300");
INSERT INTO "city" VALUES ("168", "Burgas", "196000");
INSERT INTO "city" VALUES ("169", "Dobric", "100400");
INSERT INTO "city" VALUES ("170", "Gabrovo", "68300");
INSERT INTO "city" VALUES ("171", "Haskovo", "80700");
INSERT INTO "city" VALUES ("172", "Kardzali", "50000");
INSERT INTO "city" VALUES ("173", "Kyustendil", "58000");
INSERT INTO "city" VALUES ("174", "Lovec", "48300");
INSERT INTO "city" VALUES ("175", "Montana", "54500");
INSERT INTO "city" VALUES ("176", "Pazardzik", "78800");
INSERT INTO "city" VALUES ("177", "Pernik", "90200");
INSERT INTO "city" VALUES ("178", "Pleven", "122100");
INSERT INTO "city" VALUES ("179", "Plovdiv", "340600");
INSERT INTO "city" VALUES ("180", "Razgrad", "42900");
INSERT INTO "city" VALUES ("181", "Ruse", "169300");
INSERT INTO "city" VALUES ("182", "Silistra", "42800");
INSERT INTO "city" VALUES ("183", "Sliven", "107100");
INSERT INTO "city" VALUES ("184", "Smoljan", "34100");
INSERT INTO "city" VALUES ("185", "Sofia", "1094400");
INSERT INTO "city" VALUES ("186", "Stara Zagora", "143900");
INSERT INTO "city" VALUES ("187", "Sumen", "90000");
INSERT INTO "city" VALUES ("188", "Targoviste", "43000");
INSERT INTO "city" VALUES ("189", "Varna", "309200");
INSERT INTO "city" VALUES ("190", "Veliko Tarnovo", "70400");
INSERT INTO "city" VALUES ("191", "Vidin", "58000");
INSERT INTO "city" VALUES ("192", "Vraca", "72000");
INSERT INTO "city" VALUES ("193", "Jambol", "86200");
INSERT INTO "city" VALUES ("194", "Aalborg", "161161");
INSERT INTO "city" VALUES ("195", "Arhus", "217260");
INSERT INTO "city" VALUES ("196", "Kobenhavn", "495695");
INSERT INTO "city" VALUES ("197", "Odense", "144518");
INSERT INTO "city" VALUES ("198", "Esbjerg", "73411");
INSERT INTO "city" VALUES ("199", "Randers", "55893");
INSERT INTO "city" VALUES ("200", "Kolding", "53485");
INSERT INTO "city" VALUES ("201", "Vejle", "49943");
INSERT INTO "city" VALUES ("202", "Horsens", "48712");
INSERT INTO "city" VALUES ("203", "Roskilde", "43710");
INSERT INTO "city" VALUES ("204", "Herning", "42429");
INSERT INTO "city" VALUES ("205", "Silkeborg", "38000");
INSERT INTO "city" VALUES ("206", "Naestved", "37995");
INSERT INTO "city" VALUES ("207", "Fredericia", "36946");
INSERT INTO "city" VALUES ("208", "Viborg", "31813");
INSERT INTO "city" VALUES ("209", "Holstebro", "30986");
INSERT INTO "city" VALUES ("210", "Slagelse", "31918");
INSERT INTO "city" VALUES ("211", "Helsingor", "34494");
INSERT INTO "city" VALUES ("212", "Köbenhavn", "1745567");
INSERT INTO "city" VALUES ("213", "Nuuk", "13196");
INSERT INTO "city" VALUES ("214", "Tórshavn", "13200");
INSERT INTO "city" VALUES ("215", "Berlin", "3386667");
INSERT INTO "city" VALUES ("216", "Hamburg", "1703500");
INSERT INTO "city" VALUES ("217", "München", "1194560");
INSERT INTO "city" VALUES ("218", "Köln", "962500");
INSERT INTO "city" VALUES ("219", "Frankfurt am Main", "643821");
INSERT INTO "city" VALUES ("220", "Essen", "599515");
INSERT INTO "city" VALUES ("221", "Dortmund", "590218");
INSERT INTO "city" VALUES ("222", "Stuttgart", "582440");
INSERT INTO "city" VALUES ("223", "Düsseldorf", "568055");
INSERT INTO "city" VALUES ("224", "Bremen", "540800");
INSERT INTO "city" VALUES ("225", "Hannover", "514718");
INSERT INTO "city" VALUES ("226", "Leipzig", "489156");
INSERT INTO "city" VALUES ("227", "Duisburg", "519837");
INSERT INTO "city" VALUES ("228", "Nürnberg", "486370");
INSERT INTO "city" VALUES ("229", "Dresden", "476668");
INSERT INTO "city" VALUES ("230", "Bochum", "391147");
INSERT INTO "city" VALUES ("231", "Wuppertal", "366434");
INSERT INTO "city" VALUES ("232", "Bielefeld", "321758");
INSERT INTO "city" VALUES ("233", "Mannheim", "307774");
INSERT INTO "city" VALUES ("234", "Bonn", "302247");
INSERT INTO "city" VALUES ("235", "Gelsenkirchen", "278653");
INSERT INTO "city" VALUES ("236", "Karlsruhe", "278558");
INSERT INTO "city" VALUES ("237", "Wiesbaden", "270109");
INSERT INTO "city" VALUES ("238", "Münster", "265609");
INSERT INTO "city" VALUES ("239", "Mönchengladbach", "263014");
INSERT INTO "city" VALUES ("240", "Chemnitz", "262863");
INSERT INTO "city" VALUES ("241", "Augsburg", "254982");
INSERT INTO "city" VALUES ("242", "Braunschweig", "247942");
INSERT INTO "city" VALUES ("243", "Aachen", "243825");
INSERT INTO "city" VALUES ("244", "Krefeld", "237104");
INSERT INTO "city" VALUES ("245", "Halle/Saale", "247793");
INSERT INTO "city" VALUES ("246", "Kiel", "245567");
INSERT INTO "city" VALUES ("247", "Magdeburg", "231450");
INSERT INTO "city" VALUES ("248", "Oberhausen", "222324");
INSERT INTO "city" VALUES ("249", "Freiburg im Breisgau", "205500");
INSERT INTO "city" VALUES ("250", "Lübeck", "213326");
INSERT INTO "city" VALUES ("251", "Rostock", "206200");
INSERT INTO "city" VALUES ("252", "Mainz", "185200");
INSERT INTO "city" VALUES ("253", "Erfurt", "201726");
INSERT INTO "city" VALUES ("254", "Kassel", "195500");
INSERT INTO "city" VALUES ("255", "Hagen", "203150");
INSERT INTO "city" VALUES ("256", "Hamm", "181000");
INSERT INTO "city" VALUES ("257", "Saarbrücken", "183257");
INSERT INTO "city" VALUES ("258", "Mülheim an der Ruhr", "175150");
INSERT INTO "city" VALUES ("259", "Potsdam", "129324");
INSERT INTO "city" VALUES ("260", "Ludwigshafen am Rhein", "169500");
INSERT INTO "city" VALUES ("261", "Oldenburg", "154125");
INSERT INTO "city" VALUES ("262", "Leverkusen", "162273");
INSERT INTO "city" VALUES ("263", "Osnabrück", "164500");
INSERT INTO "city" VALUES ("264", "Solingen", "165583");
INSERT INTO "city" VALUES ("265", "Herne", "172400");
INSERT INTO "city" VALUES ("266", "Neuss", "149600");
INSERT INTO "city" VALUES ("267", "Heidelberg", "139900");
INSERT INTO "city" VALUES ("268", "Darmstadt", "138200");
INSERT INTO "city" VALUES ("269", "Paderborn", "139000");
INSERT INTO "city" VALUES ("270", "Regensburg", "125700");
INSERT INTO "city" VALUES ("271", "Würzburg", "127900");
INSERT INTO "city" VALUES ("272", "Recklinghausen", "124785");