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", "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", "172700");
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", "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", "Den Bosch", "124600");
INSERT INTO "city" VALUES ("22", "Maastricht", "122087");
INSERT INTO "city" VALUES ("23", "Dordrecht", "119811");
INSERT INTO "city" VALUES ("24", "Leiden", "117196");
INSERT INTO "city" VALUES ("25", "Zoetermeer", "110915");
INSERT INTO "city" VALUES ("26", "Emmen", "105980");
INSERT INTO "city" VALUES ("27", "Zwolle", "105800");
INSERT INTO "city" VALUES ("28", "Ede", "101500");
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", "Venlo", "89721");
INSERT INTO "city" VALUES ("34", "Hilversum", "83737");
INSERT INTO "city" VALUES ("35", "Hengelo", "75100");
INSERT INTO "city" VALUES ("36", "Purmerend", "73800");
INSERT INTO "city" VALUES ("37", "Schiedam", "73454");
INSERT INTO "city" VALUES ("38", "Assen", "49000");
INSERT INTO "city" VALUES ("39", "Barneveld", "27000");
INSERT INTO "city" VALUES ("40", "Vlissingen", "44000");
INSERT INTO "city" VALUES ("41", "Noordwijk", "22000");
INSERT INTO "city" VALUES ("42", "Dushanbe", "524000");
INSERT INTO "city" VALUES ("43", "Khujand", "161000");
INSERT INTO "city" VALUES ("44", "Bishkek", "683200");
INSERT INTO "city" VALUES ("45", "Osh", "222600");
INSERT INTO "city" VALUES ("46", "Ashgabat", "540000");
INSERT INTO "city" VALUES ("47", "Chärjew", "189000");
INSERT INTO "city" VALUES ("48", "Dashoguz", "147000");
INSERT INTO "city" VALUES ("49", "Bangkok", "6320000");
INSERT INTO "city" VALUES ("50", "Nonthaburi", "292100");
INSERT INTO "city" VALUES ("51", "Nakhon Ratchasima", "204300");
INSERT INTO "city" VALUES ("52", "Chiang Mai", "171100");
INSERT INTO "city" VALUES ("53", "Udon Thani", "158100");
INSERT INTO "city" VALUES ("54", "Hat Yai", "148600");
INSERT INTO "city" VALUES ("55", "Khon Kaen", "134500");
INSERT INTO "city" VALUES ("56", "Pak Kret", "126000");
INSERT INTO "city" VALUES ("57", "Nakhon Sawan", "123800");
INSERT INTO "city" VALUES ("58", "Ubon Ratchathani", "116400");
INSERT INTO "city" VALUES ("59", "Phitsanulok", "106800");
INSERT INTO "city" VALUES ("60", "Nakhon Pathom", "106300");
INSERT INTO "city" VALUES ("61", "Songkhla", "84000");
INSERT INTO "city" VALUES ("62", "Surat Thani", "81000");
INSERT INTO "city" VALUES ("63", "Ratchaburi", "78000");
INSERT INTO "city" VALUES ("64", "Sakon Nakhon", "76000");
INSERT INTO "city" VALUES ("65", "Chiang Rai", "72000");
INSERT INTO "city" VALUES ("66", "Phra Nakhon Si Ayutthaya", "65000");
INSERT INTO "city" VALUES ("67", "Phuket", "60000");
INSERT INTO "city" VALUES ("68", "Trang", "55000");
INSERT INTO "city" VALUES ("69", "Chon Buri", "54000");
INSERT INTO "city" VALUES ("70", "Yala", "53000");
INSERT INTO "city" VALUES ("71", "Nakhon Si Thammarat", "47000");
INSERT INTO "city" VALUES ("72", "Samut Prakan", "378000");
INSERT INTO "city" VALUES ("73", "Samut Sakhon", "147000");
INSERT INTO "city" VALUES ("74", "Rayong", "106000");
INSERT INTO "city" VALUES ("75", "Chon Buri", "77000");
INSERT INTO "city" VALUES ("76", "Pattaya", "76000");
INSERT INTO "city" VALUES ("77", "Ko Samui", "33000");
INSERT INTO "city" VALUES ("78", "Phuket", "20000");
INSERT INTO "city" VALUES ("79", "Lomé", "375000");
INSERT INTO "city" VALUES ("80", "Sokodé", "50000");
INSERT INTO "city" VALUES ("81", "Nuku´alofa", "22400");
INSERT INTO "city" VALUES ("82", "Port-of-Spain", "49000");
INSERT INTO "city" VALUES ("83", "Tunis", "690000");
INSERT INTO "city" VALUES ("84", "Sfax", "230000");
INSERT INTO "city" VALUES ("85", "Ariana", "150000");
INSERT INTO "city" VALUES ("86", "Ben Arous", "100000");
INSERT INTO "city" VALUES ("87", "Sousse", "100000");
INSERT INTO "city" VALUES ("88", "Kairouan", "100000");
INSERT INTO "city" VALUES ("89", "Bizerte", "90000");
INSERT INTO "city" VALUES ("90", "Gabès", "80000");
INSERT INTO "city" VALUES ("91", "Gafsa", "70000");
INSERT INTO "city" VALUES ("92", "Monastir", "60000");
INSERT INTO "city" VALUES ("93", "Zarzis", "50000");
INSERT INTO "city" VALUES ("94", "Istanbul", "8787700");
INSERT INTO "city" VALUES ("95", "Ankara", "3038150");
INSERT INTO "city" VALUES ("96", "Izmir", "2130350");
INSERT INTO "city" VALUES ("97", "Adana", "1131700");
INSERT INTO "city" VALUES ("98", "Bursa", "1194687");
INSERT INTO "city" VALUES ("99", "Gaziantep", "789000");
INSERT INTO "city" VALUES ("100", "Konya", "742690");
INSERT INTO "city" VALUES ("101", "Mersin Içel", "688789");
INSERT INTO "city" VALUES ("102", "Diyarbakir", "546000");
INSERT INTO "city" VALUES ("103", "Kayseri", "530000");
INSERT INTO "city" VALUES ("104", "Eskisehir", "470000");
INSERT INTO "city" VALUES ("105", "Malatya", "381000");
INSERT INTO "city" VALUES ("106", "Samsun", "369000");
INSERT INTO "city" VALUES ("107", "Antalya", "362000");
INSERT INTO "city" VALUES ("108", "Erzurum", "361237");
INSERT INTO "city" VALUES ("109", "Denizli", "350000");
INSERT INTO "city" VALUES ("110", "Sivas", "290000");
INSERT INTO "city" VALUES ("111", "Ordu", "270000");
INSERT INTO "city" VALUES ("112", "Kahramanmaras", "260000");
INSERT INTO "city" VALUES ("113", "Sanliurfa", "250000");
INSERT INTO "city" VALUES ("114", "Trabzon", "240000");
INSERT INTO "city" VALUES ("115", "Manisa", "220000");
INSERT INTO "city" VALUES ("116", "Hatay", "210000");
INSERT INTO "city" VALUES ("117", "Kocaeli", "200000");
INSERT INTO "city" VALUES ("118", "Van", "190000");
INSERT INTO "city" VALUES ("119", "Aydin", "180000");
INSERT INTO "city" VALUES ("120", "Usak", "170000");
INSERT INTO "city" VALUES ("121", "Afyon", "160000");
INSERT INTO "city" VALUES ("122", "Isparta", "150000");
INSERT INTO "city" VALUES ("123", "Çorum", "140000");
INSERT INTO "city" VALUES ("124", "Adiyaman", "130000");
INSERT INTO "city" VALUES ("125", "Elâzig", "120000");
INSERT INTO "city" VALUES ("126", "Amasya", "110000");
INSERT INTO "city" VALUES ("127", "Kütahya", "100000");
INSERT INTO "city" VALUES ("128", "Tekirdag", "90000");
INSERT INTO "city" VALUES ("129", "Tokat", "80000");
INSERT INTO "city" VALUES ("130", "Zonguldak", "70000");
INSERT INTO "city" VALUES ("131", "Karabük", "60000");
INSERT INTO "city" VALUES ("132", "Siirt", "50000");
INSERT INTO "city" VALUES ("133", "Yüksekova", "40000");
INSERT INTO "city" VALUES ("134", "Izmit", "195699");
INSERT INTO "city" VALUES ("135", "Gebze", "100000");
INSERT INTO "city" VALUES ("136", "Tiraspol", "182000");
INSERT INTO "city" VALUES ("137", "Bendery Tighina", "138000");
INSERT INTO "city" VALUES ("138", "Chisinau", "772200");
INSERT INTO "city" VALUES ("139", "Balti", "170000");
INSERT INTO "city" VALUES ("140", "Rîbnita", "60000");
INSERT INTO "city" VALUES ("141", "Kampala", "1200000");
INSERT INTO "city" VALUES ("142", "Jinja", "87000");
INSERT INTO "city" VALUES ("143", "Kiev", "2624000");
INSERT INTO "city" VALUES ("144", "Kharkiv", "1470000");
INSERT INTO "city" VALUES ("145", "Dnipropetrovsk", "1065000");
INSERT INTO "city" VALUES ("146", "Donetsk", "1016000");
INSERT INTO "city" VALUES ("147", "Odesa", "1011000");
INSERT INTO "city" VALUES ("148", "Lviv", "780000");
INSERT INTO "city" VALUES ("149", "Zaporizhzhya", "815000");
INSERT INTO "city" VALUES ("150", "Kryvyi Rih", "703000");
INSERT INTO "city" VALUES ("151", "Mykolayiv", "517000");
INSERT INTO "city" VALUES ("152", "Mariupol", "491000");
INSERT INTO "city" VALUES ("153", "Luhansk", "463000");
INSERT INTO "city" VALUES ("154", "Vinnytsya", "381000");
INSERT INTO "city" VALUES ("155", "Makiivka", "376000");
INSERT INTO "city" VALUES ("156", "Simferopol", "344000");
INSERT INTO "city" VALUES ("157", "Sevastopol", "342000");
INSERT INTO "city" VALUES ("158", "Chernihiv", "315000");
INSERT INTO "city" VALUES ("159", "Poltava", "313000");
INSERT INTO "city" VALUES ("160", "Cherkasy", "296000");
INSERT INTO "city" VALUES ("161", "Sumy", "294000");
INSERT INTO "city" VALUES ("162", "Zhytomyr", "284000");
INSERT INTO "city" VALUES ("163", "Horlivka", "281000");
INSERT INTO "city" VALUES ("164", "Khmelnytskyi", "262000");
INSERT INTO "city" VALUES ("165", "Kirovohrad", "259000");
INSERT INTO "city" VALUES ("166", "Rivne", "249000");
INSERT INTO "city" VALUES ("167", "Chernivtsi", "247000");
INSERT INTO "city" VALUES ("168", "Kremenchuk", "239000");
INSERT INTO "city" VALUES ("169", "Ternopil", "236000");
INSERT INTO "city" VALUES ("170", "Ivano-Frankivsk", "218000");
INSERT INTO "city" VALUES ("171", "Lutsk", "214000");
INSERT INTO "city" VALUES ("172", "Bila Tserkva", "206000");
INSERT INTO "city" VALUES ("173", "Kramatorsk", "186000");
INSERT INTO "city" VALUES ("174", "Melitopol", "169000");
INSERT INTO "city" VALUES ("175", "Kerch", "164000");
INSERT INTO "city" VALUES ("176", "Nikopol", "149000");
INSERT INTO "city" VALUES ("177", "Slavyansk", "141000");
INSERT INTO "city" VALUES ("178", "Berdyansk", "126000");
INSERT INTO "city" VALUES ("179", "Alchevsk", "120000");
INSERT INTO "city" VALUES ("180", "Pavlohrad", "119000");
INSERT INTO "city" VALUES ("181", "Severodonetsk", "117000");
INSERT INTO "city" VALUES ("182", "Yevpatoriya", "114000");
INSERT INTO "city" VALUES ("183", "Lysychansk", "113000");
INSERT INTO "city" VALUES ("184", "Kamyanets-Podilskyi", "109000");
INSERT INTO "city" VALUES ("185", "Uman", "90000");
INSERT INTO "city" VALUES ("186", "Brovary", "86000");
INSERT INTO "city" VALUES ("187", "Konotop", "85000");
INSERT INTO "city" VALUES ("188", "Mukacheve", "82000");
INSERT INTO "city" VALUES ("189", "Oleksandriya", "80000");
INSERT INTO "city" VALUES ("190", "Yalta", "80000");
INSERT INTO "city" VALUES ("191", "Krasnyi Luch", "79000");
INSERT INTO "city" VALUES ("192", "Smila", "75000");
INSERT INTO "city" VALUES ("193", "Uzhhorod", "116000");
INSERT INTO "city" VALUES ("194", "Kherson", "358000");
INSERT INTO "city" VALUES ("195", "Krasnodon", "53000");
INSERT INTO "city" VALUES ("196", "Stakhanov", "90000");
INSERT INTO "city" VALUES ("197", "Luhansk", "463000");
INSERT INTO "city" VALUES ("198", "Zaporizhzhya", "815000");
INSERT INTO "city" VALUES ("199", "Abu Dhabi", "942000");
INSERT INTO "city" VALUES ("200", "Dubai", "1134000");
INSERT INTO "city" VALUES ("201", "Sharjah", "475000");
INSERT INTO "city" VALUES ("202", "Al-Ayn", "340000");
INSERT INTO "city" VALUES ("203", "Ajman", "120000");
INSERT INTO "city" VALUES ("204", "Ras al-Khayma", "100000");
INSERT INTO "city" VALUES ("205", "Fujairah", "50000");
INSERT INTO "city" VALUES ("206", "Umm al-Qaywayn", "30000");
INSERT INTO "city" VALUES ("207", "London", "7285000");
INSERT INTO "city" VALUES ("208", "Birmingham", "970892");
INSERT INTO "city" VALUES ("209", "Glasgow", "619660");
INSERT INTO "city" VALUES ("210", "Liverpool", "469017");
INSERT INTO "city" VALUES ("211", "Edinburgh", "450180");
INSERT INTO "city" VALUES ("212", "Sheffield", "439866");
INSERT INTO "city" VALUES ("213", "Manchester", "430811");
INSERT INTO "city" VALUES ("214", "Leeds", "424194");
INSERT INTO "city" VALUES ("215", "Bristol", "399633");
INSERT INTO "city" VALUES ("216", "Cardiff", "308500");
INSERT INTO "city" VALUES ("217", "Coventry", "300848");
INSERT INTO "city" VALUES ("218", "Leicester", "290000");
INSERT INTO "city" VALUES ("219", "Bradford", "280000");
INSERT INTO "city" VALUES ("220", "Belfast", "279200");
INSERT INTO "city" VALUES ("221", "Nottingham", "270000");
INSERT INTO "city" VALUES ("222", "Kingston upon Hull", "260000");
INSERT INTO "city" VALUES ("223", "Croydon", "250000");
INSERT INTO "city" VALUES ("224", "Stoke-on-Trent", "240000");
INSERT INTO "city" VALUES ("225", "Wolverhampton", "230000");
INSERT INTO "city" VALUES ("226", "Derby", "220000");
INSERT INTO "city" VALUES ("227", "Plymouth", "210000");
INSERT INTO "city" VALUES ("228", "Sunderland", "200000");
INSERT INTO "city" VALUES ("229", "Dudley", "190000");
INSERT INTO "city" VALUES ("230", "Newcastle upon Tyne", "189000");
INSERT INTO "city" VALUES ("231", "Southampton", "188000");
INSERT INTO "city" VALUES ("232", "Walsall", "187000");
INSERT INTO "city" VALUES ("233", "Aberdeen", "186000");
INSERT INTO "city" VALUES ("234", "Bolton", "185000");
INSERT INTO "city" VALUES ("235", "Bournemouth", "184000");
INSERT INTO "city" VALUES ("236", "Southend-on-Sea", "183000");
INSERT INTO "city" VALUES ("237", "Reading", "182000");
INSERT INTO "city" VALUES ("238", "Swansea", "181000");
INSERT INTO "city" VALUES ("239", "Preston", "180000");
INSERT INTO "city" VALUES ("240", "Blackburn", "179000");
INSERT INTO "city" VALUES ("241", "Basildon", "178000");
INSERT INTO "city" VALUES ("242", "Brighton", "177000");
INSERT INTO "city" VALUES ("243", "Luton", "176000");
INSERT INTO "city" VALUES ("244", "Swindon", "175000");
INSERT INTO "city" VALUES ("245", "Slough", "174000");
INSERT INTO "city" VALUES ("246", "Oldham", "173000");
INSERT INTO "city" VALUES ("247", "Blackpool", "172000");
INSERT INTO "city" VALUES ("248", "Middlesbrough", "171000");
INSERT INTO "city" VALUES ("249", "Wigan", "170000");
INSERT INTO "city" VALUES ("250", "Solihull", "169000");
INSERT INTO "city" VALUES ("251", "Warrington", "168000");
INSERT INTO "city" VALUES ("252", "Huddersfield", "167000");
INSERT INTO "city" VALUES ("253", "East Kilbride", "166000");
INSERT INTO "city" VALUES ("254", "Dundee", "165000");
INSERT INTO "city" VALUES ("255", "Rotherham", "164000");
INSERT INTO "city" VALUES ("256", "Rochdale", "163000");
INSERT INTO "city" VALUES ("257", "West Bromwich", "162000");
INSERT INTO "city" VALUES ("258", "Birkenhead", "161000");
INSERT INTO "city" VALUES ("259", "Worcester", "160000");
INSERT INTO "city" VALUES ("260", "Peterborough", "159000");
INSERT INTO "city" VALUES ("261", "Newport", "158000");
INSERT INTO "city" VALUES ("262", "Gillingham", "157000");
INSERT INTO "city" VALUES ("263", "Telford", "156000");
INSERT INTO "city" VALUES ("264", "Gloucester", "155000");
INSERT INTO "city" VALUES ("265", "York", "154000");
INSERT INTO "city" VALUES ("266", "Norwich", "153000");
INSERT INTO "city" VALUES ("267", "Chesterfield", "152000");
INSERT INTO "city" VALUES ("268", "Watford", "151000");