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),
PRIMARY KEY ("ID")
);

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

CREATE TABLE "countrylanguage" (
"CountryCode" CHAR(3),
"Language" CHAR(30),
"IsOfficial" TEXT,
PRIMARY KEY ("CountryCode", "Language"),
FOREIGN KEY ("CountryCode") REFERENCES "country"("Code")
);





INSERT INTO "city" VALUES ("1", "London");
INSERT INTO "city" VALUES ("2", "Paris");
INSERT INTO "city" VALUES ("3", "Berlin");
INSERT INTO "city" VALUES ("4", "Tokyo");
INSERT INTO "city" VALUES ("5", "New York");
INSERT INTO "city" VALUES ("6", "Sydney");
INSERT INTO "city" VALUES ("7", "Beijing");
INSERT INTO "city" VALUES ("8", "Moscow");
INSERT INTO "city" VALUES ("9", "Rome");
INSERT INTO "city" VALUES ("10", "Madrid");
INSERT INTO "country" VALUES ("USA", "United States", "331000000", "78.5");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "67000000", "81.0");
INSERT INTO "country" VALUES ("CAN", "Canada", "38000000", "82.0");
INSERT INTO "country" VALUES ("AUS", "Australia", "25000000", "83.0");
INSERT INTO "country" VALUES ("NZL", "New Zealand", "5000000", "81.5");
INSERT INTO "country" VALUES ("IND", "India", "1380000000", "69.0");
INSERT INTO "country" VALUES ("CHN", "China", "1440000000", "77.0");
INSERT INTO "country" VALUES ("JPN", "Japan", "126000000", "84.0");
INSERT INTO "country" VALUES ("DEU", "Germany", "83000000", "81.0");
INSERT INTO "country" VALUES ("FRA", "France", "65000000", "82.0");
INSERT INTO "country" VALUES ("ESP", "Spain", "47000000", "83.0");
INSERT INTO "country" VALUES ("ITA", "Italy", "59000000", "83.0");
INSERT INTO "country" VALUES ("BRA", "Brazil", "212000000", "75.0");
INSERT INTO "country" VALUES ("ARG", "Argentina", "45000000", "76.0");
INSERT INTO "country" VALUES ("MEX", "Mexico", "128000000", "75.0");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "59000000", "64.0");
INSERT INTO "country" VALUES ("EGY", "Egypt", "102000000", "72.0");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "206000000", "55.0");
INSERT INTO "country" VALUES ("KEN", "Kenya", "53000000", "66.0");
INSERT INTO "country" VALUES ("SWE", "Sweden", "10000000", "82.5");
INSERT INTO "country" VALUES ("NOR", "Norway", "5000000", "82.0");
INSERT INTO "country" VALUES ("FIN", "Finland", "5000000", "81.0");
INSERT INTO "country" VALUES ("DNK", "Denmark", "5000000", "81.0");
INSERT INTO "country" VALUES ("CHE", "Switzerland", "8000000", "83.5");
INSERT INTO "country" VALUES ("AUT", "Austria", "9000000", "81.0");
INSERT INTO "country" VALUES ("BEL", "Belgium", "11000000", "81.0");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "17000000", "81.5");
INSERT INTO "country" VALUES ("PRT", "Portugal", "10000000", "81.0");
INSERT INTO "country" VALUES ("GRC", "Greece", "10000000", "81.0");
INSERT INTO "country" VALUES ("POL", "Poland", "38000000", "78.0");
INSERT INTO "country" VALUES ("RUS", "Russia", "144000000", "73.0");
INSERT INTO "country" VALUES ("KOR", "South Korea", "51000000", "83.0");
INSERT INTO "country" VALUES ("THA", "Thailand", "69000000", "77.0");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "97000000", "75.0");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "273000000", "71.0");
INSERT INTO "country" VALUES ("PHL", "Philippines", "109000000", "71.0");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "32000000", "76.0");
INSERT INTO "country" VALUES ("SGP", "Singapore", "5000000", "83.0");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "9000000", "78.0");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "34000000", "75.0");
INSERT INTO "country" VALUES ("ISR", "Israel", "9000000", "82.0");
INSERT INTO "country" VALUES ("TUR", "Turkey", "84000000", "78.0");
INSERT INTO "country" VALUES ("IRN", "Iran", "83000000", "76.0");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "40000000", "71.0");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "38000000", "64.0");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "220000000", "67.0");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "164000000", "72.0");
INSERT INTO "country" VALUES ("LKA", "Sri Lanka", "21000000", "76.0");
INSERT INTO "country" VALUES ("NPL", "Nepal", "29000000", "70.0");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "54000000", "67.0");
INSERT INTO "country" VALUES ("LAO", "Laos", "7000000", "67.0");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "16000000", "70.0");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "3000000", "69.0");
INSERT INTO "country" VALUES ("KAZ", "Kazakhstan", "18000000", "73.0");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "33000000", "71.0");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "9000000", "71.0");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "6000000", "71.0");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "6000000", "68.0");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "10000000", "73.0");
INSERT INTO "country" VALUES ("ARM", "Armenia", "2000000", "75.0");
INSERT INTO "country" VALUES ("GEO", "Georgia", "3000000", "74.0");
INSERT INTO "country" VALUES ("UKR", "Ukraine", "43000000", "72.0");
INSERT INTO "country" VALUES ("BLR", "Belarus", "9000000", "74.0");
INSERT INTO "country" VALUES ("MDA", "Moldova", "2000000", "71.0");
INSERT INTO "country" VALUES ("ROU", "Romania", "19000000", "76.0");
INSERT INTO "country" VALUES ("BGR", "Bulgaria", "6000000", "75.0");
INSERT INTO "country" VALUES ("SRB", "Serbia", "6000000", "76.0");
INSERT INTO "country" VALUES ("HRV", "Croatia", "4000000", "78.0");
INSERT INTO "country" VALUES ("BIH", "Bosnia and Herzegovina", "3000000", "77.0");
INSERT INTO "country" VALUES ("SVN", "Slovenia", "2000000", "81.0");
INSERT INTO "country" VALUES ("SVK", "Slovakia", "5000000", "77.0");
INSERT INTO "country" VALUES ("CZE", "Czech Republic", "10000000", "79.0");
INSERT INTO "country" VALUES ("HUN", "Hungary", "9000000", "76.0");
INSERT INTO "country" VALUES ("EST", "Estonia", "1000000", "79.0");
INSERT INTO "country" VALUES ("LVA", "Latvia", "1000000", "75.0");
INSERT INTO "country" VALUES ("LTU", "Lithuania", "2000000", "76.0");
INSERT INTO "country" VALUES ("ISL", "Iceland", "300000", "83.0");
INSERT INTO "country" VALUES ("IRL", "Ireland", "4000000", "82.0");
INSERT INTO "country" VALUES ("MLT", "Malta", "500000", "82.0");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "1000000", "81.0");
INSERT INTO "country" VALUES ("ALB", "Albania", "2000000", "78.0");
INSERT INTO "country" VALUES ("MKD", "North Macedonia", "2000000", "75.0");
INSERT INTO "country" VALUES ("MNE", "Montenegro", "600000", "76.0");
INSERT INTO "country" VALUES ("KOS", "Kosovo", "1000000", "72.0");
INSERT INTO "country" VALUES ("GRD", "Grenada", "100000", "74.0");
INSERT INTO "country" VALUES ("DMA", "Dominica", "70000", "77.0");
INSERT INTO "country" VALUES ("LCA", "Saint Lucia", "180000", "76.0");
INSERT INTO "country" VALUES ("VCT", "Saint Vincent and the Grenadines", "110000", "73.0");
INSERT INTO "country" VALUES ("BRB", "Barbados", "280000", "76.0");
INSERT INTO "country" VALUES ("TTO", "Trinidad and Tobago", "1000000", "73.0");
INSERT INTO "country" VALUES ("JAM", "Jamaica", "2000000", "76.0");
INSERT INTO "country" VALUES ("BHS", "Bahamas", "390000", "74.0");
INSERT INTO "country" VALUES ("CUB", "Cuba", "11000000", "79.0");
INSERT INTO "country" VALUES ("HTI", "Haiti", "11000000", "64.0");
INSERT INTO "country" VALUES ("DOM", "Dominican Republic", "10000000", "74.0");
INSERT INTO "country" VALUES ("PRI", "Puerto Rico", "3000000", "79.0");
INSERT INTO "country" VALUES ("GTM", "Guatemala", "17000000", "74.0");
INSERT INTO "country" VALUES ("HND", "Honduras", "9000000", "75.0");
INSERT INTO "country" VALUES ("SLV", "El Salvador", "6000000", "74.0");
INSERT INTO "country" VALUES ("NIC", "Nicaragua", "6000000", "74.0");
INSERT INTO "country" VALUES ("CRI", "Costa Rica", "5000000", "80.0");
INSERT INTO "country" VALUES ("PAN", "Panama", "4000000", "78.0");
INSERT INTO "country" VALUES ("COL", "Colombia", "50000000", "77.0");
INSERT INTO "country" VALUES ("ECU", "Ecuador", "17000000", "77.0");
INSERT INTO "country" VALUES ("PER", "Peru", "32000000", "76.0");
INSERT INTO "country" VALUES ("BOL", "Bolivia", "11000000", "71.0");
INSERT INTO "country" VALUES ("PRY", "Paraguay", "7000000", "74.0");
INSERT INTO "country" VALUES ("URY", "Uruguay", "3000000", "78.0");
INSERT INTO "country" VALUES ("CHL", "Chile", "19000000", "80.0");
INSERT INTO "country" VALUES ("VEN", "Venezuela", "28000000", "72.0");
INSERT INTO "country" VALUES ("GUY", "Guyana", "700000", "69.0");
INSERT INTO "country" VALUES ("SUR", "Suriname", "500000", "72.0");
INSERT INTO "country" VALUES ("FJI", "Fiji", "800000", "70.0");
INSERT INTO "country" VALUES ("PNG", "Papua New Guinea", "8000000", "64.0");
INSERT INTO "country" VALUES ("SLB", "Solomon Islands", "600000", "72.0");
INSERT INTO "country" VALUES ("VUT", "Vanuatu", "300000", "72.0");
INSERT INTO "country" VALUES ("NCL", "New Caledonia", "200000", "77.0");
INSERT INTO "country" VALUES ("PYF", "French Polynesia", "200000", "78.0");
INSERT INTO "country" VALUES ("WSM", "Samoa", "200000", "73.0");
INSERT INTO "country" VALUES ("TON", "Tonga", "100000", "73.0");
INSERT INTO "country" VALUES ("KIR", "Kiribati", "100000", "68.0");
INSERT INTO "country" VALUES ("TUV", "Tuvalu", "10000", "67.0");
INSERT INTO "country" VALUES ("MHL", "Marshall Islands", "50000", "73.0");
INSERT INTO "country" VALUES ("FSM", "Micronesia", "100000", "70.0");
INSERT INTO "country" VALUES ("PLW", "Palau", "18000", "73.0");
INSERT INTO "country" VALUES ("NRU", "Nauru", "10000", "65.0");
INSERT INTO "country" VALUES ("COM", "Comoros", "800000", "64.0");
INSERT INTO "country" VALUES ("MDG", "Madagascar", "27000000", "67.0");
INSERT INTO "country" VALUES ("MUS", "Mauritius", "1000000", "75.0");
INSERT INTO "country" VALUES ("SYC", "Seychelles", "90000", "73.0");
INSERT INTO "country" VALUES ("DJI", "Djibouti", "900000", "66.0");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "3000000", "65.0");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "114000000", "66.0");
INSERT INTO "country" VALUES ("SOM", "Somalia", "15000000", "57.0");
INSERT INTO "country" VALUES ("SSD", "South Sudan", "11000000", "57.0");
INSERT INTO "country" VALUES ("SDN", "Sudan", "43000000", "65.0");
INSERT INTO "country" VALUES ("CAF", "Central African Republic", "4000000", "53.0");
INSERT INTO "country" VALUES ("CMR", "Cameroon", "26000000", "59.0");
INSERT INTO "country" VALUES ("TCD", "Chad", "16000000", "54.0");
INSERT INTO "country" VALUES ("NIG", "Niger", "24000000", "62.0");
INSERT INTO "country" VALUES ("MLI", "Mali", "20000000", "59.0");
INSERT INTO "country" VALUES ("MRT", "Mauritania", "4000000", "64.0");
INSERT INTO "country" VALUES ("SEN", "Senegal", "16000000", "68.0");
INSERT INTO "country" VALUES ("GMB", "Gambia", "2000000", "62.0");
INSERT INTO "country" VALUES ("GNB", "Guinea-Bissau", "1000000", "58.0");
INSERT INTO "country" VALUES ("GIN", "Guinea", "13000000", "61.0");
INSERT INTO "country" VALUES ("SLE", "Sierra Leone", "7000000", "55.0");
INSERT INTO "country" VALUES ("LBR", "Liberia", "5000000", "64.0");
INSERT INTO "country" VALUES ("CIV", "Cote d'Ivoire", "26000000", "58.0");
INSERT INTO "country" VALUES ("GHA", "Ghana", "31000000", "64.0");
INSERT INTO "country" VALUES ("TGO", "Togo", "8000000", "61.0");
INSERT INTO "country" VALUES ("BEN", "Benin", "12000000", "62.0");
INSERT INTO "country" VALUES ("BFA", "Burkina Faso", "20000000", "61.0");
INSERT INTO "country" VALUES ("CPV", "Cape Verde", "500000", "74.0");
INSERT INTO "country" VALUES ("STP", "Sao Tome and Principe", "200000", "70.0");
INSERT INTO "country" VALUES ("GNQ", "Equatorial Guinea", "1000000", "59.0");
INSERT INTO "country" VALUES ("GAB", "Gabon", "2000000", "67.0");
INSERT INTO "country" VALUES ("COG", "Republic of the Congo", "5000000", "65.0");
INSERT INTO "country" VALUES ("COD", "DR Congo", "89000000", "60.0");
INSERT INTO "country" VALUES ("AGO", "Angola", "32000000", "61.0");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "18000000", "64.0");
INSERT INTO "country" VALUES ("MWI", "Malawi", "18000000", "64.0");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "31000000", "61.0");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "14000000", "61.0");
INSERT INTO "country" VALUES ("BWA", "Botswana", "2000000", "69.0");
INSERT INTO "country" VALUES ("NAM", "Namibia", "2000000", "63.0");
INSERT INTO "country" VALUES ("LSO", "Lesotho", "2000000", "54.0");
INSERT INTO "country" VALUES ("SWZ", "Eswatini", "1000000", "58.0");
INSERT INTO "country" VALUES ("UGA", "Uganda", "45000000", "63.0");
INSERT INTO "country" VALUES ("RWA", "Rwanda", "12000000", "69.0");
INSERT INTO "country" VALUES ("BDI", "Burundi", "11000000", "61.0");
INSERT INTO "country" VALUES ("TZA", "Tanzania", "59000000", "65.0");
INSERT INTO "country" VALUES ("DZA", "Algeria", "43000000", "77.0");
INSERT INTO "country" VALUES ("MAR", "Morocco", "36000000", "77.0");
INSERT INTO "country" VALUES ("TUN", "Tunisia", "11000000", "76.0");
INSERT INTO "country" VALUES ("LBY", "Libya", "6000000", "72.0");
INSERT INTO "country" VALUES ("ESH", "Western Sahara", "500000", "69.0");
INSERT INTO "country" VALUES ("MLI", "Mali", "20000000", "59.0");
INSERT INTO "country" VALUES ("NER", "Niger", "24000000", "62.0");
INSERT INTO "country" VALUES ("TCD", "Chad", "16000000", "54.0");
INSERT INTO "country" VALUES ("SDN", "Sudan", "43000000", "65.0");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "3000000", "65.0");
INSERT INTO "country" VALUES ("DJI", "Djibouti", "900000", "66.0");
INSERT INTO "country" VALUES ("SOM", "Somalia", "15000000", "57.0");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "114000000", "66.0");
INSERT INTO "country" VALUES ("SSD", "South Sudan", "11000000", "57.0");
INSERT INTO "country" VALUES ("KEN", "Kenya", "53000000", "66.0");
INSERT INTO "country" VALUES ("UGA", "Uganda", "45000000", "63.0");
INSERT INTO "country" VALUES ("RWA", "Rwanda", "12000000", "69.0");
INSERT INTO "country" VALUES ("BDI", "Burundi", "11000000", "61.0");
INSERT INTO "country" VALUES ("TZA", "Tanzania", "59000000", "65.0");
INSERT INTO "country" VALUES ("MWI", "Malawi", "18000000", "64.0");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "18000000", "64.0");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "14000000", "61.0");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "31000000", "61.0");
INSERT INTO "country" VALUES ("MDG", "Madagascar", "27000000", "67.0");
INSERT INTO "country" VALUES ("COM", "Comoros", "800000", "64.0");
INSERT INTO "country" VALUES ("MUS", "Mauritius", "1000000", "75.0");
INSERT INTO "country" VALUES ("SYC", "Seychelles", "90000", "73.0");
INSERT INTO "country" VALUES ("REU", "Reunion", "800000", "79.0");
INSERT INTO "country" VALUES ("MYT", "Mayotte", "200000", "76.0");
INSERT INTO "country" VALUES ("ATF", "French Southern and Antarctic Lands", "0", "NULL");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "0", "NULL");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "600", "78.0");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "2000", "78.0");
INSERT INTO "country" VALUES ("NFK", "Norfolk Island", "2000", "78.0");
INSERT INTO "country" VALUES ("ASM", "American Samoa", "50000", "75.0");
INSERT INTO "country" VALUES ("COK", "Cook Islands", "17000", "76.0");
INSERT INTO "country" VALUES ("NIU", "Niue", "1600", "76.0");
INSERT INTO "country" VALUES ("TKL", "Tokelau", "1500", "76.0");
INSERT INTO "country" VALUES ("WLF", "Wallis and Futuna", "11000", "76.0");
INSERT INTO "country" VALUES ("PCN", "Pitcairn", "50", "78.0");
INSERT INTO "country" VALUES ("FLK", "Falkland Islands Malvinas", "3000", "78.0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "0", "NULL");
INSERT INTO "country" VALUES ("SHN", "Saint Helena", "6000", "78.0");
INSERT INTO "country" VALUES ("SPM", "Saint Pierre and Miquelon", "6000", "78.0");
INSERT INTO "country" VALUES ("GRL", "Greenland", "50000", "71.0");
INSERT INTO "country" VALUES ("SJM", "Svalbard and Jan Mayen", "2000", "78.0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "0", "NULL");