PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "city" (
"ID" INT,
"Name" CHAR(35),
"CountryCode" CHAR(3),
PRIMARY KEY ("ID"),
FOREIGN KEY ("CountryCode") REFERENCES "country"("Code")
);

CREATE TABLE "country" (
"Code" CHAR(3) UNIQUE,
"Name" CHAR(52),
"Continent" TEXT,
"Population" INT,
PRIMARY KEY ("Code")
);

CREATE TABLE "countrylanguage" (
"CountryCode" CHAR(3),
"Language" CHAR(30),
PRIMARY KEY ("CountryCode", "Language")
);





INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "22720000");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "Europe", "15988000");
INSERT INTO "country" VALUES ("USA", "United States", "North America", "278357000");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "1277558000");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "1013662000");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "126714000");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "68470000");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Africa", "111506000");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "40377000");
INSERT INTO "country" VALUES ("DZA", "Algeria", "Africa", "31471000");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "Africa", "62565000");
INSERT INTO "country" VALUES ("KEN", "Kenya", "Africa", "30080000");
INSERT INTO "country" VALUES ("SDN", "Sudan", "Africa", "30921000");
INSERT INTO "country" VALUES ("COD", "Congo, The Democratic Republic of the", "Africa", "50416000");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "Asia", "212107000");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "Asia", "156483000");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "129155000");
INSERT INTO "country" VALUES ("RUS", "Russian Federation", "Europe", "146934000");
INSERT INTO "country" VALUES ("BRA", "Brazil", "South America", "170115000");
INSERT INTO "country" VALUES ("DEU", "Germany", "Europe", "82164000");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "Europe", "59623000");
INSERT INTO "country" VALUES ("FRA", "France", "Europe", "59225000");
INSERT INTO "country" VALUES ("ITA", "Italy", "Europe", "57680000");
INSERT INTO "country" VALUES ("MEX", "Mexico", "North America", "98881000");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "31147000");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "18886000");
INSERT INTO "country" VALUES ("ARG", "Argentina", "South America", "37032000");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Asia", "46844000");
INSERT INTO "country" VALUES ("PRK", "North Korea", "Asia", "23370000");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "Asia", "79832000");
INSERT INTO "country" VALUES ("PHL", "Philippines", "Asia", "77621000");
INSERT INTO "country" VALUES ("THA", "Thailand", "Asia", "61399000");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "Asia", "45611000");
INSERT INTO "country" VALUES ("IRN", "Iran", "Asia", "67151000");
INSERT INTO "country" VALUES ("TUR", "Turkey", "Asia", "66591000");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "Asia", "21607000");
INSERT INTO "country" VALUES ("ISR", "Israel", "Asia", "6217000");
INSERT INTO "country" VALUES ("SYR", "Syria", "Asia", "16125000");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "Asia", "23109000");
INSERT INTO "country" VALUES ("YEM", "Yemen", "Asia", "18112000");
INSERT INTO "country" VALUES ("OMN", "Oman", "Asia", "2441000");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "Asia", "2441000");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Asia", "769000");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "Asia", "1972000");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "Asia", "617000");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "Asia", "3286000");
INSERT INTO "country" VALUES ("JOR", "Jordan", "Asia", "4860000");
INSERT INTO "country" VALUES ("PSE", "Palestine", "Asia", "3101000");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "Asia", "759000");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Asia", "4968000");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Asia", "3520000");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "Asia", "7734000");
INSERT INTO "country" VALUES ("KAZ", "Kazakhstan", "Asia", "16223000");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "24318000");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "Asia", "4518000");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "Asia", "4709000");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "Asia", "6188000");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "Asia", "22244000");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Asia", "3567000");
INSERT INTO "country" VALUES ("BRN", "Brunei", "Asia", "336000");
INSERT INTO "country" VALUES ("TLS", "East Timor", "Asia", "885000");
INSERT INTO "country" VALUES ("LAO", "Laos", "Asia", "5433000");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "Asia", "11168000");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "Asia", "2654000");
INSERT INTO "country" VALUES ("NPL", "Nepal", "Asia", "23940000");
INSERT INTO "country" VALUES ("BTN", "Bhutan", "Asia", "2120000");
INSERT INTO "country" VALUES ("LKA", "Sri Lanka", "Asia", "18827000");
INSERT INTO "country" VALUES ("MDV", "Maldives", "Asia", "307000");
INSERT INTO "country" VALUES ("AFG2", "Afghanistan2", "Asia", "22720000");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "Africa", "12000000");
INSERT INTO "country" VALUES ("UGA", "Uganda", "Africa", "24000000");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "Africa", "18000000");
INSERT INTO "country" VALUES ("GHA", "Ghana", "Africa", "20000000");
INSERT INTO "country" VALUES ("CIV", "Cote dIvoire", "Africa", "16000000");
INSERT INTO "country" VALUES ("CMR", "Cameroon", "Africa", "15000000");
INSERT INTO "country" VALUES ("AGO", "Angola", "Africa", "13000000");
INSERT INTO "country" VALUES ("MAR", "Morocco", "Africa", "29000000");
INSERT INTO "country" VALUES ("TUN", "Tunisia", "Africa", "9000000");
INSERT INTO "country" VALUES ("LBY", "Libya", "Africa", "5000000");
INSERT INTO "country" VALUES ("SOM", "Somalia", "Africa", "10000000");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "Africa", "4000000");
INSERT INTO "country" VALUES ("DJI", "Djibouti", "Africa", "700000");
INSERT INTO "country" VALUES ("CAF", "Central African Republic", "Africa", "3000000");
INSERT INTO "country" VALUES ("TCD", "Chad", "Africa", "8000000");
INSERT INTO "country" VALUES ("NER", "Niger", "Africa", "11000000");
INSERT INTO "country" VALUES ("MLI", "Mali", "Africa", "12000000");
INSERT INTO "country" VALUES ("MRT", "Mauritania", "Africa", "3000000");
INSERT INTO "country" VALUES ("SEN", "Senegal", "Africa", "10000000");
INSERT INTO "country" VALUES ("GMB", "Gambia", "Africa", "1500000");
INSERT INTO "country" VALUES ("GIN", "Guinea", "Africa", "10000000");
INSERT INTO "country" VALUES ("GNB", "Guinea-Bissau", "Africa", "1500000");
INSERT INTO "country" VALUES ("SLE", "Sierra Leone", "Africa", "5000000");
INSERT INTO "country" VALUES ("LBR", "Liberia", "Africa", "3000000");
INSERT INTO "country" VALUES ("BFA", "Burkina Faso", "Africa", "12000000");
INSERT INTO "country" VALUES ("TGO", "Togo", "Africa", "5000000");
INSERT INTO "country" VALUES ("BEN", "Benin", "Africa", "7000000");
INSERT INTO "country" VALUES ("NGA2", "Nigeria2", "Africa", "111506000");
INSERT INTO "country" VALUES ("ZAF2", "South Africa2", "Africa", "40377000");
INSERT INTO "country" VALUES ("DZA2", "Algeria2", "Africa", "31471000");
INSERT INTO "country" VALUES ("ETH2", "Ethiopia2", "Africa", "62565000");
INSERT INTO "country" VALUES ("KEN2", "Kenya2", "Africa", "30080000");
INSERT INTO "country" VALUES ("SDN2", "Sudan2", "Africa", "30921000");
INSERT INTO "country" VALUES ("COD2", "Congo, The Democratic Republic of the2", "Africa", "50416000");
INSERT INTO "country" VALUES ("EGY2", "Egypt2", "Africa", "68470000");
INSERT INTO "country" VALUES ("ZWE2", "Zimbabwe2", "Africa", "12000000");
INSERT INTO "country" VALUES ("UGA2", "Uganda2", "Africa", "24000000");
INSERT INTO "country" VALUES ("MOZ2", "Mozambique2", "Africa", "18000000");
INSERT INTO "country" VALUES ("GHA2", "Ghana2", "Africa", "20000000");
INSERT INTO "country" VALUES ("CIV2", "Cote dIvoire2", "Africa", "16000000");
INSERT INTO "country" VALUES ("CMR2", "Cameroon2", "Africa", "15000000");
INSERT INTO "country" VALUES ("AGO2", "Angola2", "Africa", "13000000");
INSERT INTO "country" VALUES ("MAR2", "Morocco2", "Africa", "29000000");
INSERT INTO "country" VALUES ("TUN2", "Tunisia2", "Africa", "9000000");
INSERT INTO "country" VALUES ("LBY2", "Libya2", "Africa", "5000000");
INSERT INTO "country" VALUES ("SOM2", "Somalia2", "Africa", "10000000");
INSERT INTO "country" VALUES ("ERI2", "Eritrea2", "Africa", "4000000");
INSERT INTO "country" VALUES ("DJI2", "Djibouti2", "Africa", "700000");
INSERT INTO "country" VALUES ("CAF2", "Central African Republic2", "Africa", "3000000");
INSERT INTO "country" VALUES ("TCD2", "Chad2", "Africa", "8000000");
INSERT INTO "country" VALUES ("NER2", "Niger2", "Africa", "11000000");
INSERT INTO "country" VALUES ("MLI2", "Mali2", "Africa", "12000000");
INSERT INTO "country" VALUES ("MRT2", "Mauritania2", "Africa", "3000000");
INSERT INTO "country" VALUES ("SEN2", "Senegal2", "Africa", "10000000");
INSERT INTO "country" VALUES ("GMB2", "Gambia2", "Africa", "1500000");
INSERT INTO "country" VALUES ("GIN2", "Guinea2", "Africa", "10000000");
INSERT INTO "country" VALUES ("GNB2", "Guinea-Bissau2", "Africa", "1500000");
INSERT INTO "country" VALUES ("SLE2", "Sierra Leone2", "Africa", "5000000");
INSERT INTO "country" VALUES ("LBR2", "Liberia2", "Africa", "3000000");
INSERT INTO "country" VALUES ("BFA2", "Burkina Faso2", "Africa", "12000000");
INSERT INTO "country" VALUES ("TGO2", "Togo2", "Africa", "5000000");
INSERT INTO "country" VALUES ("BEN2", "Benin2", "Africa", "7000000");
INSERT INTO "city" VALUES ("1", "Kabul", "AFG");
INSERT INTO "city" VALUES ("2", "Amsterdam", "NLD");
INSERT INTO "city" VALUES ("3", "Washington", "USA");
INSERT INTO "city" VALUES ("4", "Beijing", "CHN");
INSERT INTO "city" VALUES ("5", "New Delhi", "IND");
INSERT INTO "city" VALUES ("6", "Tokyo", "JPN");
INSERT INTO "city" VALUES ("7", "Cairo", "EGY");
INSERT INTO "city" VALUES ("8", "Lagos", "NGA");
INSERT INTO "city" VALUES ("9", "Pretoria", "ZAF");
INSERT INTO "city" VALUES ("10", "Algiers", "DZA");
INSERT INTO "city" VALUES ("11", "Addis Ababa", "ETH");
INSERT INTO "city" VALUES ("12", "Nairobi", "KEN");
INSERT INTO "city" VALUES ("13", "Khartoum", "SDN");
INSERT INTO "city" VALUES ("14", "Kinshasa", "COD");
INSERT INTO "city" VALUES ("15", "Jakarta", "IDN");
INSERT INTO "city" VALUES ("16", "Islamabad", "PAK");
INSERT INTO "city" VALUES ("17", "Dhaka", "BGD");
INSERT INTO "city" VALUES ("18", "Moscow", "RUS");
INSERT INTO "city" VALUES ("19", "Brasilia", "BRA");
INSERT INTO "city" VALUES ("20", "Berlin", "DEU");
INSERT INTO "city" VALUES ("21", "London", "GBR");
INSERT INTO "city" VALUES ("22", "Paris", "FRA");
INSERT INTO "city" VALUES ("23", "Rome", "ITA");
INSERT INTO "city" VALUES ("24", "Mexico City", "MEX");
INSERT INTO "city" VALUES ("25", "Ottawa", "CAN");
INSERT INTO "city" VALUES ("26", "Canberra", "AUS");
INSERT INTO "city" VALUES ("27", "Buenos Aires", "ARG");
INSERT INTO "city" VALUES ("28", "Seoul", "KOR");
INSERT INTO "city" VALUES ("29", "Pyongyang", "PRK");
INSERT INTO "city" VALUES ("30", "Hanoi", "VNM");
INSERT INTO "city" VALUES ("31", "Manila", "PHL");
INSERT INTO "city" VALUES ("32", "Bangkok", "THA");
INSERT INTO "city" VALUES ("33", "Yangon", "MMR");
INSERT INTO "city" VALUES ("34", "Tehran", "IRN");
INSERT INTO "city" VALUES ("35", "Ankara", "TUR");
INSERT INTO "city" VALUES ("36", "Riyadh", "SAU");
INSERT INTO "city" VALUES ("37", "Jerusalem", "ISR");
INSERT INTO "city" VALUES ("38", "Damascus", "SYR");
INSERT INTO "city" VALUES ("39", "Baghdad", "IRQ");
INSERT INTO "city" VALUES ("40", "Sanaa", "YEM");
INSERT INTO "city" VALUES ("41", "Muscat", "OMN");
INSERT INTO "city" VALUES ("42", "Abu Dhabi", "ARE");
INSERT INTO "city" VALUES ("43", "Doha", "QAT");
INSERT INTO "city" VALUES ("44", "Kuwait City", "KWT");
INSERT INTO "city" VALUES ("45", "Manama", "BHR");
INSERT INTO "city" VALUES ("46", "Beirut", "LBN");
INSERT INTO "city" VALUES ("47", "Amman", "JOR");
INSERT INTO "city" VALUES ("48", "Gaza", "PSE");
INSERT INTO "city" VALUES ("49", "Nicosia", "CYP");
INSERT INTO "city" VALUES ("50", "Tbilisi", "GEO");
INSERT INTO "city" VALUES ("51", "Yerevan", "ARM");
INSERT INTO "city" VALUES ("52", "Baku", "AZE");
INSERT INTO "city" VALUES ("53", "Astana", "KAZ");
INSERT INTO "city" VALUES ("54", "Tashkent", "UZB");
INSERT INTO "city" VALUES ("55", "Ashgabat", "TKM");
INSERT INTO "city" VALUES ("56", "Bishkek", "KGZ");
INSERT INTO "city" VALUES ("57", "Dushanbe", "TJK");
INSERT INTO "city" VALUES ("58", "Kuala Lumpur", "MYS");
INSERT INTO "city" VALUES ("59", "Singapore", "SGP");
INSERT INTO "city" VALUES ("60", "Bandar Seri Begawan", "BRN");
INSERT INTO "city" VALUES ("61", "Dili", "TLS");
INSERT INTO "city" VALUES ("62", "Vientiane", "LAO");
INSERT INTO "city" VALUES ("63", "Phnom Penh", "KHM");
INSERT INTO "city" VALUES ("64", "Ulaanbaatar", "MNG");
INSERT INTO "city" VALUES ("65", "Kathmandu", "NPL");
INSERT INTO "city" VALUES ("66", "Thimphu", "BTN");
INSERT INTO "city" VALUES ("67", "Colombo", "LKA");
INSERT INTO "city" VALUES ("68", "Male", "MDV");
INSERT INTO "city" VALUES ("69", "Kabul2", "AFG2");
INSERT INTO "city" VALUES ("70", "Harare", "ZWE");
INSERT INTO "city" VALUES ("71", "Kampala", "UGA");
INSERT INTO "city" VALUES ("72", "Maputo", "MOZ");
INSERT INTO "city" VALUES ("73", "Accra", "GHA");
INSERT INTO "city" VALUES ("74", "Yamoussoukro", "CIV");
INSERT INTO "city" VALUES ("75", "Yaounde", "CMR");
INSERT INTO "city" VALUES ("76", "Luanda", "AGO");
INSERT INTO "city" VALUES ("77", "Rabat", "MAR");
INSERT INTO "city" VALUES ("78", "Tunis", "TUN");
INSERT INTO "city" VALUES ("79", "Tripoli", "LBY");
INSERT INTO "city" VALUES ("80", "Mogadishu", "SOM");
INSERT INTO "city" VALUES ("81", "Asmara", "ERI");
INSERT INTO "city" VALUES ("82", "Djibouti", "DJI");
INSERT INTO "city" VALUES ("83", "Bangui", "CAF");
INSERT INTO "city" VALUES ("84", "NDjamena", "TCD");
INSERT INTO "city" VALUES ("85", "Niamey", "NER");
INSERT INTO "city" VALUES ("86", "Bamako", "MLI");
INSERT INTO "city" VALUES ("87", "Nouakchott", "MRT");
INSERT INTO "city" VALUES ("88", "Dakar", "SEN");
INSERT INTO "city" VALUES ("89", "Banjul", "GMB");
INSERT INTO "city" VALUES ("90", "Conakry", "GIN");
INSERT INTO "city" VALUES ("91", "Bissau", "GNB");
INSERT INTO "city" VALUES ("92", "Freetown", "SLE");
INSERT INTO "city" VALUES ("93", "Monrovia", "LBR");
INSERT INTO "city" VALUES ("94", "Ouagadougou", "BFA");
INSERT INTO "city" VALUES ("95", "Lome", "TGO");
INSERT INTO "city" VALUES ("96", "Porto-Novo", "BEN");
INSERT INTO "city" VALUES ("97", "Lagos2", "NGA2");
INSERT INTO "city" VALUES ("98", "Pretoria2", "ZAF2");
INSERT INTO "city" VALUES ("99", "Algiers2", "DZA2");
INSERT INTO "city" VALUES ("100", "Addis Ababa2", "ETH2");
INSERT INTO "city" VALUES ("101", "Nairobi2", "KEN2");
INSERT INTO "city" VALUES ("102", "Khartoum2", "SDN2");
INSERT INTO "city" VALUES ("103", "Kinshasa2", "COD2");
INSERT INTO "city" VALUES ("104", "Cairo2", "EGY2");
INSERT INTO "city" VALUES ("105", "Harare2", "ZWE2");
INSERT INTO "city" VALUES ("106", "Kampala2", "UGA2");
INSERT INTO "city" VALUES ("107", "Maputo2", "MOZ2");
INSERT INTO "city" VALUES ("108", "Accra2", "GHA2");
INSERT INTO "city" VALUES ("109", "Yamoussoukro2", "CIV2");
INSERT INTO "city" VALUES ("110", "Yaounde2", "CMR2");
INSERT INTO "city" VALUES ("111", "Luanda2", "AGO2");
INSERT INTO "city" VALUES ("112", "Rabat2", "MAR2");
INSERT INTO "city" VALUES ("113", "Tunis2", "TUN2");
INSERT INTO "city" VALUES ("114", "Tripoli2", "LBY2");
INSERT INTO "city" VALUES ("115", "Mogadishu2", "SOM2");
INSERT INTO "city" VALUES ("116", "Asmara2", "ERI2");
INSERT INTO "city" VALUES ("117", "Djibouti2", "DJI2");
INSERT INTO "city" VALUES ("118", "Bangui2", "CAF2");
INSERT INTO "city" VALUES ("119", "NDjamena2", "TCD2");
INSERT INTO "city" VALUES ("120", "Niamey2", "NER2");
INSERT INTO "city" VALUES ("121", "Bamako2", "MLI2");
INSERT INTO "city" VALUES ("122", "Nouakchott2", "MRT2");
INSERT INTO "city" VALUES ("123", "Dakar2", "SEN2");
INSERT INTO "city" VALUES ("124", "Banjul2", "GMB2");
INSERT INTO "city" VALUES ("125", "Conakry2", "GIN2");
INSERT INTO "city" VALUES ("126", "Bissau2", "GNB2");
INSERT INTO "city" VALUES ("127", "Freetown2", "SLE2");
INSERT INTO "city" VALUES ("128", "Monrovia2", "LBR2");
INSERT INTO "city" VALUES ("129", "Ouagadougou2", "BFA2");
INSERT INTO "city" VALUES ("130", "Lome2", "TGO2");
INSERT INTO "city" VALUES ("131", "Porto-Novo2", "BEN2");
INSERT INTO "countrylanguage" VALUES ("AFG", "Dari");
INSERT INTO "countrylanguage" VALUES ("AFG", "Pashto");
INSERT INTO "countrylanguage" VALUES ("NLD", "Dutch");
INSERT INTO "countrylanguage" VALUES ("USA", "English");
INSERT INTO "countrylanguage" VALUES ("CHN", "Chinese");
INSERT INTO "countrylanguage" VALUES ("IND", "Hindi");
INSERT INTO "countrylanguage" VALUES ("IND", "English");
INSERT INTO "countrylanguage" VALUES ("JPN", "Japanese");
INSERT INTO "countrylanguage" VALUES ("EGY", "Arabic");
INSERT INTO "countrylanguage" VALUES ("NGA", "English");
INSERT INTO "countrylanguage" VALUES ("NGA", "Hausa");
INSERT INTO "countrylanguage" VALUES ("NGA", "Yoruba");
INSERT INTO "countrylanguage" VALUES ("NGA", "Igbo");
INSERT INTO "countrylanguage" VALUES ("ZAF", "Afrikaans");
INSERT INTO "countrylanguage" VALUES ("ZAF", "English");
INSERT INTO "countrylanguage" VALUES ("DZA", "Arabic");
INSERT INTO "countrylanguage" VALUES ("ETH", "Amharic");
INSERT INTO "countrylanguage" VALUES ("KEN", "Swahili");
INSERT INTO "countrylanguage" VALUES ("KEN", "English");
INSERT INTO "countrylanguage" VALUES ("SDN", "Arabic");
INSERT INTO "countrylanguage" VALUES ("COD", "French");
INSERT INTO "countrylanguage" VALUES ("IDN", "Indonesian");
INSERT INTO "countrylanguage" VALUES ("PAK", "Urdu");
INSERT INTO "countrylanguage" VALUES ("PAK", "English");
INSERT INTO "countrylanguage" VALUES ("BGD", "Bengali");
INSERT INTO "countrylanguage" VALUES ("RUS", "Russian");
INSERT INTO "countrylanguage" VALUES ("BRA", "Portuguese");
INSERT INTO "countrylanguage" VALUES ("DEU", "German");
INSERT INTO "countrylanguage" VALUES ("GBR", "English");
INSERT INTO "countrylanguage" VALUES ("FRA", "French");
INSERT INTO "countrylanguage" VALUES ("ITA", "Italian");
INSERT INTO "countrylanguage" VALUES ("MEX", "Spanish");