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),
"SurfaceArea" FLOAT,
"IndepYear" INT,
"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", "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", "172707");
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", "Arnhem", "138020");
INSERT INTO "city" VALUES ("18", "Zaanstad", "135621");
INSERT INTO "city" VALUES ("19", "Amersfoort", "126270");
INSERT INTO "city" VALUES ("20", "Maastricht", "122087");
INSERT INTO "city" VALUES ("21", "Dordrecht", "119812");
INSERT INTO "city" VALUES ("22", "Leiden", "117196");
INSERT INTO "city" VALUES ("23", "Zoetermeer", "110915");
INSERT INTO "city" VALUES ("24", "Almere", "110000");
INSERT INTO "city" VALUES ("25", "Delft", "96098");
INSERT INTO "city" VALUES ("26", "Heerlen", "95053");
INSERT INTO "city" VALUES ("27", "Den Bosch", "90559");
INSERT INTO "city" VALUES ("28", "Alkmaar", "89634");
INSERT INTO "city" VALUES ("29", "Emmen", "88432");
INSERT INTO "city" VALUES ("30", "Leeuwarden", "85564");
INSERT INTO "city" VALUES ("31", "Ede", "84865");
INSERT INTO "city" VALUES ("32", "Venlo", "83883");
INSERT INTO "city" VALUES ("33", "Deventer", "82184");
INSERT INTO "city" VALUES ("34", "Hilversum", "80804");
INSERT INTO "city" VALUES ("35", "Hengelo", "75614");
INSERT INTO "city" VALUES ("36", "Purmerend", "73738");
INSERT INTO "city" VALUES ("37", "Schiedam", "73454");
INSERT INTO "city" VALUES ("38", "Assen", "49000");
INSERT INTO "city" VALUES ("39", "Barneveld", "45000");
INSERT INTO "city" VALUES ("40", "Vlissingen", "44000");
INSERT INTO "city" VALUES ("41", "Gouda", "71771");
INSERT INTO "city" VALUES ("42", "Katwijk", "61000");
INSERT INTO "city" VALUES ("43", "Doetinchem", "58000");
INSERT INTO "city" VALUES ("44", "Hoorn", "64000");
INSERT INTO "city" VALUES ("45", "Veenendaal", "60000");
INSERT INTO "city" VALUES ("46", "Rijswijk", "49000");
INSERT INTO "city" VALUES ("47", "Woerden", "45000");
INSERT INTO "city" VALUES ("48", "Weert", "48000");
INSERT INTO "city" VALUES ("49", "Roermond", "45000");
INSERT INTO "city" VALUES ("50", "Sittard-Geleen", "49000");
INSERT INTO "city" VALUES ("51", "Heerhugowaard", "48000");
INSERT INTO "city" VALUES ("52", "Lelystad", "65000");
INSERT INTO "city" VALUES ("53", "Alphen aan den Rijn", "68000");
INSERT INTO "city" VALUES ("54", "Naaldwijk", "20000");
INSERT INTO "city" VALUES ("55", "Epe", "30000");
INSERT INTO "city" VALUES ("56", "Oldenzaal", "30000");
INSERT INTO "city" VALUES ("57", "Zutphen", "35000");
INSERT INTO "city" VALUES ("58", "Kampen", "35000");
INSERT INTO "city" VALUES ("59", "Zeist", "60000");
INSERT INTO "city" VALUES ("60", "Nieuwegein", "60000");
INSERT INTO "city" VALUES ("61", "Houten", "40000");
INSERT INTO "city" VALUES ("62", "IJsselstein", "30000");
INSERT INTO "city" VALUES ("63", "Culemborg", "25000");
INSERT INTO "city" VALUES ("64", "Tiel", "40000");
INSERT INTO "city" VALUES ("65", "Gorinchem", "35000");
INSERT INTO "city" VALUES ("66", "Harderwijk", "40000");
INSERT INTO "city" VALUES ("67", "Ermelo", "25000");
INSERT INTO "city" VALUES ("68", "Putten", "20000");
INSERT INTO "city" VALUES ("69", "Nunspeet", "20000");
INSERT INTO "city" VALUES ("70", "Elburg", "20000");
INSERT INTO "city" VALUES ("71", "Heerde", "20000");
INSERT INTO "city" VALUES ("72", "Wageningen", "35000");
INSERT INTO "city" VALUES ("73", "Rhenen", "20000");
INSERT INTO "city" VALUES ("74", "Veenendaal", "60000");
INSERT INTO "city" VALUES ("75", "Ede", "84865");
INSERT INTO "city" VALUES ("76", "Barneveld", "45000");
INSERT INTO "city" VALUES ("77", "Amersfoort", "126270");
INSERT INTO "city" VALUES ("78", "Baarn", "20000");
INSERT INTO "city" VALUES ("79", "Soest", "45000");
INSERT INTO "city" VALUES ("80", "Bussum", "35000");
INSERT INTO "city" VALUES ("81", "Huizen", "40000");
INSERT INTO "city" VALUES ("82", "Laren", "10000");
INSERT INTO "city" VALUES ("83", "Blaricum", "10000");
INSERT INTO "city" VALUES ("84", "Eemnes", "10000");
INSERT INTO "city" VALUES ("85", "Hilversum", "80804");
INSERT INTO "city" VALUES ("86", "Loosdrecht", "10000");
INSERT INTO "city" VALUES ("87", "Wijdemeren", "20000");
INSERT INTO "city" VALUES ("88", "Muiden", "10000");
INSERT INTO "city" VALUES ("89", "Naarden", "20000");
INSERT INTO "city" VALUES ("90", "Weesp", "20000");
INSERT INTO "city" VALUES ("91", "Diemen", "20000");
INSERT INTO "city" VALUES ("92", "Ouder-Amstel", "10000");
INSERT INTO "city" VALUES ("93", "Amstelveen", "80000");
INSERT INTO "city" VALUES ("94", "Aalsmeer", "20000");
INSERT INTO "city" VALUES ("95", "Uithoorn", "20000");
INSERT INTO "city" VALUES ("96", "Mijdrecht", "20000");
INSERT INTO "city" VALUES ("97", "Vinkeveen", "10000");
INSERT INTO "city" VALUES ("98", "Abcoude", "10000");
INSERT INTO "city" VALUES ("99", "Breukelen", "10000");
INSERT INTO "city" VALUES ("100", "Maarssen", "20000");
INSERT INTO "city" VALUES ("101", "De Bilt", "40000");
INSERT INTO "city" VALUES ("102", "Zeist", "60000");
INSERT INTO "city" VALUES ("103", "Bunnik", "10000");
INSERT INTO "city" VALUES ("104", "Wijk bij Duurstede", "20000");
INSERT INTO "city" VALUES ("105", "Houten", "40000");
INSERT INTO "city" VALUES ("106", "Nieuwegein", "60000");
INSERT INTO "city" VALUES ("107", "IJsselstein", "30000");
INSERT INTO "city" VALUES ("108", "Montfoort", "10000");
INSERT INTO "city" VALUES ("109", "Oudewater", "10000");
INSERT INTO "city" VALUES ("110", "Woerden", "45000");
INSERT INTO "city" VALUES ("111", "Bodegraven", "20000");
INSERT INTO "city" VALUES ("112", "Reeuwijk", "10000");
INSERT INTO "city" VALUES ("113", "Gouda", "71771");
INSERT INTO "city" VALUES ("114", "Waddinxveen", "20000");
INSERT INTO "city" VALUES ("115", "Boskoop", "20000");
INSERT INTO "city" VALUES ("116", "Alphen aan den Rijn", "68000");
INSERT INTO "city" VALUES ("117", "Nieuwkoop", "20000");
INSERT INTO "city" VALUES ("118", "Kaag en Braassem", "20000");
INSERT INTO "city" VALUES ("119", "Leiderdorp", "20000");
INSERT INTO "city" VALUES ("120", "Oegstgeest", "20000");
INSERT INTO "city" VALUES ("121", "Voorschoten", "20000");
INSERT INTO "city" VALUES ("122", "Wassenaar", "20000");
INSERT INTO "city" VALUES ("123", "Leidschendam-Voorburg", "70000");
INSERT INTO "city" VALUES ("124", "Rijswijk", "49000");
INSERT INTO "city" VALUES ("125", "Delft", "96098");
INSERT INTO "city" VALUES ("126", "Pijnacker-Nootdorp", "40000");
INSERT INTO "city" VALUES ("127", "Midden-Delfland", "20000");
INSERT INTO "city" VALUES ("128", "Westland", "90000");
INSERT INTO "city" VALUES ("129", "Maassluis", "30000");
INSERT INTO "city" VALUES ("130", "Vlaardingen", "70000");
INSERT INTO "city" VALUES ("131", "Schiedam", "73454");
INSERT INTO "city" VALUES ("132", "Capelle aan den IJssel", "60000");
INSERT INTO "city" VALUES ("133", "Krimpen aan den IJssel", "20000");
INSERT INTO "city" VALUES ("134", "Ouderkerk aan den IJssel", "10000");
INSERT INTO "city" VALUES ("135", "Bergambacht", "10000");
INSERT INTO "city" VALUES ("136", "Schoonhoven", "10000");
INSERT INTO "city" VALUES ("137", "Nederlek", "10000");
INSERT INTO "city" VALUES ("138", "Vlist", "10000");
INSERT INTO "city" VALUES ("139", "Oud-Beijerland", "20000");
INSERT INTO "city" VALUES ("140", "Barendrecht", "40000");
INSERT INTO "city" VALUES ("141", "Ridderkerk", "40000");
INSERT INTO "city" VALUES ("142", "Alblasserdam", "20000");
INSERT INTO "city" VALUES ("143", "Papendrecht", "20000");
INSERT INTO "city" VALUES ("144", "Sliedrecht", "20000");
INSERT INTO "city" VALUES ("145", "Hardinxveld-Giessendam", "20000");
INSERT INTO "city" VALUES ("146", "Dordrecht", "119812");
INSERT INTO "city" VALUES ("147", "Zwijndrecht", "40000");
INSERT INTO "city" VALUES ("148", "Hendrik-Ido-Ambacht", "20000");
INSERT INTO "city" VALUES ("149", "Albrandswaard", "20000");
INSERT INTO "city" VALUES ("150", "Spijkenisse", "50000");
INSERT INTO "city" VALUES ("151", "Hellevoetsluis", "40000");
INSERT INTO "city" VALUES ("152", "Brielle", "20000");
INSERT INTO "city" VALUES ("153", "Westvoorne", "10000");
INSERT INTO "city" VALUES ("154", "Goeree-Overflakkee", "50000");
INSERT INTO "city" VALUES ("155", "Schouwen-Duiveland", "30000");
INSERT INTO "city" VALUES ("156", "Tholen", "20000");
INSERT INTO "city" VALUES ("157", "Reimerswaal", "20000");
INSERT INTO "city" VALUES ("158", "Kapelle", "10000");
INSERT INTO "city" VALUES ("159", "Goes", "30000");
INSERT INTO "city" VALUES ("160", "Borsele", "20000");
INSERT INTO "city" VALUES ("161", "Hulst", "30000");
INSERT INTO "city" VALUES ("162", "Terneuzen", "50000");
INSERT INTO "city" VALUES ("163", "Sluis", "20000");
INSERT INTO "city" VALUES ("164", "Vlissingen", "44000");
INSERT INTO "city" VALUES ("165", "Middelburg", "40000");
INSERT INTO "city" VALUES ("166", "Veere", "20000");
INSERT INTO "city" VALUES ("167", "Noord-Beveland", "10000");
INSERT INTO "city" VALUES ("168", "Schouwen-Duiveland", "30000");
INSERT INTO "city" VALUES ("169", "Tholen", "20000");
INSERT INTO "city" VALUES ("170", "Reimerswaal", "20000");
INSERT INTO "city" VALUES ("171", "Kapelle", "10000");
INSERT INTO "city" VALUES ("172", "Goes", "30000");
INSERT INTO "city" VALUES ("173", "Borsele", "20000");
INSERT INTO "city" VALUES ("174", "Hulst", "30000");
INSERT INTO "city" VALUES ("175", "Terneuzen", "50000");
INSERT INTO "city" VALUES ("176", "Sluis", "20000");
INSERT INTO "city" VALUES ("177", "Vlissingen", "44000");
INSERT INTO "city" VALUES ("178", "Middelburg", "40000");
INSERT INTO "city" VALUES ("179", "Veere", "20000");
INSERT INTO "city" VALUES ("180", "Noord-Beveland", "10000");
INSERT INTO "city" VALUES ("181", "Bergen op Zoom", "60000");
INSERT INTO "city" VALUES ("182", "Roosendaal", "70000");
INSERT INTO "city" VALUES ("183", "Halderberge", "20000");
INSERT INTO "city" VALUES ("184", "Etten-Leur", "40000");
INSERT INTO "city" VALUES ("185", "Moerdijk", "30000");
INSERT INTO "city" VALUES ("186", "Drimmelen", "20000");
INSERT INTO "city" VALUES ("187", "Geertruidenberg", "20000");
INSERT INTO "city" VALUES ("188", "Oosterhout", "50000");
INSERT INTO "city" VALUES ("189", "Dongen", "20000");
INSERT INTO "city" VALUES ("190", "Gilze en Rijen", "20000");
INSERT INTO "city" VALUES ("191", "Goirle", "20000");
INSERT INTO "city" VALUES ("192", "Hilvarenbeek", "10000");
INSERT INTO "city" VALUES ("193", "Oisterwijk", "20000");
INSERT INTO "city" VALUES ("194", "Boxtel", "20000");
INSERT INTO "city" VALUES ("195", "Vught", "20000");
INSERT INTO "city" VALUES ("196", "Sint-Michielsgestel", "20000");
INSERT INTO "city" VALUES ("197", "Schijndel", "20000");
INSERT INTO "city" VALUES ("198", "Veghel", "30000");
INSERT INTO "city" VALUES ("199", "Uden", "30000");
INSERT INTO "city" VALUES ("200", "Bernheze", "30000");
INSERT INTO "city" VALUES ("201", "Landerd", "10000");
INSERT INTO "city" VALUES ("202", "Mill en Sint Hubert", "10000");
INSERT INTO "city" VALUES ("203", "Boxmeer", "30000");
INSERT INTO "city" VALUES ("204", "Cuijk", "20000");
INSERT INTO "city" VALUES ("205", "Grave", "10000");
INSERT INTO "city" VALUES ("206", "Oss", "80000");
INSERT INTO "city" VALUES ("207", "Maasdonk", "10000");
INSERT INTO "city" VALUES ("208", "Lith", "10000");
INSERT INTO "city" VALUES ("209", "Den Bosch", "90559");
INSERT INTO "city" VALUES ("210", "Vught", "20000");
INSERT INTO "city" VALUES ("211", "Sint-Michielsgestel", "20000");
INSERT INTO "city" VALUES ("212", "Schijndel", "20000");
INSERT INTO "city" VALUES ("213", "Veghel", "30000");
INSERT INTO "city" VALUES ("214", "Uden", "30000");
INSERT INTO "city" VALUES ("215", "Bernheze", "30000");
INSERT INTO "city" VALUES ("216", "Landerd", "10000");
INSERT INTO "city" VALUES ("217", "Mill en Sint Hubert", "10000");
INSERT INTO "city" VALUES ("218", "Boxmeer", "30000");
INSERT INTO "city" VALUES ("219", "Cuijk", "20000");
INSERT INTO "city" VALUES ("220", "Grave", "10000");
INSERT INTO "city" VALUES ("221", "Oss", "80000");
INSERT INTO "city" VALUES ("222", "Maasdonk", "10000");
INSERT INTO "city" VALUES ("223", "Lith", "10000");
INSERT INTO "city" VALUES ("224", "Eindhoven", "201843");
INSERT INTO "city" VALUES ("225", "Veldhoven", "40000");
INSERT INTO "city" VALUES ("226", "Geldrop-Mierlo", "40000");
INSERT INTO "city" VALUES ("227", "Nuenen, Gerwen en Nederwetten", "20000");
INSERT INTO "city" VALUES ("228", "Son en Breugel", "20000");
INSERT INTO "city" VALUES ("229", "Best", "30000");
INSERT INTO "city" VALUES ("230", "Oirschot", "20000");
INSERT INTO "city" VALUES ("231", "Bladel", "20000");
INSERT INTO "city" VALUES ("232", "Reusel-De Mierden", "10000");
INSERT INTO "city" VALUES ("233", "Eersel", "20000");
INSERT INTO "city" VALUES ("234", "Bergeijk", "20000");
INSERT INTO "city" VALUES ("235", "Waalre", "20000");
INSERT INTO "city" VALUES ("236", "Heeze-Leende", "20000");
INSERT INTO "city" VALUES ("237", "Someren", "20000");
INSERT INTO "city" VALUES ("238", "Asten", "20000");
INSERT INTO "city" VALUES ("239", "Deurne", "30000");
INSERT INTO "city" VALUES ("240", "Helmond", "80000");
INSERT INTO "city" VALUES ("241", "Laarbeek", "20000");
INSERT INTO "city" VALUES ("242", "Gemert-Bakel", "30000");
INSERT INTO "city" VALUES ("243", "Boekel", "10000");
INSERT INTO "city" VALUES ("244", "Sint Anthonis", "10000");
INSERT INTO "city" VALUES ("245", "Gennep", "20000");
INSERT INTO "city" VALUES ("246", "Bergen L.", "10000");
INSERT INTO "city" VALUES ("247", "Horst aan de Maas", "40000");
INSERT INTO "city" VALUES ("248", "Venray", "40000");
INSERT INTO "city" VALUES ("249", "Venlo", "83883");
INSERT INTO "city" VALUES ("250", "Beesel", "10000");
INSERT INTO "city" VALUES ("251", "Leudal", "40000");
INSERT INTO "city" VALUES ("252", "Roermond", "45000");
INSERT INTO "city" VALUES ("253", "Maasgouw", "20000");
INSERT INTO "city" VALUES ("254", "Echt-Susteren", "30000");
INSERT INTO "city" VALUES ("255", "Sittard-Geleen", "49000");
INSERT INTO "city" VALUES ("256", "Stein", "20000");
INSERT INTO "city" VALUES ("257", "Beek", "20000");
INSERT INTO "city" VALUES ("258", "Schinnen", "10000");
INSERT INTO "city" VALUES ("259", "Nuth", "10000");
INSERT INTO "city" VALUES ("260", "Brunssum", "30000");
INSERT INTO "city" VALUES ("261", "Landgraaf", "40000");
INSERT INTO "city" VALUES ("262", "Kerkrade", "50000");
INSERT INTO "city" VALUES ("263", "Heerlen", "95053");
INSERT INTO "city" VALUES ("264", "Voerendaal", "10000");
INSERT INTO "city" VALUES ("265", "Simpelveld", "10000");
INSERT INTO "city" VALUES ("266", "Gulpen-Wittem", "10000");
INSERT INTO "city" VALUES ("267", "Vaals", "10000");
INSERT INTO "city" VALUES ("268", "Eijsden-Margraten", "20000");
INSERT INTO "city" VALUES ("269", "Maastricht", "122087");
INSERT INTO "city" VALUES ("270", "Meerssen", "20000");
INSERT INTO "city" VALUES ("271", "Valkenburg aan de Geul", "20000");
INSERT INTO "city" VALUES ("272", "Stein", "20000");