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", "Amsterdam", "741636");
INSERT INTO "city" VALUES ("2", "Rotterdam", "592673");
INSERT INTO "city" VALUES ("3", "The Hague", "440900");
INSERT INTO "city" VALUES ("4", "Utrecht", "234323");
INSERT INTO "city" VALUES ("5", "Eindhoven", "201843");
INSERT INTO "city" VALUES ("6", "Groningen", "173139");
INSERT INTO "city" VALUES ("7", "Tilburg", "193238");
INSERT INTO "city" VALUES ("8", "Almere", "174477");
INSERT INTO "city" VALUES ("9", "Breda", "160820");
INSERT INTO "city" VALUES ("10", "Nijmegen", "152463");
INSERT INTO "city" VALUES ("11", "Apeldoorn", "153491");
INSERT INTO "city" VALUES ("12", "Enschede", "149574");
INSERT INTO "city" VALUES ("13", "Haarlem", "148482");
INSERT INTO "city" VALUES ("14", "Arnhem", "142000");
INSERT INTO "city" VALUES ("15", "Zaanstad", "135621");
INSERT INTO "city" VALUES ("16", "s-Hertogenbosch", "134000");
INSERT INTO "city" VALUES ("17", "Amersfoort", "131000");
INSERT INTO "city" VALUES ("18", "Maastricht", "122000");
INSERT INTO "city" VALUES ("19", "Dordrecht", "119821");
INSERT INTO "city" VALUES ("20", "Leiden", "117000");
INSERT INTO "city" VALUES ("21", "Zoetermeer", "110000");
INSERT INTO "city" VALUES ("22", "Zwolle", "105000");
INSERT INTO "city" VALUES ("23", "Emmen", "105000");
INSERT INTO "city" VALUES ("24", "Ede", "101000");
INSERT INTO "city" VALUES ("25", "Delft", "96000");
INSERT INTO "city" VALUES ("26", "Heerlen", "95000");
INSERT INTO "city" VALUES ("27", "Alkmaar", "92000");
INSERT INTO "city" VALUES ("28", "Leeuwarden", "91000");
INSERT INTO "city" VALUES ("29", "Venlo", "90000");
INSERT INTO "city" VALUES ("30", "Hilversum", "82000");
INSERT INTO "city" VALUES ("31", "Hengelo", "80000");
INSERT INTO "city" VALUES ("32", "Purmerend", "78000");
INSERT INTO "city" VALUES ("33", "Roosendaal", "76000");
INSERT INTO "city" VALUES ("34", "Schiedam", "75000");
INSERT INTO "city" VALUES ("35", "Spijkenisse", "74000");
INSERT INTO "city" VALUES ("36", "Helmond", "73000");
INSERT INTO "city" VALUES ("37", "Vlaardingen", "73000");
INSERT INTO "city" VALUES ("38", "Gouda", "71000");
INSERT INTO "city" VALUES ("39", "Weert", "60000");
INSERT INTO "city" VALUES ("40", "Assen", "59000");
INSERT INTO "city" VALUES ("41", "Katwijk", "61000");
INSERT INTO "city" VALUES ("42", "Den Helder", "59000");
INSERT INTO "city" VALUES ("43", "Hoorn", "65000");
INSERT INTO "city" VALUES ("44", "Bussum", "31000");
INSERT INTO "city" VALUES ("45", "Woerden", "35000");
INSERT INTO "city" VALUES ("46", "Velsen", "60000");
INSERT INTO "city" VALUES ("47", "Zeist", "60000");
INSERT INTO "city" VALUES ("48", "Hattem", "11000");
INSERT INTO "city" VALUES ("49", "Breukelen", "14000");
INSERT INTO "city" VALUES ("50", "Hillegom", "20000");
INSERT INTO "city" VALUES ("51", "Lisse", "21000");
INSERT INTO "city" VALUES ("52", "Wassenaar", "25000");
INSERT INTO "city" VALUES ("53", "Sassenheim", "15000");
INSERT INTO "city" VALUES ("54", "Warmond", "5000");
INSERT INTO "city" VALUES ("55", "Beek", "17000");
INSERT INTO "city" VALUES ("56", "Bunde", "7000");
INSERT INTO "city" VALUES ("57", "Cadier en Keer", "3000");
INSERT INTO "city" VALUES ("58", "Vaals", "7000");
INSERT INTO "city" VALUES ("59", "Margraten", "13000");
INSERT INTO "city" VALUES ("60", "Weert", "60000");
INSERT INTO "city" VALUES ("61", "Sittard", "48000");
INSERT INTO "city" VALUES ("62", "Geleen", "35000");
INSERT INTO "city" VALUES ("63", "Kerkrade", "52000");
INSERT INTO "city" VALUES ("64", "Brunssum", "30000");
INSERT INTO "city" VALUES ("65", "Landgraaf", "40000");
INSERT INTO "city" VALUES ("66", "Gulpen", "14000");
INSERT INTO "city" VALUES ("67", "Valkenburg aan de Geul", "17000");
INSERT INTO "city" VALUES ("68", "Meerssen", "20000");
INSERT INTO "city" VALUES ("69", "Stein", "26000");
INSERT INTO "city" VALUES ("70", "Ubach over Worms", "14000");
INSERT INTO "city" VALUES ("71", "Voerendaal", "12000");
INSERT INTO "city" VALUES ("72", "Simpelveld", "11000");
INSERT INTO "city" VALUES ("73", "Eijsden", "11000");
INSERT INTO "city" VALUES ("74", "Maasbree", "13000");
INSERT INTO "city" VALUES ("75", "Tegelen", "19000");
INSERT INTO "city" VALUES ("76", "Arcen en Velden", "8000");
INSERT INTO "city" VALUES ("77", "Horst aan de Maas", "30000");
INSERT INTO "city" VALUES ("78", "Sevenum", "14000");
INSERT INTO "city" VALUES ("79", "Bergen", "13000");
INSERT INTO "city" VALUES ("80", "Gennep", "16000");
INSERT INTO "city" VALUES ("81", "Mook en Middelaar", "7000");
INSERT INTO "city" VALUES ("82", "Beuningen", "22000");
INSERT INTO "city" VALUES ("83", "Groesbeek", "17000");
INSERT INTO "city" VALUES ("84", "Millingen aan de Rijn", "6000");
INSERT INTO "city" VALUES ("85", "Ubbergen", "9000");
INSERT INTO "city" VALUES ("86", "Wijk bij Duurstede", "22000");
INSERT INTO "city" VALUES ("87", "Houten", "37000");
INSERT INTO "city" VALUES ("88", "Nieuwegein", "62000");
INSERT INTO "city" VALUES ("89", "Vianen", "15000");
INSERT INTO "city" VALUES ("90", "IJsselstein", "30000");
INSERT INTO "city" VALUES ("91", "Montfoort", "13000");
INSERT INTO "city" VALUES ("92", "Oudewater", "9000");
INSERT INTO "city" VALUES ("93", "Bunnik", "14000");
INSERT INTO "city" VALUES ("94", "De Bilt", "41000");
INSERT INTO "city" VALUES ("95", "De Ronde Venen", "33000");
INSERT INTO "city" VALUES ("96", "Loenen", "8000");
INSERT INTO "city" VALUES ("97", "Maarssen", "39000");
INSERT INTO "city" VALUES ("98", "Mijdrecht", "16000");
INSERT INTO "city" VALUES ("99", "Vleuten-De Meern", "25000");
INSERT INTO "city" VALUES ("100", "Woerden", "45000");
INSERT INTO "city" VALUES ("101", "Zevenaar", "31000");
INSERT INTO "city" VALUES ("102", "Doesburg", "11000");
INSERT INTO "city" VALUES ("103", "Duiven", "25000");
INSERT INTO "city" VALUES ("104", "Westervoort", "15000");
INSERT INTO "city" VALUES ("105", "Rheden", "43000");
INSERT INTO "city" VALUES ("106", "Doetinchem", "40000");
INSERT INTO "city" VALUES ("107", "Winterswijk", "28000");
INSERT INTO "city" VALUES ("108", "Zutphen", "40000");
INSERT INTO "city" VALUES ("109", "Lochem", "33000");
INSERT INTO "city" VALUES ("110", "Berkelland", "34000");
INSERT INTO "city" VALUES ("111", "Bronckhorst", "37000");
INSERT INTO "city" VALUES ("112", "Oude IJsselstreek", "36000");
INSERT INTO "city" VALUES ("113", "Aalten", "27000");
INSERT INTO "city" VALUES ("114", "Dinxperlo", "8000");
INSERT INTO "city" VALUES ("115", "Eibergen", "11000");
INSERT INTO "city" VALUES ("116", "Neede", "10000");
INSERT INTO "city" VALUES ("117", "Borculo", "10000");
INSERT INTO "city" VALUES ("118", "Ruurlo", "8000");
INSERT INTO "city" VALUES ("119", "Vorden", "8000");
INSERT INTO "city" VALUES ("120", "Warnsveld", "10000");
INSERT INTO "city" VALUES ("121", "Dieren", "14000");
INSERT INTO "city" VALUES ("122", "Velp", "17000");
INSERT INTO "city" VALUES ("123", "Rozendaal", "1000");
INSERT INTO "city" VALUES ("124", "Wageningen", "35000");
INSERT INTO "city" VALUES ("125", "Renkum", "32000");
INSERT INTO "city" VALUES ("126", "Barneveld", "48000");
INSERT INTO "city" VALUES ("127", "Ermelo", "26000");
INSERT INTO "city" VALUES ("128", "Harderwijk", "42000");
INSERT INTO "city" VALUES ("129", "Nunspeet", "26000");
INSERT INTO "city" VALUES ("130", "Oldebroek", "22000");
INSERT INTO "city" VALUES ("131", "Elburg", "20000");
INSERT INTO "city" VALUES ("132", "Heerde", "18000");
INSERT INTO "city" VALUES ("133", "Epe", "32000");
INSERT INTO "city" VALUES ("134", "Voorst", "23000");
INSERT INTO "city" VALUES ("135", "Brummen", "20000");
INSERT INTO "city" VALUES ("136", "Culemborg", "26000");
INSERT INTO "city" VALUES ("137", "Geldermalsen", "26000");
INSERT INTO "city" VALUES ("138", "Tiel", "40000");
INSERT INTO "city" VALUES ("139", "Zaltbommel", "22000");
INSERT INTO "city" VALUES ("140", "Maasdriel", "22000");
INSERT INTO "city" VALUES ("141", "West Maas en Waal", "18000");
INSERT INTO "city" VALUES ("142", "Druten", "18000");
INSERT INTO "city" VALUES ("143", "Wijchen", "38000");
INSERT INTO "city" VALUES ("144", "Boxmeer", "28000");
INSERT INTO "city" VALUES ("145", "Cuijk", "25000");
INSERT INTO "city" VALUES ("146", "Grave", "13000");
INSERT INTO "city" VALUES ("147", "Mill en Sint Hubert", "11000");
INSERT INTO "city" VALUES ("148", "Sint Anthonis", "10000");
INSERT INTO "city" VALUES ("149", "Uden", "40000");
INSERT INTO "city" VALUES ("150", "Veghel", "35000");
INSERT INTO "city" VALUES ("151", "Boxtel", "29000");
INSERT INTO "city" VALUES ("152", "Schijndel", "22000");
INSERT INTO "city" VALUES ("153", "Sint-Oedenrode", "17000");
INSERT INTO "city" VALUES ("154", "Vught", "25000");
INSERT INTO "city" VALUES ("155", "Heusden", "40000");
INSERT INTO "city" VALUES ("156", "Waalwijk", "45000");
INSERT INTO "city" VALUES ("157", "Dongen", "25000");
INSERT INTO "city" VALUES ("158", "Oosterhout", "50000");
INSERT INTO "city" VALUES ("159", "Geertruidenberg", "20000");
INSERT INTO "city" VALUES ("160", "Drimmelen", "25000");
INSERT INTO "city" VALUES ("161", "Moerdijk", "35000");
INSERT INTO "city" VALUES ("162", "Halderberge", "28000");
INSERT INTO "city" VALUES ("163", "Etten-Leur", "40000");
INSERT INTO "city" VALUES ("164", "Zundert", "20000");
INSERT INTO "city" VALUES ("165", "Rucphen", "22000");
INSERT INTO "city" VALUES ("166", "Bergen op Zoom", "65000");
INSERT INTO "city" VALUES ("167", "Steenbergen", "23000");
INSERT INTO "city" VALUES ("168", "Woensdrecht", "21000");
INSERT INTO "city" VALUES ("169", "Goes", "35000");
INSERT INTO "city" VALUES ("170", "Middelburg", "45000");
INSERT INTO "city" VALUES ("171", "Vlissingen", "45000");
INSERT INTO "city" VALUES ("172", "Terneuzen", "55000");
INSERT INTO "city" VALUES ("173", "Hulst", "28000");
INSERT INTO "city" VALUES ("174", "Sluis", "25000");
INSERT INTO "city" VALUES ("175", "Reimerswaal", "20000");
INSERT INTO "city" VALUES ("176", "Kapelle", "11000");
INSERT INTO "city" VALUES ("177", "Borsele", "22000");
INSERT INTO "city" VALUES ("178", "Veere", "22000");
INSERT INTO "city" VALUES ("179", "Schouwen-Duiveland", "34000");
INSERT INTO "city" VALUES ("180", "Tholen", "22000");
INSERT INTO "city" VALUES ("181", "Noord-Beveland", "7000");
INSERT INTO "city" VALUES ("182", "Delfzijl", "28000");
INSERT INTO "city" VALUES ("183", "Appingedam", "12000");
INSERT INTO "city" VALUES ("184", "Loppersum", "10000");
INSERT INTO "city" VALUES ("185", "Winsum", "11000");
INSERT INTO "city" VALUES ("186", "Zuidhorn", "15000");
INSERT INTO "city" VALUES ("187", "Leek", "18000");
INSERT INTO "city" VALUES ("188", "Marum", "10000");
INSERT INTO "city" VALUES ("189", "Grootegast", "12000");
INSERT INTO "city" VALUES ("190", "Haren", "18000");
INSERT INTO "city" VALUES ("191", "Ten Boer", "7000");
INSERT INTO "city" VALUES ("192", "Hoogezand-Sappemeer", "34000");
INSERT INTO "city" VALUES ("193", "Veendam", "28000");
INSERT INTO "city" VALUES ("194", "Pekela", "13000");
INSERT INTO "city" VALUES ("195", "Oldambt", "38000");
INSERT INTO "city" VALUES ("196", "Menterwolde", "13000");
INSERT INTO "city" VALUES ("197", "Stadskanaal", "34000");
INSERT INTO "city" VALUES ("198", "Vlagtwedde", "17000");
INSERT INTO "city" VALUES ("199", "Bellingwedde", "9000");
INSERT INTO "city" VALUES ("200", "Coevorden", "36000");
INSERT INTO "city" VALUES ("201", "Borger-Odoorn", "26000");
INSERT INTO "city" VALUES ("202", "Aa en Hunze", "25000");
INSERT INTO "city" VALUES ("203", "Tynaarlo", "32000");
INSERT INTO "city" VALUES ("204", "Noordenveld", "25000");
INSERT INTO "city" VALUES ("205", "Westerveld", "19000");
INSERT INTO "city" VALUES ("206", "Meppel", "32000");
INSERT INTO "city" VALUES ("207", "Hoogeveen", "48000");
INSERT INTO "city" VALUES ("208", "De Wolden", "23000");
INSERT INTO "city" VALUES ("209", "Ommen", "17000");
INSERT INTO "city" VALUES ("210", "Hardenberg", "42000");
INSERT INTO "city" VALUES ("211", "Dalfsen", "26000");
INSERT INTO "city" VALUES ("212", "Raalte", "36000");
INSERT INTO "city" VALUES ("213", "Olst-Wijhe", "17000");
INSERT INTO "city" VALUES ("214", "Deventer", "95000");
INSERT INTO "city" VALUES ("215", "Rijssen-Holten", "36000");
INSERT INTO "city" VALUES ("216", "Wierden", "23000");
INSERT INTO "city" VALUES ("217", "Hellendoorn", "35000");
INSERT INTO "city" VALUES ("218", "Twenterand", "33000");
INSERT INTO "city" VALUES ("219", "Borne", "21000");
INSERT INTO "city" VALUES ("220", "Hof van Twente", "35000");
INSERT INTO "city" VALUES ("221", "Losser", "22000");
INSERT INTO "city" VALUES ("222", "Oldenzaal", "32000");
INSERT INTO "city" VALUES ("223", "Dinkelland", "26000");
INSERT INTO "city" VALUES ("224", "Tubbergen", "21000");
INSERT INTO "city" VALUES ("225", "Haaksbergen", "24000");
INSERT INTO "city" VALUES ("226", "Berkelland", "34000");
INSERT INTO "city" VALUES ("227", "Oost Gelre", "30000");
INSERT INTO "city" VALUES ("228", "Aalten", "27000");
INSERT INTO "city" VALUES ("229", "Winterswijk", "28000");
INSERT INTO "city" VALUES ("230", "Doetinchem", "40000");
INSERT INTO "city" VALUES ("231", "Montferland", "35000");
INSERT INTO "city" VALUES ("232", "Oude IJsselstreek", "36000");
INSERT INTO "city" VALUES ("233", "Bronckhorst", "37000");
INSERT INTO "city" VALUES ("234", "Lochem", "33000");
INSERT INTO "city" VALUES ("235", "Zutphen", "40000");
INSERT INTO "city" VALUES ("236", "Apeldoorn", "153491");
INSERT INTO "city" VALUES ("237", "Epe", "32000");
INSERT INTO "city" VALUES ("238", "Heerde", "18000");
INSERT INTO "city" VALUES ("239", "Hattem", "11000");
INSERT INTO "city" VALUES ("240", "Oldebroek", "22000");
INSERT INTO "city" VALUES ("241", "Elburg", "20000");
INSERT INTO "city" VALUES ("242", "Nunspeet", "26000");
INSERT INTO "city" VALUES ("243", "Harderwijk", "42000");
INSERT INTO "city" VALUES ("244", "Ermelo", "26000");
INSERT INTO "city" VALUES ("245", "Putten", "24000");
INSERT INTO "city" VALUES ("246", "Nijkerk", "40000");
INSERT INTO "city" VALUES ("247", "Barneveld", "48000");
INSERT INTO "city" VALUES ("248", "Scherpenzeel", "9000");
INSERT INTO "city" VALUES ("249", "Renswoude", "5000");
INSERT INTO "city" VALUES ("250", "Veenendaal", "65000");
INSERT INTO "city" VALUES ("251", "Rhenen", "19000");
INSERT INTO "city" VALUES ("252", "Wageningen", "35000");
INSERT INTO "city" VALUES ("253", "Ede", "101000");
INSERT INTO "city" VALUES ("254", "Renkum", "32000");
INSERT INTO "city" VALUES ("255", "Arnhem", "142000");
INSERT INTO "city" VALUES ("256", "Rheden", "43000");
INSERT INTO "city" VALUES ("257", "Rozendaal", "1000");
INSERT INTO "city" VALUES ("258", "Velp", "17000");
INSERT INTO "city" VALUES ("259", "Westervoort", "15000");
INSERT INTO "city" VALUES ("260", "Duiven", "25000");
INSERT INTO "city" VALUES ("261", "Zevenaar", "31000");
INSERT INTO "city" VALUES ("262", "Doesburg", "11000");
INSERT INTO "city" VALUES ("263", "Doetinchem", "40000");
INSERT INTO "city" VALUES ("264", "Montferland", "35000");
INSERT INTO "city" VALUES ("265", "Oude IJsselstreek", "36000");
INSERT INTO "city" VALUES ("266", "Aalten", "27000");
INSERT INTO "city" VALUES ("267", "Winterswijk", "28000");
INSERT INTO "city" VALUES ("268", "Berkelland", "34000");
INSERT INTO "city" VALUES ("269", "Oost Gelre", "30000");
INSERT INTO "city" VALUES ("270", "Bronckhorst", "37000");
INSERT INTO "city" VALUES ("271", "Lochem", "33000");
INSERT INTO "city" VALUES ("272", "Zutphen", "40000");
INSERT INTO "city" VALUES ("273", "Brummen", "20000");
INSERT INTO "city" VALUES ("274", "Voorst", "23000");
INSERT INTO "city" VALUES ("275", "Culemborg", "26000");
INSERT INTO "city" VALUES ("276", "Geldermalsen", "26000");