INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Gütersloh','DEU','Nordrhein-Westfalen',95028);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Marl','DEU','Nordrhein-Westfalen',93735);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lünen','DEU','Nordrhein-Westfalen',92044);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Düren','DEU','Nordrhein-Westfalen',91092);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ratingen','DEU','Nordrhein-Westfalen',90951);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Velbert','DEU','Nordrhein-Westfalen',89881);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Esslingen am Neckar','DEU','Baden-Württemberg',89667);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Honiara','SLB','Honiara',50100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lusaka','ZMB','Lusaka',1317000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ndola','ZMB','Copperbelt',329200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kitwe','ZMB','Copperbelt',288600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kabwe','ZMB','Central',154300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chingola','ZMB','Copperbelt',142400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mufulira','ZMB','Copperbelt',123900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Luanshya','ZMB','Copperbelt',118100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Apia','WSM','Upolu',35900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Serravalle','SMR','Serravalle/Dogano',4802);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('San Marino','SMR','San Marino',2294);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('São Tomé','STP','Aqua Grande',49541);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Riyadh','SAU','Riyadh',3324000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jedda','SAU','Mekka',2046300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mekka','SAU','Mekka',965700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Medina','SAU','Medina',608300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Dammam','SAU','al-Sharqiya',482300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Taif','SAU','Mekka',416100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tabuk','SAU','Tabuk',292600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Burayda','SAU','al-Qasim',248600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Hufuf','SAU','al-Sharqiya',225800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Mubarraz','SAU','al-Sharqiya',219100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Khamis Mushayt','SAU','Asir',217900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hail','SAU','Hail',176800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Kharj','SAU','Riad',152100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Khubar','SAU','al-Sharqiya',141700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jubayl','SAU','al-Sharqiya',140800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hafar al-Batin','SAU','al-Sharqiya',137800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Tuqba','SAU','al-Sharqiya',125700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Yanbu','SAU','Medina',119800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Abha','SAU','Asir',112300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('AraŽar','SAU','al-Khudud al-Samaliy',108100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Qatif','SAU','al-Sharqiya',98900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Hawiya','SAU','Mekka',93900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Unayza','SAU','Qasim',91100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Najran','SAU','Najran',91000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pikine','SEN','Cap-Vert',855287);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dakar','SEN','Cap-Vert',785071);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Thiès','SEN','Thiès',248000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kaolack','SEN','Kaolack',199000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ziguinchor','SEN','Ziguinchor',192000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Rufisque','SEN','Cap-Vert',150000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Saint-Louis','SEN','Saint-Louis',132400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mbour','SEN','Thiès',109300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Diourbel','SEN','Diourbel',99400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Victoria','SYC','Mahé',41000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Freetown','SLE','Western',850000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Singapore','SGP','',4017733);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bratislava','SVK','Bratislava',448292);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Koice','SVK','Východné Slovensko',241874);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Preov','SVK','Východné Slovensko',93977);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ljubljana','SVN','Osrednjeslovenska',270986);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Maribor','SVN','Podravska',115532);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mogadishu','SOM','Banaadir',997000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hargeysa','SOM','Woqooyi Galbeed',90000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kismaayo','SOM','Jubbada Hoose',90000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Colombo','LKA','Western',645000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dehiwala','LKA','Western',203000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Moratuwa','LKA','Western',190000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jaffna','LKA','Northern',149000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kandy','LKA','Central',140000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sri Jayawardenepura Kotte','LKA','Western',118000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Negombo','LKA','Western',100000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Omdurman','SDN','Khartum',1271403);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Khartum','SDN','Khartum',947483);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sharq al-Nil','SDN','Khartum',700887);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Port Sudan','SDN','al-Bahr al-Ahmar',308195);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kassala','SDN','Kassala',234622);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Obeid','SDN','Kurdufan al-Shamaliy',229425);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nyala','SDN','Darfur al-Janubiya',227183);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Wad Madani','SDN','al-Jazira',211362);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Qadarif','SDN','al-Qadarif',191164);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kusti','SDN','al-Bahr al-Abyad',173599);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Fashir','SDN','Darfur al-Shamaliya',141884);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Juba','SDN','Bahr al-Jabal',114980);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Helsinki [Helsingfors]','FIN','Newmaa',555474);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Espoo','FIN','Newmaa',213271);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tampere','FIN','Pirkanmaa',195468);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Vantaa','FIN','Newmaa',178471);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Turku [Åbo]','FIN','Varsinais-Suomi',172561);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Oulu','FIN','Pohjois-Pohjanmaa',120753);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lahti','FIN','Päijät-Häme',96921);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Paramaribo','SUR','Paramaribo',112000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mbabane','SWZ','Hhohho',61000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Zürich','CHE','Zürich',336800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Geneve','CHE','Geneve',173500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Basel','CHE','Basel-Stadt',166700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bern','CHE','Bern',122700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lausanne','CHE','Vaud',114500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Damascus','SYR','Damascus',1347000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Aleppo','SYR','Aleppo',1261983);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hims','SYR','Hims',507404);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hama','SYR','Hama',343361);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Latakia','SYR','Latakia',264563);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Qamishliya','SYR','al-Hasaka',144286);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dayr al-Zawr','SYR','Dayr al-Zawr',140459);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jaramana','SYR','Damaskos',138469);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Duma','SYR','Damaskos',131158);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('al-Raqqa','SYR','al-Raqqa',108020);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Idlib','SYR','Idlib',91081);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dushanbe','TJK','Karotegin',524000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Khujand','TJK','Khujand',161500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Taipei','TWN','Taipei',2641312);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kaohsiung','TWN','Kaohsiung',1475505);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Taichung','TWN','Taichung',940589);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tainan','TWN','Tainan',728060);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Panchiao','TWN','Taipei',523850);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chungho','TWN','Taipei',392176);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Keelung (Chilung)','TWN','Keelung',385201);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sanchung','TWN','Taipei',380084);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hsinchuang','TWN','Taipei',365048);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hsinchu','TWN','Hsinchu',361958);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chungli','TWN','Taoyuan',318649);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fengshan','TWN','Kaohsiung',318562);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Taoyuan','TWN','Taoyuan',316438);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chiayi','TWN','Chiayi',265109);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hsintien','TWN','Taipei',263603);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Changhwa','TWN','Changhwa',227715);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Yungho','TWN','Taipei',227700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tucheng','TWN','Taipei',224897);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pingtung','TWN','Pingtung',214727);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Yungkang','TWN','Tainan',193005);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pingchen','TWN','Taoyuan',188344);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tali','TWN','Taichung',171940);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Taiping','TWN','',165524);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pate','TWN','Taoyuan',161700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fengyuan','TWN','Taichung',161032);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Luchou','TWN','Taipei',160516);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hsichuh','TWN','Taipei',154976);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Shulin','TWN','Taipei',151260);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Yuanlin','TWN','Changhwa',126402);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Yangmei','TWN','Taoyuan',126323);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Taliao','TWN','',115897);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kueishan','TWN','',112195);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tanshui','TWN','Taipei',111882);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Taitung','TWN','Taitung',111039);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hualien','TWN','Hualien',108407);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nantou','TWN','Nantou',104723);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lungtan','TWN','Taipei',103088);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Touliu','TWN','Yünlin',98900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tsaotun','TWN','Nantou',96800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kangshan','TWN','Kaohsiung',92200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ilan','TWN','Ilan',92000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Miaoli','TWN','Miaoli',90000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dar es Salaam','TZA','Dar es Salaam',1747000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dodoma','TZA','Dodoma',189000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mwanza','TZA','Mwanza',172300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Zanzibar','TZA','Zanzibar West',157634);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tanga','TZA','Tanga',137400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mbeya','TZA','Mbeya',130800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Morogoro','TZA','Morogoro',117800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Arusha','TZA','Arusha',102500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Moshi','TZA','Kilimanjaro',96800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tabora','TZA','Tabora',92800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('København','DNK','København',495699);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Århus','DNK','Århus',284846);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Odense','DNK','Fyn',183912);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Aalborg','DNK','Nordjylland',161161);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Frederiksberg','DNK','Frederiksberg',90327);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bangkok','THA','Bangkok',6320174);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nonthaburi','THA','Nonthaburi',292100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nakhon Ratchasima','THA','Nakhon Ratchasima',181400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chiang Mai','THA','Chiang Mai',171100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Udon Thani','THA','Udon Thani',158100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hat Yai','THA','Songkhla',148632);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Khon Kaen','THA','Khon Kaen',126500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pak Kret','THA','Nonthaburi',126055);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nakhon Sawan','THA','Nakhon Sawan',123800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ubon Ratchathani','THA','Ubon Ratchathani',116300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Songkhla','THA','Songkhla',94900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nakhon Pathom','THA','Nakhon Pathom',94100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lomé','TGO','Maritime',375000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fakaofo','TKL','Fakaofo',300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('NukuŽalofa','TON','Tongatapu',22400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chaguanas','TTO','Caroni',56601);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Port-of-Spain','TTO','Port-of-Spain',43396);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('NŽDjaména','TCD','Chari-Baguirmi',530965);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Moundou','TCD','Logone Occidental',99500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Praha','CZE','Hlavní mesto Praha',1181126);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Brno','CZE','Jizní Morava',381862);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ostrava','CZE','Severní Morava',320041);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Plzen','CZE','Zapadní Cechy',166759);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Olomouc','CZE','Severní Morava',102702);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Liberec','CZE','Severní Cechy',99155);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ceské Budejovice','CZE','Jizní Cechy',98186);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hradec Králové','CZE','Východní Cechy',98080);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ústí nad Labem','CZE','Severní Cechy',95491);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pardubice','CZE','Východní Cechy',91309);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tunis','TUN','Tunis',690600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sfax','TUN','Sfax',257800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ariana','TUN','Ariana',197000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ettadhamen','TUN','Ariana',178600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sousse','TUN','Sousse',145900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kairouan','TUN','Kairouan',113100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Biserta','TUN','Biserta',108900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Gabès','TUN','Gabès',106600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Istanbul','TUR','Istanbul',8787958);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ankara','TUR','Ankara',3038159);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Izmir','TUR','Izmir',2130359);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Adana','TUR','Adana',1131198);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bursa','TUR','Bursa',1095842);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Gaziantep','TUR','Gaziantep',789056);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Konya','TUR','Konya',628364);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mersin (Içel)','TUR','Içel',587212);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Antalya','TUR','Antalya',564914);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Diyarbakir','TUR','Diyarbakir',479884);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kayseri','TUR','Kayseri',475657);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Eskisehir','TUR','Eskisehir',470781);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sanliurfa','TUR','Sanliurfa',405905);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Samsun','TUR','Samsun',339871);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Malatya','TUR','Malatya',330312);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Gebze','TUR','Kocaeli',264170);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Denizli','TUR','Denizli',253848);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sivas','TUR','Sivas',246642);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Erzurum','TUR','Erzurum',246535);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tarsus','TUR','Adana',246206);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kahramanmaras','TUR','Kahramanmaras',245772);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Elâzig','TUR','Elâzig',228815);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Van','TUR','Van',219319);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sultanbeyli','TUR','Istanbul',211068);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Izmit (Kocaeli)','TUR','Kocaeli',210068);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Manisa','TUR','Manisa',207148);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Batman','TUR','Batman',203793);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Balikesir','TUR','Balikesir',196382);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sakarya (Adapazari)','TUR','Sakarya',190641);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Iskenderun','TUR','Hatay',153022);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Osmaniye','TUR','Osmaniye',146003);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Çorum','TUR','Çorum',145495);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kütahya','TUR','Kütahya',144761);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hatay (Antakya)','TUR','Hatay',143982);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kirikkale','TUR','Kirikkale',142044);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Adiyaman','TUR','Adiyaman',141529);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Trabzon','TUR','Trabzon',138234);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ordu','TUR','Ordu',133642);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Aydin','TUR','Aydin',128651);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Usak','TUR','Usak',128162);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Edirne','TUR','Edirne',123383);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Çorlu','TUR','Tekirdag',123300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Isparta','TUR','Isparta',121911);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Karabük','TUR','Karabük',118285);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kilis','TUR','Kilis',118245);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Alanya','TUR','Antalya',117300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kiziltepe','TUR','Mardin',112000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Zonguldak','TUR','Zonguldak',111542);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Siirt','TUR','Siirt',107100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Viransehir','TUR','Sanliurfa',106400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tekirdag','TUR','Tekirdag',106077);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Karaman','TUR','Karaman',104200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Afyon','TUR','Afyon',103984);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Aksaray','TUR','Aksaray',102681);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ceyhan','TUR','Adana',102412);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Erzincan','TUR','Erzincan',102304);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bismil','TUR','Diyarbakir',101400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nazilli','TUR','Aydin',99900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tokat','TUR','Tokat',99500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kars','TUR','Kars',93000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Inegöl','TUR','Bursa',90500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bandirma','TUR','Balikesir',90200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ashgabat','TKM','Ahal',540600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chärjew','TKM','Lebap',189200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dashhowuz','TKM','Dashhowuz',141800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mary','TKM','Mary',101000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Cockburn Town','TCA','Grand Turk',4800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Funafuti','TUV','Funafuti',4600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kampala','UGA','Central',890800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kyiv','UKR','Kiova',2624000);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Harkova [Harkiv]','UKR','Harkova',1500000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dnipropetrovsk','UKR','Dnipropetrovsk',1103000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Donetsk','UKR','Donetsk',1050000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Odesa','UKR','Odesa',1011000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Zaporizzja','UKR','Zaporizzja',848000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lviv','UKR','Lviv',788000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kryvyi Rig','UKR','Dnipropetrovsk',703000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mykolajiv','UKR','Mykolajiv',508000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mariupol','UKR','Donetsk',490000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lugansk','UKR','Lugansk',469000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Vinnytsja','UKR','Vinnytsja',391000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Makijivka','UKR','Donetsk',384000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Herson','UKR','Herson',353000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sevastopol','UKR','Krim',348000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Simferopol','UKR','Krim',339000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pultava [Poltava]','UKR','Pultava',313000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ternigiv','UKR','Ternigiv',313000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Terkasy','UKR','Terkasy',309000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Gorlivka','UKR','Donetsk',299000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Zytomyr','UKR','Zytomyr',297000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sumy','UKR','Sumy',294000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dniprodzerzynsk','UKR','Dnipropetrovsk',270000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kirovograd','UKR','Kirovograd',265000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hmelnytskyi','UKR','Hmelnytskyi',262000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ternivtsi','UKR','Ternivtsi',259000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Rivne','UKR','Rivne',245000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Krementuk','UKR','Pultava',239000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ivano-Frankivsk','UKR','Ivano-Frankivsk',237000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ternopil','UKR','Ternopil',236000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lutsk','UKR','Volynia',217000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bila Tserkva','UKR','Kiova',215000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kramatorsk','UKR','Donetsk',186000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Melitopol','UKR','Zaporizzja',169000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kert','UKR','Krim',162000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nikopol','UKR','Dnipropetrovsk',149000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Berdjansk','UKR','Zaporizzja',130000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pavlograd','UKR','Dnipropetrovsk',127000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sjeverodonetsk','UKR','Lugansk',127000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Slovjansk','UKR','Donetsk',127000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Uzgorod','UKR','Taka-Karpatia',127000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Altevsk','UKR','Lugansk',119000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lysytansk','UKR','Lugansk',116000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jevpatorija','UKR','Krim',112000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kamjanets-Podilskyi','UKR','Hmelnytskyi',109000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jenakijeve','UKR','Donetsk',105000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Krasnyi Lut','UKR','Lugansk',101000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Stahanov','UKR','Lugansk',101000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Oleksandrija','UKR','Kirovograd',99000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Konotop','UKR','Sumy',96000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kostjantynivka','UKR','Donetsk',95000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Berdytiv','UKR','Zytomyr',90000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Izmajil','UKR','Odesa',90000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('ostka','UKR','Sumy',90000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Uman','UKR','Terkasy',90000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Brovary','UKR','Kiova',89000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mukateve','UKR','Taka-Karpatia',89000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Budapest','HUN','Budapest',1811552);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Debrecen','HUN','Hajdú-Bihar',203648);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Miskolc','HUN','Borsod-Abaúj-Zemplén',172357);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Szeged','HUN','Csongrád',158158);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pécs','HUN','Baranya',157332);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Györ','HUN','Györ-Moson-Sopron',127119);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nyiregyháza','HUN','Szabolcs-Szatmár-Ber',112419);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kecskemét','HUN','Bács-Kiskun',105606);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Székesfehérvár','HUN','Fejér',105119);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Montevideo','URY','Montevideo',1236000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nouméa','NCL','',76293);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Auckland','NZL','Auckland',381800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Christchurch','NZL','Canterbury',324200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Manukau','NZL','Auckland',281800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('North Shore','NZL','Auckland',187700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Waitakere','NZL','Auckland',170600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Wellington','NZL','Wellington',166700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dunedin','NZL','Dunedin',119600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hamilton','NZL','Hamilton',117100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lower Hutt','NZL','Wellington',98100);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Toskent','UZB','Toskent Shahri',2117500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Namangan','UZB','Namangan',370500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Samarkand','UZB','Samarkand',361800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Andijon','UZB','Andijon',318600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Buhoro','UZB','Buhoro',237100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Karsi','UZB','Qashqadaryo',194100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nukus','UZB','Karakalpakistan',194100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kükon','UZB','Fargona',190100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fargona','UZB','Fargona',180500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Circik','UZB','Toskent',146400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Margilon','UZB','Fargona',140800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ürgenc','UZB','Khorazm',138900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Angren','UZB','Toskent',128000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Cizah','UZB','Cizah',124800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Navoi','UZB','Navoi',116300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Olmalik','UZB','Toskent',114900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Termiz','UZB','Surkhondaryo',109500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Minsk','BLR','Horad Minsk',1674000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Gomel','BLR','Gomel',475000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mogiljov','BLR','Mogiljov',356000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Vitebsk','BLR','Vitebsk',340000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Grodno','BLR','Grodno',302000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Brest','BLR','Brest',286000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bobruisk','BLR','Mogiljov',221000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Baranoviti','BLR','Brest',167000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Borisov','BLR','Minsk',151000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pinsk','BLR','Brest',130000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ora','BLR','Vitebsk',124000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mozyr','BLR','Gomel',110000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Novopolotsk','BLR','Vitebsk',106000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lida','BLR','Grodno',101000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Soligorsk','BLR','Minsk',101000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Molodetno','BLR','Minsk',97000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mata-Utu','WLF','Wallis',1137);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Port-Vila','VUT','Shefa',33700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Città del Vaticano','VAT','',455);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Caracas','VEN','Distrito Federal',1975294);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Maracaíbo','VEN','Zulia',1304776);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Barquisimeto','VEN','Lara',877239);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Valencia','VEN','Carabobo',794246);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ciudad Guayana','VEN','Bolívar',663713);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Petare','VEN','Miranda',488868);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Maracay','VEN','Aragua',444443);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Barcelona','VEN','Anzoátegui',322267);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Maturín','VEN','Monagas',319726);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('San Cristóbal','VEN','Táchira',319373);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ciudad Bolívar','VEN','Bolívar',301107);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Cumaná','VEN','Sucre',293105);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mérida','VEN','Mérida',224887);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Cabimas','VEN','Zulia',221329);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Barinas','VEN','Barinas',217831);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Turmero','VEN','Aragua',217499);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Baruta','VEN','Miranda',207290);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Puerto Cabello','VEN','Carabobo',187722);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Santa Ana de Coro','VEN','Falcón',185766);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Los Teques','VEN','Miranda',178784);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Punto Fijo','VEN','Falcón',167215);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Guarenas','VEN','Miranda',165889);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Acarigua','VEN','Portuguesa',158954);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Puerto La Cruz','VEN','Anzoátegui',155700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ciudad Losada','VEN','',134501);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Guacara','VEN','Carabobo',131334);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Valera','VEN','Trujillo',130281);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Guanare','VEN','Portuguesa',125621);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Carúpano','VEN','Sucre',119639);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Catia La Mar','VEN','Distrito Federal',117012);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('El Tigre','VEN','Anzoátegui',116256);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Guatire','VEN','Miranda',109121);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Calabozo','VEN','Guárico',107146);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pozuelos','VEN','Anzoátegui',105690);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ciudad Ojeda','VEN','Zulia',99354);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ocumare del Tuy','VEN','Miranda',97168);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Valle de la Pascua','VEN','Guárico',95927);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Araure','VEN','Portuguesa',94269);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('San Fernando de Apure','VEN','Apure',93809);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('San Felipe','VEN','Yaracuy',90940);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('El Limón','VEN','Aragua',90000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Moscow','RUS','Moscow (City)',8389200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('St Petersburg','RUS','Pietari',4694000);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Novosibirsk','RUS','Novosibirsk',1398800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nizni Novgorod','RUS','Nizni Novgorod',1357000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jekaterinburg','RUS','Sverdlovsk',1266300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Samara','RUS','Samara',1156100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Omsk','RUS','Omsk',1148900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kazan','RUS','Tatarstan',1101000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ufa','RUS','Bakortostan',1091200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Teljabinsk','RUS','Teljabinsk',1083200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Rostov-na-Donu','RUS','Rostov-na-Donu',1012700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Perm','RUS','Perm',1009700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Volgograd','RUS','Volgograd',993400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Voronez','RUS','Voronez',907700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Krasnojarsk','RUS','Krasnojarsk',875500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Saratov','RUS','Saratov',874000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Toljatti','RUS','Samara',722900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Uljanovsk','RUS','Uljanovsk',667400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Izevsk','RUS','Udmurtia',652800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Krasnodar','RUS','Krasnodar',639000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jaroslavl','RUS','Jaroslavl',616700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Habarovsk','RUS','Habarovsk',609400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Vladivostok','RUS','Primorje',606200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Irkutsk','RUS','Irkutsk',593700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Barnaul','RUS','Altai',580100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Novokuznetsk','RUS','Kemerovo',561600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Penza','RUS','Penza',532200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Rjazan','RUS','Rjazan',529900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Orenburg','RUS','Orenburg',523600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lipetsk','RUS','Lipetsk',521000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nabereznyje Telny','RUS','Tatarstan',514700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tula','RUS','Tula',506100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tjumen','RUS','Tjumen',503400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kemerovo','RUS','Kemerovo',492700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Astrahan','RUS','Astrahan',486100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tomsk','RUS','Tomsk',482100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kirov','RUS','Kirov',466200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ivanovo','RUS','Ivanovo',459200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Teboksary','RUS','Tuvassia',459200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Brjansk','RUS','Brjansk',457400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tver','RUS','Tver',454900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kursk','RUS','Kursk',443500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Magnitogorsk','RUS','Teljabinsk',427900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kaliningrad','RUS','Kaliningrad',424400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nizni Tagil','RUS','Sverdlovsk',390900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Murmansk','RUS','Murmansk',376300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ulan-Ude','RUS','Burjatia',370400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kurgan','RUS','Kurgan',364700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Arkangeli','RUS','Arkangeli',361800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Soti','RUS','Krasnodar',358600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Smolensk','RUS','Smolensk',353400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Orjol','RUS','Orjol',344500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Stavropol','RUS','Stavropol',343300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Belgorod','RUS','Belgorod',342000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kaluga','RUS','Kaluga',339300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Vladimir','RUS','Vladimir',337100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mahatkala','RUS','Dagestan',332800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Terepovets','RUS','Vologda',324400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Saransk','RUS','Mordva',314800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tambov','RUS','Tambov',312000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Vladikavkaz','RUS','North Ossetia-Alania',310100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tita','RUS','Tita',309900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Vologda','RUS','Vologda',302500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Veliki Novgorod','RUS','Novgorod',299500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Komsomolsk-na-Amure','RUS','Habarovsk',291600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kostroma','RUS','Kostroma',288100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Volzski','RUS','Volgograd',286900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Taganrog','RUS','Rostov-na-Donu',284400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Petroskoi','RUS','Karjala',282100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bratsk','RUS','Irkutsk',277600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dzerzinsk','RUS','Nizni Novgorod',277100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Surgut','RUS','Hanti-Mansia',274900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Orsk','RUS','Orenburg',273900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sterlitamak','RUS','Bakortostan',265200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Angarsk','RUS','Irkutsk',264700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jokar-Ola','RUS','Marinmaa',249200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Rybinsk','RUS','Jaroslavl',239600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Prokopjevsk','RUS','Kemerovo',237300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Niznevartovsk','RUS','Hanti-Mansia',233900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Naltik','RUS','Kabardi-Balkaria',233400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Syktyvkar','RUS','Komi',229700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Severodvinsk','RUS','Arkangeli',229300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bijsk','RUS','Altai',225000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Niznekamsk','RUS','Tatarstan',223400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Blagovetensk','RUS','Amur',222000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('ahty','RUS','Rostov-na-Donu',221800);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Staryi Oskol','RUS','Belgorod',213800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Zelenograd','RUS','Moscow (City)',207100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Balakovo','RUS','Saratov',206000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Novorossijsk','RUS','Krasnodar',203300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pihkova','RUS','Pihkova',201500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Zlatoust','RUS','Teljabinsk',196900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jakutsk','RUS','Saha (Jakutia)',195400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Podolsk','RUS','Moskova',194300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Petropavlovsk-Kamtatski','RUS','Kamtatka',194100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kamensk-Uralski','RUS','Sverdlovsk',190600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Engels','RUS','Saratov',189000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Syzran','RUS','Samara',186900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Grozny','RUS','Tetenia',186000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Novoterkassk','RUS','Rostov-na-Donu',184400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Berezniki','RUS','Perm',181900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Juzno-Sahalinsk','RUS','Sahalin',179200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Volgodonsk','RUS','Rostov-na-Donu',178200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Abakan','RUS','Hakassia',169200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Maikop','RUS','Adygea',167300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Miass','RUS','Teljabinsk',166200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Armavir','RUS','Krasnodar',164900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ljubertsy','RUS','Moskova',163900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Rubtsovsk','RUS','Altai',162600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kovrov','RUS','Vladimir',159900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nahodka','RUS','Primorje',157700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ussurijsk','RUS','Primorje',157300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Salavat','RUS','Bakortostan',156800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mytiti','RUS','Moskova',155700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kolomna','RUS','Moskova',150700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Elektrostal','RUS','Moskova',147000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Murom','RUS','Vladimir',142400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kolpino','RUS','Pietari',141200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Norilsk','RUS','Krasnojarsk',140800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Almetjevsk','RUS','Tatarstan',140700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Novomoskovsk','RUS','Tula',138100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dimitrovgrad','RUS','Uljanovsk',137000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pervouralsk','RUS','Sverdlovsk',136100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Himki','RUS','Moskova',133700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Balaiha','RUS','Moskova',132900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nevinnomyssk','RUS','Stavropol',132600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pjatigorsk','RUS','Stavropol',132500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Korolev','RUS','Moskova',132400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Serpuhov','RUS','Moskova',132000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Odintsovo','RUS','Moskova',127400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Orehovo-Zujevo','RUS','Moskova',124900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kamyin','RUS','Volgograd',124600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Novoteboksarsk','RUS','Tuvassia',123400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Terkessk','RUS','Karatai-Terkessia',121700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Atinsk','RUS','Krasnojarsk',121600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Magadan','RUS','Magadan',121000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Miturinsk','RUS','Tambov',120700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kislovodsk','RUS','Stavropol',120400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jelets','RUS','Lipetsk',119400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Seversk','RUS','Tomsk',118600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Noginsk','RUS','Moskova',117200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Velikije Luki','RUS','Pihkova',116300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Novokuibyevsk','RUS','Samara',116200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Neftekamsk','RUS','Bakortostan',115700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Leninsk-Kuznetski','RUS','Kemerovo',113800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Oktjabrski','RUS','Bakortostan',111500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sergijev Posad','RUS','Moskova',111100);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Arzamas','RUS','Nizni Novgorod',110700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kiseljovsk','RUS','Kemerovo',110000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Novotroitsk','RUS','Orenburg',109600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Obninsk','RUS','Kaluga',108300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kansk','RUS','Krasnojarsk',107400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Glazov','RUS','Udmurtia',106300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Solikamsk','RUS','Perm',106000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sarapul','RUS','Udmurtia',105700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ust-Ilimsk','RUS','Irkutsk',105200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('tolkovo','RUS','Moskova',104900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mezduretensk','RUS','Kemerovo',104400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Usolje-Sibirskoje','RUS','Irkutsk',103500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Elista','RUS','Kalmykia',103300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Novoahtinsk','RUS','Rostov-na-Donu',101900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Votkinsk','RUS','Udmurtia',101700);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kyzyl','RUS','Tyva',101100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Serov','RUS','Sverdlovsk',100400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Zelenodolsk','RUS','Tatarstan',100200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Zeleznodoroznyi','RUS','Moskova',100100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kinema','RUS','Ivanovo',100000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kuznetsk','RUS','Penza',98200);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Uhta','RUS','Komi',98000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jessentuki','RUS','Stavropol',97900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tobolsk','RUS','Tjumen',97600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Neftejugansk','RUS','Hanti-Mansia',97400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bataisk','RUS','Rostov-na-Donu',97300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nojabrsk','RUS','Yamalin Nenetsia',97300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Balaov','RUS','Saratov',97100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Zeleznogorsk','RUS','Kursk',96900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Zukovski','RUS','Moskova',96500);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Anzero-Sudzensk','RUS','Kemerovo',96100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bugulma','RUS','Tatarstan',94100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Zeleznogorsk','RUS','Krasnojarsk',94000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Novouralsk','RUS','Sverdlovsk',93300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pukin','RUS','Pietari',92900);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Vorkuta','RUS','Komi',92600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Derbent','RUS','Dagestan',92300);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kirovo-Tepetsk','RUS','Kirov',91600);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Krasnogorsk','RUS','Moskova',91000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Klin','RUS','Moskova',90000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Taikovski','RUS','Perm',90000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Novyi Urengoi','RUS','Yamalin Nenetsia',89800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ho Chi Minh City','VNM','Ho Chi Minh City',3980000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hanoi','VNM','Hanoi',1410000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Haiphong','VNM','Haiphong',783133);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Da Nang','VNM','Quang Nam-Da Nang',382674);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Biên Hoa','VNM','Dong Nai',282095);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nha Trang','VNM','Khanh Hoa',221331);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hue','VNM','Thua Thien-Hue',219149);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Can Tho','VNM','Can Tho',215587);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Cam Pha','VNM','Quang Binh',209086);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nam Dinh','VNM','Nam Ha',171699);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Quy Nhon','VNM','Binh Dinh',163385);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Vung Tau','VNM','Ba Ria-Vung Tau',145145);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Rach Gia','VNM','Kien Giang',141132);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Long Xuyen','VNM','An Giang',132681);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Thai Nguyen','VNM','Bac Thai',127643);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hong Gai','VNM','Quang Ninh',127484);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Phan Thiêt','VNM','Binh Thuan',114236);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Cam Ranh','VNM','Khanh Hoa',114041);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Vinh','VNM','Nghe An',112455);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('My Tho','VNM','Tien Giang',108404);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Da Lat','VNM','Lam Dong',106409);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Buon Ma Thuot','VNM','Dac Lac',97044);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tallinn','EST','Harjumaa',403981);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tartu','EST','Tartumaa',101246);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('New York','USA','New York',8008278);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Los Angeles','USA','California',3694820);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chicago','USA','Illinois',2896016);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Houston','USA','Texas',1953631);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Philadelphia','USA','Pennsylvania',1517550);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Phoenix','USA','Arizona',1321045);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('San Diego','USA','California',1223400);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dallas','USA','Texas',1188580);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('San Antonio','USA','Texas',1144646);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Detroit','USA','Michigan',951270);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('San Jose','USA','California',894943);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Indianapolis','USA','Indiana',791926);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('San Francisco','USA','California',776733);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jacksonville','USA','Florida',735167);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Columbus','USA','Ohio',711470);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Austin','USA','Texas',656562);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Baltimore','USA','Maryland',651154);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Memphis','USA','Tennessee',650100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Milwaukee','USA','Wisconsin',596974);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Boston','USA','Massachusetts',589141);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Washington','USA','District of Columbia',572059);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nashville-Davidson','USA','Tennessee',569891);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('El Paso','USA','Texas',563662);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Seattle','USA','Washington',563374);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Denver','USA','Colorado',554636);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Charlotte','USA','North Carolina',540828);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fort Worth','USA','Texas',534694);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Portland','USA','Oregon',529121);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Oklahoma City','USA','Oklahoma',506132);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tucson','USA','Arizona',486699);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('New Orleans','USA','Louisiana',484674);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Las Vegas','USA','Nevada',478434);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Cleveland','USA','Ohio',478403);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Long Beach','USA','California',461522);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Albuquerque','USA','New Mexico',448607);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kansas City','USA','Missouri',441545);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fresno','USA','California',427652);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Virginia Beach','USA','Virginia',425257);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Atlanta','USA','Georgia',416474);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sacramento','USA','California',407018);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Oakland','USA','California',399484);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mesa','USA','Arizona',396375);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tulsa','USA','Oklahoma',393049);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Omaha','USA','Nebraska',390007);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Minneapolis','USA','Minnesota',382618);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Honolulu','USA','Hawaii',371657);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Miami','USA','Florida',362470);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Colorado Springs','USA','Colorado',360890);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Saint Louis','USA','Missouri',348189);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Wichita','USA','Kansas',344284);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Santa Ana','USA','California',337977);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pittsburgh','USA','Pennsylvania',334563);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Arlington','USA','Texas',332969);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Cincinnati','USA','Ohio',331285);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Anaheim','USA','California',328014);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Toledo','USA','Ohio',313619);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tampa','USA','Florida',303447);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Buffalo','USA','New York',292648);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Saint Paul','USA','Minnesota',287151);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Corpus Christi','USA','Texas',277454);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Aurora','USA','Colorado',276393);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Raleigh','USA','North Carolina',276093);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Newark','USA','New Jersey',273546);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lexington-Fayette','USA','Kentucky',260512);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Anchorage','USA','Alaska',260283);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Louisville','USA','Kentucky',256231);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Riverside','USA','California',255166);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Saint Petersburg','USA','Florida',248232);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bakersfield','USA','California',247057);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Stockton','USA','California',243771);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Birmingham','USA','Alabama',242820);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jersey City','USA','New Jersey',240055);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Norfolk','USA','Virginia',234403);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Baton Rouge','USA','Louisiana',227818);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hialeah','USA','Florida',226419);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lincoln','USA','Nebraska',225581);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Greensboro','USA','North Carolina',223891);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Plano','USA','Texas',222030);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Rochester','USA','New York',219773);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Glendale','USA','Arizona',218812);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Akron','USA','Ohio',217074);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Garland','USA','Texas',215768);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Madison','USA','Wisconsin',208054);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fort Wayne','USA','Indiana',205727);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fremont','USA','California',203413);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Scottsdale','USA','Arizona',202705);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Montgomery','USA','Alabama',201568);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Shreveport','USA','Louisiana',200145);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Augusta-Richmond County','USA','Georgia',199775);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lubbock','USA','Texas',199564);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chesapeake','USA','Virginia',199184);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mobile','USA','Alabama',198915);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Des Moines','USA','Iowa',198682);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Grand Rapids','USA','Michigan',197800);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Richmond','USA','Virginia',197790);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Yonkers','USA','New York',196086);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Spokane','USA','Washington',195629);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Glendale','USA','California',194973);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tacoma','USA','Washington',193556);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Irving','USA','Texas',191615);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Huntington Beach','USA','California',189594);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Modesto','USA','California',188856);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Durham','USA','North Carolina',187035);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Columbus','USA','Georgia',186291);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Orlando','USA','Florida',185951);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Boise City','USA','Idaho',185787);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Winston-Salem','USA','North Carolina',185776);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('San Bernardino','USA','California',185401);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jackson','USA','Mississippi',184256);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Little Rock','USA','Arkansas',183133);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Salt Lake City','USA','Utah',181743);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Reno','USA','Nevada',180480);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Newport News','USA','Virginia',180150);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chandler','USA','Arizona',176581);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Laredo','USA','Texas',176576);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Henderson','USA','Nevada',175381);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Arlington','USA','Virginia',174838);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Knoxville','USA','Tennessee',173890);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Amarillo','USA','Texas',173627);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Providence','USA','Rhode Island',173618);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chula Vista','USA','California',173556);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Worcester','USA','Massachusetts',172648);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Oxnard','USA','California',170358);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Dayton','USA','Ohio',166179);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Garden Grove','USA','California',165196);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Oceanside','USA','California',161029);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tempe','USA','Arizona',158625);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Huntsville','USA','Alabama',158216);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ontario','USA','California',158007);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chattanooga','USA','Tennessee',155554);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fort Lauderdale','USA','Florida',152397);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Springfield','USA','Massachusetts',152082);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Springfield','USA','Missouri',151580);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Santa Clarita','USA','California',151088);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Salinas','USA','California',151060);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Tallahassee','USA','Florida',150624);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Rockford','USA','Illinois',150115);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pomona','USA','California',149473);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Metairie','USA','Louisiana',149428);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Paterson','USA','New Jersey',149222);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Overland Park','USA','Kansas',149080);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Santa Rosa','USA','California',147595);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Syracuse','USA','New York',147306);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kansas City','USA','Kansas',146866);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hampton','USA','Virginia',146437);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lakewood','USA','Colorado',144126);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Vancouver','USA','Washington',143560);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Irvine','USA','California',143072);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Aurora','USA','Illinois',142990);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Moreno Valley','USA','California',142381);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pasadena','USA','California',141674);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hayward','USA','California',140030);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Brownsville','USA','Texas',139722);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bridgeport','USA','Connecticut',139529);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hollywood','USA','Florida',139357);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Warren','USA','Michigan',138247);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Torrance','USA','California',137946);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Eugene','USA','Oregon',137893);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pembroke Pines','USA','Florida',137427);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Salem','USA','Oregon',136924);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pasadena','USA','Texas',133936);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Escondido','USA','California',133559);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sunnyvale','USA','California',131760);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Savannah','USA','Georgia',131510);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fontana','USA','California',128929);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Orange','USA','California',128821);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Naperville','USA','Illinois',128358);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Alexandria','USA','Virginia',128283);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Rancho Cucamonga','USA','California',127743);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Grand Prairie','USA','Texas',127427);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('East Los Angeles','USA','California',126379);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fullerton','USA','California',126003);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Corona','USA','California',124966);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Flint','USA','Michigan',124943);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Paradise','USA','Nevada',124682);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mesquite','USA','Texas',124523);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sterling Heights','USA','Michigan',124471);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sioux Falls','USA','South Dakota',123975);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('New Haven','USA','Connecticut',123626);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Topeka','USA','Kansas',122377);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Concord','USA','California',121780);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Evansville','USA','Indiana',121582);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hartford','USA','Connecticut',121578);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fayetteville','USA','North Carolina',121015);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Cedar Rapids','USA','Iowa',120758);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Elizabeth','USA','New Jersey',120568);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lansing','USA','Michigan',119128);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lancaster','USA','California',118718);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fort Collins','USA','Colorado',118652);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Coral Springs','USA','Florida',117549);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Stamford','USA','Connecticut',117083);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Thousand Oaks','USA','California',117005);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Vallejo','USA','California',116760);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Palmdale','USA','California',116670);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Columbia','USA','South Carolina',116278);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('El Monte','USA','California',115965);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Abilene','USA','Texas',115930);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('North Las Vegas','USA','Nevada',115488);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Ann Arbor','USA','Michigan',114024);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Beaumont','USA','Texas',113866);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Waco','USA','Texas',113726);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Macon','USA','Georgia',113336);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Independence','USA','Missouri',113288);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Peoria','USA','Illinois',112936);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Inglewood','USA','California',112580);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Springfield','USA','Illinois',111454);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Simi Valley','USA','California',111351);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lafayette','USA','Louisiana',110257);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Gilbert','USA','Arizona',109697);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Carrollton','USA','Texas',109576);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bellevue','USA','Washington',109569);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('West Valley City','USA','Utah',108896);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Clarksville','USA','Tennessee',108787);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Costa Mesa','USA','California',108724);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Peoria','USA','Arizona',108364);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('South Bend','USA','Indiana',107789);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Downey','USA','California',107323);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Waterbury','USA','Connecticut',107271);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Manchester','USA','New Hampshire',107006);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Allentown','USA','Pennsylvania',106632);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('McAllen','USA','Texas',106414);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Joliet','USA','Illinois',106221);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Lowell','USA','Massachusetts',105167);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Provo','USA','Utah',105166);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('West Covina','USA','California',105080);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Wichita Falls','USA','Texas',104197);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Erie','USA','Pennsylvania',103717);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Daly City','USA','California',103621);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Citrus Heights','USA','California',103455);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Norwalk','USA','California',103298);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Gary','USA','Indiana',102746);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Berkeley','USA','California',102743);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Santa Clara','USA','California',102361);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Green Bay','USA','Wisconsin',102313);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Cape Coral','USA','Florida',102286);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Arvada','USA','Colorado',102153);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Pueblo','USA','Colorado',102121);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sandy','USA','Utah',101853);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Athens-Clarke County','USA','Georgia',101489);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Cambridge','USA','Massachusetts',101355);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Westminster','USA','Colorado',100940);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('San Buenaventura','USA','California',100916);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Portsmouth','USA','Virginia',100565);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Livonia','USA','Michigan',100545);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Burbank','USA','California',100316);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Clearwater','USA','Florida',99936);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Midland','USA','Texas',98293);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Davenport','USA','Iowa',98256);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mission Viejo','USA','California',98049);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Miami Beach','USA','Florida',97855);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Sunrise Manor','USA','Nevada',95362);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('New Bedford','USA','Massachusetts',94780);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('El Cajon','USA','California',94578);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Norman','USA','Oklahoma',94193);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Richmond','USA','California',94100);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Albany','USA','New York',93994);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Brockton','USA','Massachusetts',93653);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Roanoke','USA','Virginia',93357);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Billings','USA','Montana',92988);
commit;
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Compton','USA','California',92864);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Gainesville','USA','Florida',92291);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fairfield','USA','California',92256);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Arden-Arcade','USA','California',92040);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('San Mateo','USA','California',91799);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Visalia','USA','California',91762);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Boulder','USA','Colorado',91238);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Cary','USA','North Carolina',91213);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Santa Monica','USA','California',91084);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Fall River','USA','Massachusetts',90555);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Kenosha','USA','Wisconsin',89447);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Elgin','USA','Illinois',89408);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Odessa','USA','Texas',89293);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Carson','USA','California',89089);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Charleston','USA','South Carolina',89063);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Charlotte Amalie','VIR','St Thomas',13000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Harare','ZWE','Harare',1410000);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Bulawayo','ZWE','Bulawayo',621742);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Chitungwiza','ZWE','Harare',274912);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mount Darwin','ZWE','Harare',164362);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Mutare','ZWE','Manicaland',131367);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Gweru','ZWE','Midlands',128037);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Gaza','PSE','Gaza',353632);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Khan Yunis','PSE','Khan Yunis',123175);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Hebron','PSE','Hebron',119401);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Jabaliya','PSE','North Gaza',113901);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Nablus','PSE','Nablus',100231);
INSERT INTO CITY (NAME,COUNTRY_CODE,DISTRICT,POPULATION) VALUES('Rafah','PSE','Rafah',92020);

