PRAGMA foreign_keys = ON;

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

CREATE TABLE "city" (
"ID" INT,
"Name" CHAR(35),
"Population" INT,
PRIMARY KEY ("ID")
);

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





INSERT INTO "city" VALUES ("1", "Tokyo", "13929286");
INSERT INTO "city" VALUES ("2", "Delhi", "18978309");
INSERT INTO "city" VALUES ("3", "Shanghai", "26317104");
INSERT INTO "city" VALUES ("4", "Sao Paulo", "12252023");
INSERT INTO "city" VALUES ("5", "Mexico City", "8918653");
INSERT INTO "city" VALUES ("6", "Cairo", "9845000");
INSERT INTO "city" VALUES ("7", "Mumbai", "12442373");
INSERT INTO "city" VALUES ("8", "Beijing", "21542000");
INSERT INTO "city" VALUES ("9", "Dhaka", "19578000");
INSERT INTO "city" VALUES ("10", "Osaka", "2700000");
INSERT INTO "city" VALUES ("11", "Karachi", "14910352");
INSERT INTO "city" VALUES ("12", "Chongqing", "32054000");
INSERT INTO "city" VALUES ("13", "Istanbul", "15067724");
INSERT INTO "city" VALUES ("14", "Buenos Aires", "2890151");
INSERT INTO "city" VALUES ("15", "Kolkata", "14681589");
INSERT INTO "city" VALUES ("16", "Manila", "13484462");
INSERT INTO "city" VALUES ("17", "Lagos", "13400000");
INSERT INTO "city" VALUES ("18", "Rio de Janeiro", "6710000");
INSERT INTO "city" VALUES ("19", "Tianjin", "15469500");
INSERT INTO "city" VALUES ("20", "Lahore", "11126285");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "126476461", "84.2");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "1380004385", "69.4");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "1439323776", "76.9");
INSERT INTO "country" VALUES ("BRA", "Brazil", "South America", "212559417", "75.9");
INSERT INTO "country" VALUES ("MEX", "Mexico", "North America", "128932753", "75.1");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "102334404", "71.8");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "Asia", "220892331", "67.1");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "164689383", "72.6");
INSERT INTO "country" VALUES ("TUR", "Turkey", "Asia", "84339067", "77.7");
INSERT INTO "country" VALUES ("ARG", "Argentina", "South America", "45195774", "76.5");
INSERT INTO "country" VALUES ("PHL", "Philippines", "Asia", "109581078", "71.2");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Africa", "206139589", "54.7");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "38928346", "64.8");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "Asia", "40222493", "70.9");
INSERT INTO "country" VALUES ("YEM", "Yemen", "Asia", "29825968", "66.1");
INSERT INTO "country" VALUES ("SYR", "Syria", "Asia", "17500657", "71.3");
INSERT INTO "country" VALUES ("PRK", "North Korea", "Asia", "25778816", "72.1");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Asia", "51269185", "83.3");
INSERT INTO "country" VALUES ("LAO", "Laos", "Asia", "7275556", "67.6");
INSERT INTO "country" VALUES ("TLS", "East Timor", "Asia", "1318445", "69.5");
INSERT INTO "country" VALUES ("BTN", "Bhutan", "Asia", "771608", "71.5");
INSERT INTO "country" VALUES ("NPL", "Nepal", "Asia", "29136808", "70.5");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "Asia", "3278290", "69.9");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "Asia", "6524195", "71.4");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "Asia", "9537645", "71.1");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "33469203", "71.6");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "Asia", "6031187", "68.1");
INSERT INTO "country" VALUES ("KAZ", "Kazakhstan", "Asia", "18776707", "73.2");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "Asia", "10139177", "73.1");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Asia", "3989167", "73.6");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Asia", "2963243", "75.1");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "Asia", "1207359", "80.9");
INSERT INTO "country" VALUES ("ISR", "Israel", "Asia", "8655535", "82.8");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "Asia", "6825442", "78.9");
INSERT INTO "country" VALUES ("JOR", "Jordan", "Asia", "10203134", "74.5");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "Asia", "34813871", "75.0");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "Asia", "9890400", "77.8");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Asia", "2881053", "79.8");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "Asia", "1701575", "77.2");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "Asia", "4270571", "75.4");
INSERT INTO "country" VALUES ("OMN", "Oman", "Asia", "5106626", "77.9");
INSERT INTO "country" VALUES ("IRN", "Iran", "Asia", "83992949", "76.3");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "Asia", "32365999", "76.1");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Asia", "5850342", "83.6");
INSERT INTO "country" VALUES ("BRN", "Brunei", "Asia", "437479", "77.1");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "Asia", "273523615", "71.5");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "Asia", "97338573", "75.4");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "Asia", "16718965", "69.8");
INSERT INTO "country" VALUES ("THA", "Thailand", "Asia", "69799978", "77.1");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "Asia", "54409800", "67.1");
INSERT INTO "country" VALUES ("LKA", "Sri Lanka", "Asia", "21413247", "76.8");
INSERT INTO "country" VALUES ("MDV", "Maldives", "Asia", "540544", "78.9");
INSERT INTO "country" VALUES ("TWN", "Taiwan", "Asia", "23816775", "80.7");
INSERT INTO "country" VALUES ("HKG", "Hong Kong", "Asia", "7496981", "84.9");
INSERT INTO "country" VALUES ("MAC", "Macau", "Asia", "649335", "84.6");
INSERT INTO "country" VALUES ("RUS", "Russia", "Europe", "145934462", "72.4");
INSERT INTO "country" VALUES ("DEU", "Germany", "Europe", "83783942", "81.3");
INSERT INTO "country" VALUES ("FRA", "France", "Europe", "65273511", "82.5");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "Europe", "67886011", "81.3");
INSERT INTO "country" VALUES ("ITA", "Italy", "Europe", "59554023", "83.5");
INSERT INTO "country" VALUES ("ESP", "Spain", "Europe", "46754778", "83.5");
INSERT INTO "country" VALUES ("POL", "Poland", "Europe", "37846611", "78.5");
INSERT INTO "country" VALUES ("UKR", "Ukraine", "Europe", "43733762", "71.6");
INSERT INTO "country" VALUES ("ROU", "Romania", "Europe", "19237691", "76.1");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "Europe", "17134872", "81.9");
INSERT INTO "country" VALUES ("BEL", "Belgium", "Europe", "11589623", "81.6");
INSERT INTO "country" VALUES ("GRC", "Greece", "Europe", "10423054", "81.6");
INSERT INTO "country" VALUES ("PRT", "Portugal", "Europe", "10196709", "81.8");
INSERT INTO "country" VALUES ("SWE", "Sweden", "Europe", "10099270", "82.8");
INSERT INTO "country" VALUES ("CZE", "Czech Republic", "Europe", "10708981", "79.3");
INSERT INTO "country" VALUES ("HUN", "Hungary", "Europe", "9633994", "76.0");
INSERT INTO "country" VALUES ("AUT", "Austria", "Europe", "9006398", "81.6");
INSERT INTO "country" VALUES ("CHE", "Switzerland", "Europe", "8654622", "83.7");
INSERT INTO "country" VALUES ("BGR", "Bulgaria", "Europe", "6948445", "74.9");
INSERT INTO "country" VALUES ("SRB", "Serbia", "Europe", "8737371", "75.7");
INSERT INTO "country" VALUES ("DNK", "Denmark", "Europe", "5792202", "81.3");
INSERT INTO "country" VALUES ("FIN", "Finland", "Europe", "5540720", "81.9");
INSERT INTO "country" VALUES ("NOR", "Norway", "Europe", "5421241", "82.7");
INSERT INTO "country" VALUES ("IRL", "Ireland", "Europe", "4937786", "82.3");
INSERT INTO "country" VALUES ("HRV", "Croatia", "Europe", "4008617", "78.0");
INSERT INTO "country" VALUES ("BIH", "Bosnia and Herzegovina", "Europe", "3280894", "77.5");
INSERT INTO "country" VALUES ("ALB", "Albania", "Europe", "2877797", "78.5");
INSERT INTO "country" VALUES ("LTU", "Lithuania", "Europe", "2794700", "75.9");
INSERT INTO "country" VALUES ("LVA", "Latvia", "Europe", "1901000", "75.2");
INSERT INTO "country" VALUES ("EST", "Estonia", "Europe", "1326200", "78.8");
INSERT INTO "country" VALUES ("SVK", "Slovakia", "Europe", "5458827", "77.3");
INSERT INTO "country" VALUES ("SVN", "Slovenia", "Europe", "2078938", "81.3");
INSERT INTO "country" VALUES ("MKD", "North Macedonia", "Europe", "2083374", "75.9");
INSERT INTO "country" VALUES ("MLT", "Malta", "Europe", "514564", "82.6");
INSERT INTO "country" VALUES ("ISL", "Iceland", "Europe", "341243", "82.9");
INSERT INTO "country" VALUES ("LUX", "Luxembourg", "Europe", "625978", "82.3");
INSERT INTO "country" VALUES ("MNE", "Montenegro", "Europe", "628062", "76.8");
INSERT INTO "country" VALUES ("MDA", "Moldova", "Europe", "4033963", "71.6");
INSERT INTO "country" VALUES ("BLR", "Belarus", "Europe", "9449323", "74.2");
INSERT INTO "country" VALUES ("KOS", "Kosovo", "Europe", "1810366", "72.9");
INSERT INTO "country" VALUES ("CYP2", "Cyprus EU", "Europe", "875900", "80.9");
INSERT INTO "country" VALUES ("MLI", "Mali", "Africa", "20250833", "59.3");
INSERT INTO "country" VALUES ("NIG", "Niger", "Africa", "24133962", "62.0");
INSERT INTO "country" VALUES ("SOM", "Somalia", "Africa", "15893222", "57.1");
INSERT INTO "country" VALUES ("CAF", "Central African Republic", "Africa", "4829767", "53.3");
INSERT INTO "country" VALUES ("SSD", "South Sudan", "Africa", "11193725", "57.9");
INSERT INTO "country" VALUES ("CHA", "Chad", "Africa", "16425864", "54.0");
INSERT INTO "country" VALUES ("COD", "DR Congo", "Africa", "89561404", "60.4");
INSERT INTO "country" VALUES ("AGO", "Angola", "Africa", "32866272", "61.1");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "Africa", "31255435", "60.2");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "Africa", "18383956", "63.5");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "Africa", "14862924", "61.2");
INSERT INTO "country" VALUES ("MWI", "Malawi", "Africa", "19129952", "64.2");
INSERT INTO "country" VALUES ("TZA", "Tanzania", "Africa", "59734218", "64.9");
INSERT INTO "country" VALUES ("KEN", "Kenya", "Africa", "53771296", "66.7");
INSERT INTO "country" VALUES ("UGA", "Uganda", "Africa", "45741000", "63.0");
INSERT INTO "country" VALUES ("RWA", "Rwanda", "Africa", "12952218", "69.0");
INSERT INTO "country" VALUES ("BDI", "Burundi", "Africa", "11890781", "61.2");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "Africa", "114963588", "66.6");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "Africa", "3546421", "65.9");
INSERT INTO "country" VALUES ("DJI", "Djibouti", "Africa", "988000", "66.3");
INSERT INTO "country" VALUES ("SDN", "Sudan", "Africa", "43849260", "65.1");
INSERT INTO "country" VALUES ("LBY", "Libya", "Africa", "6871287", "72.7");
INSERT INTO "country" VALUES ("TUN", "Tunisia", "Africa", "11818619", "76.2");
INSERT INTO "country" VALUES ("DZA", "Algeria", "Africa", "43851044", "76.7");
INSERT INTO "country" VALUES ("MAR", "Morocco", "Africa", "36910560", "76.4");
INSERT INTO "country" VALUES ("MRT", "Mauritania", "Africa", "4649658", "64.7");
INSERT INTO "country" VALUES ("SEN", "Senegal", "Africa", "16743927", "67.7");
INSERT INTO "country" VALUES ("GMB", "Gambia", "Africa", "2416664", "62.0");
INSERT INTO "country" VALUES ("GNB", "Guinea-Bissau", "Africa", "1968000", "58.0");
INSERT INTO "country" VALUES ("GIN", "Guinea", "Africa", "13132795", "61.2");
INSERT INTO "country" VALUES ("SLE", "Sierra Leone", "Africa", "7976983", "54.7");
INSERT INTO "country" VALUES ("LBR", "Liberia", "Africa", "5057681", "64.1");
INSERT INTO "country" VALUES ("CIV", "Cote d'Ivoire", "Africa", "26378274", "57.4");
INSERT INTO "country" VALUES ("GHA", "Ghana", "Africa", "31072940", "64.0");
INSERT INTO "country" VALUES ("TGO", "Togo", "Africa", "8278724", "61.0");
INSERT INTO "country" VALUES ("BEN", "Benin", "Africa", "12123200", "61.5");
INSERT INTO "country" VALUES ("BFA", "Burkina Faso", "Africa", "20903273", "61.6");
INSERT INTO "country" VALUES ("CPV", "Cabo Verde", "Africa", "555988", "73.2");
INSERT INTO "country" VALUES ("CMR", "Cameroon", "Africa", "26545863", "59.2");
INSERT INTO "country" VALUES ("GNQ", "Equatorial Guinea", "Africa", "1402985", "58.4");
INSERT INTO "country" VALUES ("GAB", "Gabon", "Africa", "2225734", "66.0");
INSERT INTO "country" VALUES ("COG", "Congo", "Africa", "5610000", "64.3");
INSERT INTO "country" VALUES ("STP", "Sao Tome and Principe", "Africa", "219159", "70.3");
INSERT INTO "country" VALUES ("NAM", "Namibia", "Africa", "2540905", "63.7");
INSERT INTO "country" VALUES ("BWA", "Botswana", "Africa", "2351627", "69.3");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "59308690", "64.1");
INSERT INTO "country" VALUES ("SWZ", "Eswatini", "Africa", "1160164", "58.9");
INSERT INTO "country" VALUES ("LSO", "Lesotho", "Africa", "2125262", "54.3");
INSERT INTO "country" VALUES ("COM", "Comoros", "Africa", "869601", "64.1");
INSERT INTO "country" VALUES ("MDG", "Madagascar", "Africa", "27691018", "67.0");
INSERT INTO "country" VALUES ("MUS", "Mauritius", "Africa", "1265577", "74.9");
INSERT INTO "country" VALUES ("SYC", "Seychelles", "Africa", "98462", "73.7");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "37742154", "82.2");
INSERT INTO "country" VALUES ("USA", "United States", "North America", "331002651", "78.5");
INSERT INTO "country" VALUES ("GRL", "Greenland", "North America", "56225", "71.0");
INSERT INTO "country" VALUES ("CUB", "Cuba", "North America", "11326616", "79.0");
INSERT INTO "country" VALUES ("JAM", "Jamaica", "North America", "2961167", "76.0");
INSERT INTO "country" VALUES ("HTI", "Haiti", "North America", "11402528", "64.0");
INSERT INTO "country" VALUES ("DOM", "Dominican Republic", "North America", "10847904", "73.9");
INSERT INTO "country" VALUES ("PRI", "Puerto Rico", "North America", "3193694", "79.8");
INSERT INTO "country" VALUES ("BHS", "Bahamas", "North America", "393244", "73.8");
INSERT INTO "country" VALUES ("TTO", "Trinidad and Tobago", "North America", "1399488", "73.4");
INSERT INTO "country" VALUES ("BLZ", "Belize", "North America", "397621", "74.6");
INSERT INTO "country" VALUES ("GTM", "Guatemala", "North America", "17915568", "74.1");
INSERT INTO "country" VALUES ("HND", "Honduras", "North America", "9904607", "75.2");
INSERT INTO "country" VALUES ("SLV", "El Salvador", "North America", "6486201", "73.4");
INSERT INTO "country" VALUES ("NIC", "Nicaragua", "North America", "6624554", "74.3");
INSERT INTO "country" VALUES ("CRI", "Costa Rica", "North America", "5094118", "80.1");
INSERT INTO "country" VALUES ("PAN", "Panama", "North America", "4314768", "78.3");
INSERT INTO "country" VALUES ("COL", "Colombia", "South America", "50882891", "77.1");
INSERT INTO "country" VALUES ("VEN", "Venezuela", "South America", "28435940", "72.1");
INSERT INTO "country" VALUES ("ECU", "Ecuador", "South America", "17643054", "77.0");
INSERT INTO "country" VALUES ("PER", "Peru", "South America", "32971854", "76.7");
INSERT INTO "country" VALUES ("BOL", "Bolivia", "South America", "11673029", "71.5");
INSERT INTO "country" VALUES ("CHL", "Chile", "South America", "19116201", "80.2");
INSERT INTO "country" VALUES ("PRY", "Paraguay", "South America", "7132538", "74.1");
INSERT INTO "country" VALUES ("URY", "Uruguay", "South America", "3473727", "77.8");
INSERT INTO "country" VALUES ("GUY", "Guyana", "South America", "786552", "69.7");
INSERT INTO "country" VALUES ("SUR", "Suriname", "South America", "586634", "71.6");
INSERT INTO "country" VALUES ("GUF", "French Guiana", "South America", "298682", "77.0");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "25499884", "82.8");
INSERT INTO "country" VALUES ("NZL", "New Zealand", "Oceania", "4822233", "82.2");
INSERT INTO "country" VALUES ("PNG", "Papua New Guinea", "Oceania", "8947024", "64.3");
INSERT INTO "country" VALUES ("FJI", "Fiji", "Oceania", "896444", "70.9");
INSERT INTO "country" VALUES ("SLB", "Solomon Islands", "Oceania", "686878", "72.6");
INSERT INTO "country" VALUES ("VUT", "Vanuatu", "Oceania", "307145", "70.4");
INSERT INTO "country" VALUES ("NCL", "New Caledonia", "Oceania", "287800", "77.7");
INSERT INTO "country" VALUES ("PYF", "French Polynesia", "Oceania", "279200", "77.7");
INSERT INTO "country" VALUES ("KIR", "Kiribati", "Oceania", "119446", "68.1");
INSERT INTO "country" VALUES ("FSM", "Micronesia", "Oceania", "115021", "69.8");
INSERT INTO "country" VALUES ("MHL", "Marshall Islands", "Oceania", "59190", "69.9");
INSERT INTO "country" VALUES ("PLW", "Palau", "Oceania", "18008", "73.7");
INSERT INTO "country" VALUES ("NRU", "Nauru", "Oceania", "10824", "67.0");
INSERT INTO "country" VALUES ("TUV", "Tuvalu", "Oceania", "11792", "67.3");