commit;

INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ABW','Dutch','T',5.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ABW','English','F',9.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ABW','Papiamento','F',76.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ABW','Spanish','F',7.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AFG','Balochi','F',0.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AFG','Dari','T',32.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AFG','Pashto','T',52.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AFG','Turkmenian','F',1.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AFG','Uzbek','F',8.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AGO','Ambo','F',2.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AGO','Chokwe','F',4.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AGO','Kongo','F',13.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AGO','Luchazi','F',2.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AGO','Luimbe-nganguela','F',5.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AGO','Luvale','F',3.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AGO','Mbundu','F',21.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AGO','Nyaneka-nkhumbi','F',5.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AGO','Ovimbundu','F',37.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AIA','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ALB','Albaniana','T',97.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ALB','Greek','F',1.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ALB','Macedonian','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AND','Catalan','T',32.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AND','French','F',6.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AND','Portuguese','F',10.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AND','Spanish','F',44.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ANT','Dutch','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ANT','English','F',7.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ANT','Papiamento','T',86.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ARE','Arabic','T',42.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ARE','Hindi','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ARG','Indian Languages','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ARG','Italian','F',1.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ARG','Spanish','T',96.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ARM','Armenian','T',93.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ARM','Azerbaijani','F',2.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ASM','English','T',3.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ASM','Samoan','T',90.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ASM','Tongan','F',3.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ATG','Creole English','F',95.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ATG','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUS','Arabic','F',1.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUS','Canton Chinese','F',1.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUS','English','T',81.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUS','German','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUS','Greek','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUS','Italian','F',2.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUS','Serbo-Croatian','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUS','Vietnamese','F',0.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUT','Czech','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUT','German','T',92.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUT','Hungarian','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUT','Polish','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUT','Romanian','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUT','Serbo-Croatian','F',2.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUT','Slovene','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AUT','Turkish','F',1.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AZE','Armenian','F',2.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AZE','Azerbaijani','T',89.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AZE','Lezgian','F',2.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('AZE','Russian','F',3.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BDI','French','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BDI','Kirundi','T',98.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BDI','Swahili','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEL','Arabic','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEL','Dutch','T',59.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEL','French','T',32.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEL','German','T',1.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEL','Italian','F',2.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEL','Turkish','F',0.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEN','Adja','F',11.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEN','Aizo','F',8.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEN','Bariba','F',8.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEN','Fon','F',39.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEN','Ful','F',5.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEN','Joruba','F',12.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BEN','Somba','F',6.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BFA','Busansi','F',3.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BFA','Dagara','F',3.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BFA','Dyula','F',2.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BFA','Ful','F',9.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BFA','Gurma','F',5.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BFA','Mossi','F',50.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BGD','Bengali','T',97.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BGD','Chakma','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BGD','Garo','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BGD','Khasi','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BGD','Marma','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BGD','Santhali','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BGD','Tripuri','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BGR','Bulgariana','T',83.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BGR','Macedonian','F',2.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BGR','Romani','F',3.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BGR','Turkish','F',9.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BHR','Arabic','T',67.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BHR','English','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BHS','Creole English','F',89.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BHS','Creole French','F',10.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BIH','Serbo-Croatian','T',99.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BLR','Belorussian','T',65.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BLR','Polish','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BLR','Russian','T',32.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BLR','Ukrainian','F',1.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BLZ','English','T',50.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BLZ','Garifuna','F',6.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BLZ','Maya Languages','F',9.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BLZ','Spanish','F',31.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BMU','English','T',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BOL','Aimar','T',3.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BOL','Guaran','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BOL','Ketua','T',8.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BOL','Spanish','T',87.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BRA','German','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BRA','Indian Languages','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BRA','Italian','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BRA','Japanese','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BRA','Portuguese','T',97.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BRB','Bajan','F',95.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BRB','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BRN','Chinese','F',9.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BRN','English','F',3.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BRN','Malay','T',45.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BRN','Malay-English','F',28.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BTN','Asami','F',15.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BTN','Dzongkha','T',50.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BTN','Nepali','F',34.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BWA','Khoekhoe','F',2.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BWA','Ndebele','F',1.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BWA','San','F',3.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BWA','Shona','F',12.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('BWA','Tswana','F',75.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAF','Banda','F',23.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAF','Gbaya','F',23.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAF','Mandjia','F',14.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAF','Mbum','F',6.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAF','Ngbaka','F',7.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAF','Sara','F',6.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAN','Chinese','F',2.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAN','Dutch','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAN','English','T',60.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAN','Eskimo Languages','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAN','French','T',23.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAN','German','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAN','Italian','F',1.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAN','Polish','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAN','Portuguese','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAN','Punjabi','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAN','Spanish','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CAN','Ukrainian','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CCK','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CCK','Malay','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHE','French','T',19.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHE','German','T',63.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHE','Italian','T',7.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHE','Romansh','T',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHL','Aimar','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHL','Araucan','F',9.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHL','Rapa nui','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHL','Spanish','T',89.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHN','Chinese','T',92.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHN','Dong','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHN','Hui','F',0.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHN','Mantu','F',0.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHN','Miao','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHN','Mongolian','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHN','Puyi','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHN','Tibetan','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHN','Tujia','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHN','Uighur','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHN','Yi','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CHN','Zhuang','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CIV','[South]Mande','F',7.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CIV','Akan','F',30.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CIV','Gur','F',11.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CIV','Kru','F',10.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CIV','Malinke','F',11.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CMR','Bamileke-bamum','F',18.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CMR','Duala','F',10.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CMR','Fang','F',19.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CMR','Ful','F',9.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CMR','Maka','F',4.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CMR','Mandara','F',5.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CMR','Masana','F',3.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CMR','Tikar','F',7.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COD','Boa','F',2.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COD','Chokwe','F',1.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COD','Kongo','F',16.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COD','Luba','F',18.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COD','Mongo','F',13.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COD','Ngala and Bangi','F',5.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COD','Rundi','F',3.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COD','Rwanda','F',10.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COD','Teke','F',2.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COD','Zande','F',6.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COG','Kongo','F',51.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COG','Mbete','F',4.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COG','Mboshi','F',11.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COG','Punu','F',2.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COG','Sango','F',2.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COG','Teke','F',17.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COK','English','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COK','Maori','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COL','Arawakan','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COL','Caribbean','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COL','Chibcha','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COL','Creole English','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COL','Spanish','T',99.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COM','Comorian','T',75.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COM','Comorian-Arabic','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COM','Comorian-French','F',12.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COM','Comorian-madagassi','F',5.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('COM','Comorian-Swahili','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CPV','Crioulo','F',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CPV','Portuguese','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CRI','Chibcha','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CRI','Chinese','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CRI','Creole English','F',2.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CRI','Spanish','T',97.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CUB','Spanish','T',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CXR','Chinese','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CXR','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CYM','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CYP','Greek','T',74.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CYP','Turkish','T',22.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CZE','Czech','T',81.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CZE','German','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CZE','Hungarian','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CZE','Moravian','F',12.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CZE','Polish','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CZE','Romani','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CZE','Silesiana','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('CZE','Slovak','F',3.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DEU','German','T',91.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DEU','Greek','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DEU','Italian','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DEU','Polish','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DEU','Southern Slavic Languages','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DEU','Turkish','F',2.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DJI','Afar','F',34.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DJI','Arabic','T',10.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DJI','Somali','F',43.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DMA','Creole English','F',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DMA','Creole French','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DNK','Arabic','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DNK','Danish','T',93.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DNK','English','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DNK','German','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DNK','Norwegian','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DNK','Swedish','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DNK','Turkish','F',0.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DOM','Creole French','F',2.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DOM','Spanish','T',98.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DZA','Arabic','T',86.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('DZA','Berberi','F',14.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ECU','Ketua','F',7.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ECU','Spanish','T',93.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('EGY','Arabic','T',98.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('EGY','Sinaberberi','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ERI','Afar','F',4.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ERI','Bilin','F',3.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ERI','Hadareb','F',3.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ERI','Saho','F',3.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ERI','Tigre','F',31.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ERI','Tigrinja','T',49.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ESH','Arabic','T',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ESP','Basque','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ESP','Catalan','F',16.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ESP','Galecian','F',6.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ESP','Spanish','T',74.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('EST','Belorussian','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('EST','Estonian','T',65.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('EST','Finnish','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('EST','Russian','F',27.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('EST','Ukrainian','F',2.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ETH','Amhara','F',30.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ETH','Gurage','F',4.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ETH','Oromo','F',31.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ETH','Sidamo','F',3.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ETH','Somali','F',4.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ETH','Tigrinja','F',7.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ETH','Walaita','F',2.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FIN','Estonian','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FIN','Finnish','T',92.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FIN','Russian','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FIN','Saame','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FIN','Swedish','T',5.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FJI','Fijian','T',50.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FJI','Hindi','F',43.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FLK','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FRA','Arabic','F',2.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FRA','French','T',93.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FRA','Italian','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FRA','Portuguese','F',1.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FRA','Spanish','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FRA','Turkish','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FRO','Danish','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FRO','Faroese','T',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FSM','Kosrean','F',7.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FSM','Mortlock','F',7.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FSM','Pohnpei','F',23.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FSM','Trukese','F',41.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FSM','Wolea','F',3.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('FSM','Yap','F',5.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GAB','Fang','F',35.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GAB','Mbete','F',13.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GAB','Mpongwe','F',14.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GAB','Punu-sira-nzebi','F',17.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GBR','English','T',97.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GBR','Gaeli','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GBR','Kymri','F',0.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GEO','Abhyasi','F',1.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GEO','Armenian','F',6.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GEO','Azerbaijani','F',5.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GEO','Georgiana','T',71.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GEO','Osseetti','F',2.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GEO','Russian','F',8.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GHA','Akan','F',52.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GHA','Ewe','F',11.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GHA','Ga-adangme','F',7.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GHA','Gurma','F',3.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GHA','Joruba','F',1.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GHA','Mossi','F',15.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GIB','Arabic','F',7.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GIB','English','T',88.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GIN','Ful','F',38.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GIN','Kissi','F',6.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GIN','Kpelle','F',4.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GIN','Loma','F',2.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GIN','Malinke','F',23.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GIN','Susu','F',11.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GIN','Yalunka','F',2.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GLP','Creole French','F',95.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GLP','French','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GMB','Diola','F',9.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GMB','Ful','F',16.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GMB','Malinke','F',34.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GMB','Soninke','F',7.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GMB','Wolof','F',12.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GNB','Balante','F',14.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GNB','Crioulo','F',36.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GNB','Ful','F',16.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GNB','Malinke','F',6.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GNB','Mandyako','F',4.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GNB','Portuguese','T',8.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GNQ','Bubi','F',8.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GNQ','Fang','F',84.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GRC','Greek','T',98.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GRC','Turkish','F',0.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GRD','Creole English','F',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GRL','Danish','T',12.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GRL','Greenlandic','T',87.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GTM','Cakchiquel','F',8.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GTM','Kekch','F',4.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GTM','Mam','F',2.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GTM','Quich','F',10.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GTM','Spanish','T',64.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GUF','Creole French','F',94.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GUF','Indian Languages','F',1.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GUM','Chamorro','T',29.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GUM','English','T',37.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GUM','Japanese','F',2.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GUM','Korean','F',3.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GUM','Philippene Languages','F',19.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GUY','Arawakan','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GUY','Caribbean','F',2.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('GUY','Creole English','F',96.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HKG','Canton Chinese','F',88.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HKG','Chiu chau','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HKG','English','T',2.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HKG','Fukien','F',1.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HKG','Hakka','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HND','Creole English','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HND','Garifuna','F',1.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HND','Miskito','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HND','Spanish','T',97.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HRV','Serbo-Croatian','T',95.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HRV','Slovene','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HTI','French','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HTI','Haiti Creole','F',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HUN','German','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HUN','Hungarian','T',98.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HUN','Romani','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HUN','Romanian','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HUN','Serbo-Croatian','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('HUN','Slovak','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IDN','Bali','F',1.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IDN','Banja','F',1.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IDN','Batakki','F',2.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IDN','Bugi','F',2.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IDN','Javanese','F',39.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IDN','Madura','F',4.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IDN','Malay','T',12.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IDN','Minangkabau','F',2.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IDN','Sunda','F',15.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IND','Asami','F',1.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IND','Bengali','F',8.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IND','Gujarati','F',4.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IND','Hindi','T',39.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IND','Kannada','F',3.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IND','Malajalam','F',3.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IND','Marathi','F',7.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IND','Orija','F',3.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IND','Punjabi','F',2.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IND','Tamil','F',6.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IND','Telugu','F',7.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IND','Urdu','F',5.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRL','English','T',98.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRL','Irish','T',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRN','Arabic','F',2.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRN','Azerbaijani','F',16.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRN','Bakhtyari','F',1.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRN','Balochi','F',2.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRN','Gilaki','F',5.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRN','Kurdish','F',9.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRN','Luri','F',4.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRN','Mazandarani','F',3.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRN','Persian','T',45.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRN','Turkmenian','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRQ','Arabic','T',77.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRQ','Assyrian','F',0.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRQ','Azerbaijani','F',1.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRQ','Kurdish','F',19.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('IRQ','Persian','F',0.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ISL','English','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ISL','Icelandic','T',95.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ISR','Arabic','T',18.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ISR','Hebrew','T',63.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ISR','Russian','F',8.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ITA','Albaniana','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ITA','French','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ITA','Friuli','F',1.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ITA','German','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ITA','Italian','T',94.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ITA','Romani','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ITA','Sardinian','F',2.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ITA','Slovene','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('JAM','Creole English','F',94.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('JAM','Hindi','F',1.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('JOR','Arabic','T',97.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('JOR','Armenian','F',1.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('JOR','Circassian','F',1.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('JPN','Ainu','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('JPN','Chinese','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('JPN','English','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('JPN','Japanese','T',99.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('JPN','Korean','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('JPN','Philippene Languages','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KAZ','German','F',3.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KAZ','Kazakh','T',46.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KAZ','Russian','F',34.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KAZ','Tatar','F',2.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KAZ','Ukrainian','F',5.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KAZ','Uzbek','F',2.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KEN','Gusii','F',6.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KEN','Kalenjin','F',10.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KEN','Kamba','F',11.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KEN','Kikuyu','F',20.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KEN','Luhya','F',13.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KEN','Luo','F',12.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KEN','Masai','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KEN','Meru','F',5.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KEN','Nyika','F',4.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KEN','Turkana','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KGZ','Kazakh','F',0.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KGZ','Kirgiz','T',59.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KGZ','Russian','T',16.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KGZ','Tadzhik','F',0.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KGZ','Tatar','F',1.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KGZ','Ukrainian','F',1.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KGZ','Uzbek','F',14.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KHM','Chinese','F',3.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KHM','Khmer','T',88.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KHM','Tam','F',2.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KHM','Vietnamese','F',5.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KIR','Kiribati','T',98.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KIR','Tuvalu','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KNA','Creole English','F',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KNA','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KOR','Chinese','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KOR','Korean','T',99.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KWT','Arabic','T',78.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('KWT','English','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LAO','Lao','T',67.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LAO','Lao-Soung','F',5.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LAO','Mon-khmer','F',16.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LAO','Thai','F',7.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBN','Arabic','T',93.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBN','Armenian','F',5.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBN','French','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBR','Bassa','F',13.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBR','Gio','F',7.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBR','Grebo','F',8.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBR','Kpelle','F',19.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBR','Kru','F',7.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBR','Loma','F',5.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBR','Malinke','F',5.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBR','Mano','F',7.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBY','Arabic','T',96.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LBY','Berberi','F',1.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LCA','Creole French','F',80.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LCA','English','T',20.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LIE','German','T',89.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LIE','Italian','F',2.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LIE','Turkish','F',2.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LKA','Mixed Languages','F',19.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LKA','Singali','T',60.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LKA','Tamil','T',19.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LSO','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LSO','Sotho','T',85.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LSO','Zulu','F',15.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LTU','Belorussian','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LTU','Lithuanian','T',81.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LTU','Polish','F',7.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LTU','Russian','F',8.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LTU','Ukrainian','F',1.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LUX','French','T',4.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LUX','German','T',2.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LUX','Italian','F',4.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LUX','Luxembourgish','T',64.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LUX','Portuguese','F',13.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LVA','Belorussian','F',4.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LVA','Latvian','T',55.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LVA','Lithuanian','F',1.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LVA','Polish','F',2.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LVA','Russian','F',32.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('LVA','Ukrainian','F',2.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MAC','Canton Chinese','F',85.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MAC','English','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MAC','Mandarin Chinese','F',1.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MAC','Portuguese','T',2.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MAR','Arabic','T',65.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MAR','Berberi','F',33.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MCO','English','F',6.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MCO','French','T',41.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MCO','Italian','F',16.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MCO','Monegasque','F',16.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MDA','Bulgariana','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MDA','Gagauzi','F',3.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MDA','Romanian','T',61.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MDA','Russian','F',23.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MDA','Ukrainian','F',8.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MDG','French','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MDG','Malagasy','T',98.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MDV','Dhivehi','T',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MDV','English','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MEX','Mixtec','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MEX','Nhuatl','F',1.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MEX','Otom','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MEX','Spanish','T',92.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MEX','Yucatec','F',1.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MEX','Zapotec','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MHL','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MHL','Marshallese','T',96.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MKD','Albaniana','F',22.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MKD','Macedonian','T',66.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MKD','Romani','F',2.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MKD','Serbo-Croatian','F',2.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MKD','Turkish','F',4.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MLI','Bambara','F',31.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MLI','Ful','F',13.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MLI','Senufo and Minianka','F',12.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MLI','Songhai','F',6.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MLI','Soninke','F',8.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MLI','Tamashek','F',7.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MLT','English','T',2.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MLT','Maltese','T',95.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MMR','Burmese','T',69.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MMR','Chin','F',2.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MMR','Kachin','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MMR','Karen','F',6.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MMR','Kayah','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MMR','Mon','F',2.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MMR','Rakhine','F',4.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MMR','Shan','F',8.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MNG','Bajad','F',1.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MNG','Buryat','F',1.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MNG','Dariganga','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MNG','Dorbet','F',2.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MNG','Kazakh','F',5.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MNG','Mongolian','T',78.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MNP','Carolinian','F',4.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MNP','Chamorro','F',30.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MNP','Chinese','F',7.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MNP','English','T',4.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MNP','Korean','F',6.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MNP','Philippene Languages','F',34.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MOZ','Chuabo','F',5.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MOZ','Lomwe','F',7.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MOZ','Makua','F',27.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MOZ','Marendje','F',3.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MOZ','Nyanja','F',3.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MOZ','Ronga','F',3.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MOZ','Sena','F',9.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MOZ','Shona','F',6.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MOZ','Tsonga','F',12.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MOZ','Tswa','F',6.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MRT','Ful','F',1.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MRT','Hassaniya','F',81.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MRT','Soninke','F',2.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MRT','Tukulor','F',5.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MRT','Wolof','F',6.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MRT','Zenaga','F',1.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MSR','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MTQ','Creole French','F',96.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MTQ','French','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MUS','Bhojpuri','F',21.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MUS','Creole French','F',70.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MUS','French','F',3.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MUS','Hindi','F',1.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MUS','Marathi','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MUS','Tamil','F',0.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MWI','Chichewa','T',58.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MWI','Lomwe','F',18.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MWI','Ngoni','F',6.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MWI','Yao','F',13.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MYS','Chinese','F',9.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MYS','Dusun','F',1.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MYS','English','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MYS','Iban','F',2.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MYS','Malay','T',58.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MYS','Tamil','F',3.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MYT','French','T',20.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MYT','Mahor','F',41.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('MYT','Malagasy','F',16.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NAM','Afrikaans','F',9.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NAM','Caprivi','F',4.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NAM','German','F',0.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NAM','Herero','F',8.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NAM','Kavango','F',9.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NAM','Nama','F',12.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NAM','Ovambo','F',50.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NAM','San','F',1.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NCL','French','T',34.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NCL','Malenasian Languages','F',45.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NCL','Polynesian Languages','F',11.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NER','Ful','F',9.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NER','Hausa','F',53.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NER','Kanuri','F',4.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NER','Songhai-zerma','F',21.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NER','Tamashek','F',10.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NFK','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NGA','Bura','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NGA','Edo','F',3.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NGA','Ful','F',11.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NGA','Hausa','F',21.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NGA','Ibibio','F',5.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NGA','Ibo','F',18.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NGA','Ijo','F',1.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NGA','Joruba','F',21.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NGA','Kanuri','F',4.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NGA','Tiv','F',2.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NIC','Creole English','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NIC','Miskito','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NIC','Spanish','T',97.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NIC','Sumo','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NIU','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NIU','Niue','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NLD','Arabic','F',0.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NLD','Dutch','T',95.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NLD','Fries','F',3.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NLD','Turkish','F',0.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NOR','Danish','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NOR','English','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NOR','Norwegian','T',96.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NOR','Saame','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NOR','Swedish','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NPL','Bhojpuri','F',7.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NPL','Hindi','F',3.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NPL','Maithili','F',11.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NPL','Nepali','T',50.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NPL','Newari','F',3.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NPL','Tamang','F',4.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NPL','Tharu','F',5.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NRU','Chinese','F',8.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NRU','English','T',7.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NRU','Kiribati','F',17.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NRU','Nauru','T',57.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NRU','Tuvalu','F',8.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NZL','English','T',87.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('NZL','Maori','F',4.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('OMN','Arabic','T',76.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('OMN','Balochi','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAK','Balochi','F',3.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAK','Brahui','F',1.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAK','Hindko','F',2.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAK','Pashto','F',13.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAK','Punjabi','F',48.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAK','Saraiki','F',9.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAK','Sindhi','F',11.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAK','Urdu','T',7.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAN','Arabic','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAN','Creole English','F',14.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAN','Cuna','F',2.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAN','Embera','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAN','Guaym','F',5.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PAN','Spanish','T',76.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PCN','Pitcairnese','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PER','Aimar','T',2.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PER','Ketua','T',16.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PER','Spanish','T',79.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PHL','Bicol','F',5.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PHL','Cebuano','F',23.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PHL','Hiligaynon','F',9.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PHL','Ilocano','F',9.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PHL','Maguindanao','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PHL','Maranao','F',1.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PHL','Pampango','F',3.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PHL','Pangasinan','F',1.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PHL','Pilipino','T',29.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PHL','Waray-waray','F',3.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PLW','Chinese','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PLW','English','T',3.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PLW','Palau','T',82.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PLW','Philippene Languages','F',9.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PNG','Malenasian Languages','F',20.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PNG','Papuan Languages','F',78.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('POL','Belorussian','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('POL','German','F',1.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('POL','Polish','T',97.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('POL','Ukrainian','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PRI','English','F',47.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PRI','Spanish','T',51.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PRK','Chinese','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PRK','Korean','T',99.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PRT','Portuguese','T',99.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PRY','German','F',0.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PRY','Guaran','T',40.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PRY','Portuguese','F',3.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PRY','Spanish','T',55.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PSE','Arabic','F',95.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PSE','Hebrew','F',4.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PYF','Chinese','F',2.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PYF','French','T',40.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('PYF','Tahitian','F',46.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('QAT','Arabic','T',40.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('QAT','Urdu','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('REU','Chinese','F',2.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('REU','Comorian','F',2.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('REU','Creole French','F',91.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('REU','Malagasy','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('REU','Tamil','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ROM','German','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ROM','Hungarian','F',7.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ROM','Romani','T',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ROM','Romanian','T',90.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ROM','Serbo-Croatian','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ROM','Ukrainian','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RUS','Avarian','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RUS','Bashkir','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RUS','Belorussian','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RUS','Chechen','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RUS','Chuvash','F',0.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RUS','Kazakh','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RUS','Mari','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RUS','Mordva','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RUS','Russian','T',86.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RUS','Tatar','F',3.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RUS','Udmur','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RUS','Ukrainian','F',1.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RWA','French','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('RWA','Rwanda','T',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SAU','Arabic','T',95.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SDN','Arabic','T',49.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SDN','Bari','F',2.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SDN','Beja','F',6.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SDN','Chilluk','F',1.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SDN','Dinka','F',11.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SDN','Fur','F',2.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SDN','Lotuko','F',1.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SDN','Nubian Languages','F',8.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SDN','Nuer','F',4.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SDN','Zande','F',2.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SEN','Diola','F',5.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SEN','Ful','F',21.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SEN','Malinke','F',3.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SEN','Serer','F',12.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SEN','Soninke','F',1.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SEN','Wolof','T',48.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SGP','Chinese','T',77.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SGP','Malay','T',14.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SGP','Tamil','T',7.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SHN','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SJM','Norwegian','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SJM','Russian','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLB','Malenasian Languages','F',85.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLB','Papuan Languages','F',8.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLB','Polynesian Languages','F',3.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLE','Bullom-sherbro','F',3.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLE','Ful','F',3.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLE','Kono-vai','F',5.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLE','Kuranko','F',3.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLE','Limba','F',8.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLE','Mende','F',34.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLE','Temne','F',31.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLE','Yalunka','F',3.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLV','Nahua','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SLV','Spanish','T',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SMR','Italian','T',100.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SOM','Arabic','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SOM','Somali','T',98.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SPM','French','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('STP','Crioulo','F',86.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('STP','French','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SUR','Hindi','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SUR','Sranantonga','F',81.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SVK','Czech and Moravian','F',1.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SVK','Hungarian','F',10.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SVK','Romani','F',1.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SVK','Slovak','T',85.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SVK','Ukrainian and Russian','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SVN','Hungarian','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SVN','Serbo-Croatian','F',7.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SVN','Slovene','T',87.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SWE','Arabic','F',0.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SWE','Finnish','F',2.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SWE','Norwegian','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SWE','Southern Slavic Languages','F',1.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SWE','Spanish','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SWE','Swedish','T',89.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SWZ','Swazi','T',89.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SWZ','Zulu','F',2.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SYC','English','T',3.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SYC','French','T',1.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SYC','Seselwa','F',91.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SYR','Arabic','T',90.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('SYR','Kurdish','F',9.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TCA','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TCD','Arabic','T',12.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TCD','Gorane','F',6.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TCD','Hadjarai','F',6.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TCD','Kanem-bornu','F',9.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TCD','Mayo-kebbi','F',11.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TCD','Ouaddai','F',8.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TCD','Sara','F',27.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TCD','Tandjile','F',6.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TGO','Ane','F',5.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TGO','Ewe','T',23.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TGO','Gurma','F',3.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TGO','Kaby','T',13.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TGO','Kotokoli','F',5.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TGO','Moba','F',5.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TGO','Naudemba','F',4.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TGO','Watyi','F',10.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('THA','Chinese','F',12.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('THA','Khmer','F',1.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('THA','Kuy','F',1.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('THA','Lao','F',26.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('THA','Malay','F',3.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('THA','Thai','T',52.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TJK','Russian','F',9.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TJK','Tadzhik','T',62.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TJK','Uzbek','F',23.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TKL','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TKL','Tokelau','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TKM','Kazakh','F',2.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TKM','Russian','F',6.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TKM','Turkmenian','T',76.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TKM','Uzbek','F',9.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TMP','Portuguese','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TMP','Sunda','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TON','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TON','Tongan','T',98.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TTO','Creole English','F',2.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TTO','English','F',93.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TTO','Hindi','F',3.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TUN','Arabic','T',69.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TUN','Arabic-French','F',26.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TUN','Arabic-French-English','F',3.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TUR','Arabic','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TUR','Kurdish','F',10.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TUR','Turkish','T',87.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TUV','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TUV','Kiribati','F',7.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TUV','Tuvalu','T',92.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TWN','Ami','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TWN','Atayal','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TWN','Hakka','F',11.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TWN','Mandarin Chinese','T',20.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TWN','Min','F',66.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TWN','Paiwan','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TZA','Chaga and Pare','F',4.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TZA','Gogo','F',3.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TZA','Ha','F',3.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TZA','Haya','F',5.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TZA','Hehet','F',6.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TZA','Luguru','F',4.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TZA','Makonde','F',5.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TZA','Nyakusa','F',5.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TZA','Nyamwesi','F',21.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TZA','Shambala','F',4.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('TZA','Swahili','T',8.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UGA','Acholi','F',4.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UGA','Ganda','F',18.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UGA','Gisu','F',4.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UGA','Kiga','F',8.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UGA','Lango','F',5.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UGA','Lugbara','F',4.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UGA','Nkole','F',10.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UGA','Rwanda','F',3.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UGA','Soga','F',8.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UGA','Teso','F',6.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UKR','Belorussian','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UKR','Bulgariana','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UKR','Hungarian','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UKR','Polish','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UKR','Romanian','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UKR','Russian','F',32.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UKR','Ukrainian','T',64.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UMI','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('URY','Spanish','T',95.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('USA','Chinese','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('USA','English','T',86.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('USA','French','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('USA','German','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('USA','Italian','F',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('USA','Japanese','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('USA','Korean','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('USA','Polish','F',0.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('USA','Portuguese','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('USA','Spanish','F',7.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('USA','Tagalog','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('USA','Vietnamese','F',0.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UZB','Karakalpak','F',2.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UZB','Kazakh','F',3.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UZB','Russian','F',10.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UZB','Tadzhik','F',4.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UZB','Tatar','F',1.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('UZB','Uzbek','T',72.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VAT','Italian','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VCT','Creole English','F',99.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VCT','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VEN','Goajiro','F',0.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VEN','Spanish','T',96.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VEN','Warrau','F',0.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VGB','English','T',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VIR','English','T',81.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VIR','French','F',2.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VIR','Spanish','F',13.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VNM','Chinese','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VNM','Khmer','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VNM','Man','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VNM','Miao','F',0.9);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VNM','Muong','F',1.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VNM','Nung','F',1.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VNM','Thai','F',1.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VNM','Tho','F',1.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VNM','Vietnamese','T',86.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VUT','Bislama','T',56.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VUT','English','T',28.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('VUT','French','T',14.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('WLF','Futuna','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('WLF','Wallis','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('WSM','English','T',0.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('WSM','Samoan','T',47.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('WSM','Samoan-English','F',52.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('YEM','Arabic','T',99.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('YEM','Soqutri','F',0.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('YUG','Albaniana','F',16.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('YUG','Hungarian','F',3.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('YUG','Macedonian','F',0.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('YUG','Romani','F',1.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('YUG','Serbo-Croatian','T',75.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('YUG','Slovak','F',0.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZAF','Afrikaans','T',14.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZAF','English','T',8.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZAF','Ndebele','F',1.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZAF','Northsotho','F',9.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZAF','Southsotho','F',7.6);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZAF','Swazi','F',2.5);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZAF','Tsonga','F',4.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZAF','Tswana','F',8.1);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZAF','Venda','F',2.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZAF','Xhosa','T',17.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZAF','Zulu','T',22.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZMB','Bemba','F',29.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZMB','Chewa','F',5.7);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZMB','Lozi','F',6.4);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZMB','Nsenga','F',4.3);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZMB','Nyanja','F',7.8);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZMB','Tongan','F',11.0);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZWE','English','T',2.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZWE','Ndebele','F',16.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZWE','Nyanja','F',2.2);
INSERT INTO COUNTRY_LANGUAGE (Country_Code, Language_Name, Is_Official, Percentage) VALUES ('ZWE','Shona','F',72.1);

commit;

INSERT INTO ORGANIZATION VALUES ('UN', 'United Nations', 1945);
INSERT INTO ORGANIZATION VALUES ('EU', 'European Union', 1993);
INSERT INTO ORGANIZATION VALUES ('AU', 'African Union', 2002);
INSERT INTO ORGANIZATION VALUES ('AL', 'Arab League', 1945);
INSERT INTO ORGANIZATION VALUES ('ASEAN', 'Association of Southeast Asian Nations', 1967);
INSERT INTO ORGANIZATION VALUES ('NATO', 'North Atlantic Treaty Organization', 1949);
INSERT INTO ORGANIZATION VALUES ('WTO', 'World Trade Organization', 1995);
INSERT INTO ORGANIZATION VALUES ('G20', 'Group of Twenty', 1999);
INSERT INTO ORGANIZATION VALUES ('OAS', 'Organization of American States', 1949);
INSERT INTO ORGANIZATION VALUES ('CON', 'Commonwealth of Nations', 1931);

commit;

INSERT INTO COUNTRY_ORGANIZATION VALUES ('AFG', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ALB', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DZA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('AND', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('AGO', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ATG', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ARG', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ARM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('AUS', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('AUT', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('AZE', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BHS', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BHR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BGD', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BRB', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BLR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BEL', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BLZ', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BEN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BTN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BOL', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BIH', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BWA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BRA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BRN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BGR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BFA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MMR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BDI', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KHM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CMR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CAN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CPV', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CAF', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TCD', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CHL', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CHN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('COL', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('COM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('COD', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('COG', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CRI', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CIV', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HRV', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CUB', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CYP', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CZE', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DNK', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DJI', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DMA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DOM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TMP', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ECU', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('EGY', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SLV', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GNQ', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ERI', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('EST', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ETH', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('FJI', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('FIN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('FRA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GAB', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GMB', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GEO', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DEU', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GHA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GRC', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GRD', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GTM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GIN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GNB', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GUY', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HTI', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HND', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HUN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ISL', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IND', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IDN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IRN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IRQ', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IRL', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ISR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ITA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('JAM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('JPN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('JOR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KAZ', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KEN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KIR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PRK', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KOR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KWT', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KGZ', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LAO', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LVA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LBN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LSO', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LBR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LBY', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LIE', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LTU', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LUX', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MKD', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MDG', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MWI', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MYS', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MDV', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MLI', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MLT', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MHL', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MRT', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MUS', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MEX', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('FSM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MDA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MCO', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MNG', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MAR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MOZ', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NAM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NRU', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NPL', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NLD', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NZL', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NIC', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NER', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NGA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NOR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('OMN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PAK', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PLW', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PAN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PNG', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PRY', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PER', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PHL', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('POL', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PRT', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('QAT', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ROM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('RUS', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('RWA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KNA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LCA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('VCT', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('WSM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SMR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('STP', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SAU', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SEN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SYC', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SLE', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SGP', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SVK', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SVN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SLB', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SOM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ZAF', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ESP', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LKA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SDN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SUR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SWZ', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SWE', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CHE', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SYR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TJK', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TZA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('THA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TGO', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TON', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TTO', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TUN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TUR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TKM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TUV', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('UGA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('UKR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ARE', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GBR', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('USA', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('URY', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('UZB', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('VUT', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('VEN', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('VNM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('YEM', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ZMB', 'UN');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ZWE', 'UN');

commit;

INSERT INTO COUNTRY_ORGANIZATION VALUES ('AUT', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BEL', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BGR', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CYP', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CZE', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DEU', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DNK', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ESP', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('EST', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('FIN', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('FRA', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GRC', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HRV', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IRL', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ITA', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LTU', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LUX', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LVA', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MLT', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NLD', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('POL', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PRT', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ROM', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SVK', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SVN', 'EU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SWE', 'EU');

commit;

INSERT INTO COUNTRY_ORGANIZATION VALUES ('AGO', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BDI', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BEN', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BFA', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BWA', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CAF', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CIV', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CMR', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('COD', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('COG', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('COM', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CPV', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DJI', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DZA', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('EGY', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ERI', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ETH', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GAB', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GHA', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GIN', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GMB', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GNB', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GNQ', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KEN', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LBR', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LBY', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LSO', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MAR', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MDG', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MLI', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MOZ', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MRT', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MUS', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MWI', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NAM', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NER', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NGA', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('RWA', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SDN', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SEN', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SLE', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SOM', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('STP', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SWZ', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SYC', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TCD', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TGO', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TUN', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TZA', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('UGA', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ZAF', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ZMB', 'AU');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ZWE', 'AU');

commit;

INSERT INTO COUNTRY_ORGANIZATION VALUES ('ARE', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BHR', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('COM', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DJI', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DZA', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('EGY', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IRQ', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('JOR', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KWT', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LBN', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LBY', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MAR', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MRT', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('OMN', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PSE', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('QAT', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SAU', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SDN', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SOM', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SYR', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TUN', 'AL');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('YEM', 'AL');

commit;

 INSERT INTO COUNTRY_ORGANIZATION VALUES ('BRN', 'ASEAN');
 INSERT INTO COUNTRY_ORGANIZATION VALUES ('IDN', 'ASEAN');
 INSERT INTO COUNTRY_ORGANIZATION VALUES ('KHM', 'ASEAN');
 INSERT INTO COUNTRY_ORGANIZATION VALUES ('LAO', 'ASEAN');
 INSERT INTO COUNTRY_ORGANIZATION VALUES ('MMR', 'ASEAN');
 INSERT INTO COUNTRY_ORGANIZATION VALUES ('MYS', 'ASEAN');
 INSERT INTO COUNTRY_ORGANIZATION VALUES ('PHL', 'ASEAN');
 INSERT INTO COUNTRY_ORGANIZATION VALUES ('SGP', 'ASEAN');
 INSERT INTO COUNTRY_ORGANIZATION VALUES ('THA', 'ASEAN');
 INSERT INTO COUNTRY_ORGANIZATION VALUES ('TMP', 'ASEAN');
 INSERT INTO COUNTRY_ORGANIZATION VALUES ('VNM', 'ASEAN');
 
 commit;

INSERT INTO COUNTRY_ORGANIZATION VALUES ('ALB', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BEL', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BGR', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CAN', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CZE', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DEU', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ESP', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('EST', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('FRA', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GBR', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GRC', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HRV', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HUN', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ISL', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ITA', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LTU', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LUX', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LVA', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MKD', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NLD', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NOR', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('POL', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PRT', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ROM', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SVK', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SVN', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TUR', 'NATO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('USA', 'NATO');

commit;

INSERT INTO COUNTRY_ORGANIZATION VALUES ('ARE', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('AFG', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('AGO', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('AIA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ALB', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ARG', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ARM', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('AUS', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('AUT', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BDI', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BEL', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BFA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BGD', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BGR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BHR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BLZ', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BOL', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BRA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BRB', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BRN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BWA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BEN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CAF', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CAN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CHE', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CHL', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CHN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CIV', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CMR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('COD', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('COG', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('COL', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CPV', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CRI', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CUB', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CYP', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CZE', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DEU', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DJI', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DMA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DNK', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DOM', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ECU', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('EGY', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ESP', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('EST', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('FIN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('FJI', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('FRA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GAB', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GEO', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GHA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GIN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GMB', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GBR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GRC', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GRD', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GTM', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GUY', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HKG', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HND', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HRV', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HTI', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HUN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IDN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IND', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IRL', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ISL', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ISR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ITA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('JAM', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('JOR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('JPN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KAZ', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KEN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KGZ', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KHM', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KNA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KOR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KWT', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LAO', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LBR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LCA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LUX', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LIE', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LKA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LSO', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LTU', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LVA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MAC', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MAR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MDA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MDG', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MDV', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MEX', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MKD', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MLI', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MLT', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MMR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MNG', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MOZ', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MRT', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MUS', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MWI', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MYS', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NAM', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NLD', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NER', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NGA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NIC', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NOR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NPL', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NZL', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('OMN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PAK', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PAN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PER', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PHL', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PNG', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('POL', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PRT', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PRY', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('QAT', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ROM', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('RUS', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('RWA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SAU', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SLE', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SEN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SGP', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SLB', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SLV', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SOM', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SUR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SVK', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SVN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SWE', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SWZ', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SYC', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TCD', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TGO', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('THA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TJK', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TON', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TTO', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TUN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TUR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TWN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TZA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('UGA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('UKR', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('URY', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('USA', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('VCT', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('VEN', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('VNM', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('VUT', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('YEM', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ZAF', 'WTO');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ZMB', 'WTO');INSERT INTO COUNTRY_ORGANIZATION VALUES ('ATG', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ARG', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BHS', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BRB', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BLZ', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BOL', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BRA', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CAN', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CHL', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('COL', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CRI', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CUB', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DMA', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DOM', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ECU', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SLV', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GRD', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GTM', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GUY', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HTI', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('HND', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('JAM', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MEX', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NIC', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PAN', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PRY', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PER', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KNA', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LCA', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('VCT', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SUR', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TTO', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('USA', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('URY', 'OAS');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('VEN', 'OAS');

commit;

INSERT INTO COUNTRY_ORGANIZATION VALUES ('ATG', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('AUS', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BHS', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BGD', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BRB', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BLZ', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BRN', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CMR', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CAN', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CYP', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DMA', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('FJI', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GMB', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GHA', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GRD', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GUY', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IND', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('JAM', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KEN', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SWZ', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KIR', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LSO', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MWI', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MYS', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MDV', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MLT', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MUS', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MOZ', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NAM', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NRU', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NZL', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('NGA', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PAK', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('PNG', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('RWA', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LCA', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('WSM', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SYC', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SLE', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SGP', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SLB', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ZAF', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('LKA', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KNA', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('VCT', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TON', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TTO', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TUV', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('UGA', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GBR', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TZA', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('VUT', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ZMB', 'CON');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BWA', 'CON');

commit;



INSERT INTO COUNTRY_ORGANIZATION VALUES ('ZWE', 'WTO');

commit;

INSERT INTO COUNTRY_ORGANIZATION VALUES ('ARG', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('AUS', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('BRA', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CAN', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('CHN', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('FRA', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('DEU', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IND', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('IDN', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ITA', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('JPN', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('KOR', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('MEX', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('RUS', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('SAU', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('ZAF', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('TUR', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('GBR', 'G20');
INSERT INTO COUNTRY_ORGANIZATION VALUES ('USA', 'G20');

commit;


ALTER TABLE COUNTRY_ORGANIZATION ADD CONSTRAINT FK_COUNTRY_ORGANIZATION_COUNTRY FOREIGN KEY (COUNTRY_CODE) REFERENCES COUNTRY(CODE);
ALTER TABLE COUNTRY_ORGANIZATION ADD CONSTRAINT FK_COUNTRY_ORGANIZATION_ORGANIZATION FOREIGN KEY (ORGANIZATION_CODE) REFERENCES ORGANIZATION(CODE);

ALTER TABLE COUNTRY ADD CONSTRAINT FK_COUNTRY_CONTINENT FOREIGN KEY (CONTINENT) REFERENCES CONTINENT(NAME);
ALTER TABLE COUNTRY ADD CONSTRAINT FK_COUNTRY_CITY FOREIGN KEY (CAPITAL) REFERENCES CITY(ID);

ALTER TABLE CITY ADD CONSTRAINT FK_CITY_COUNTRY FOREIGN KEY (COUNTRY_CODE) REFERENCES COUNTRY(CODE);


ALTER TABLE COUNTRY_LANGUAGE ADD CONSTRAINT FK_COUNTRY_LANGUAGE_COUNTY FOREIGN KEY (COUNTRY_CODE) REFERENCES COUNTRY(CODE);

commit;





