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),
"Name" CHAR(52),
"Continent" TEXT,
"IndepYear" INT,
"Population" INT,
PRIMARY KEY ("Code")
);





INSERT INTO "city" VALUES ("1", "New York");
INSERT INTO "city" VALUES ("2", "London");
INSERT INTO "city" VALUES ("3", "Paris");
INSERT INTO "city" VALUES ("4", "Tokyo");
INSERT INTO "city" VALUES ("5", "Beijing");
INSERT INTO "city" VALUES ("6", "Berlin");
INSERT INTO "city" VALUES ("7", "Rome");
INSERT INTO "city" VALUES ("8", "Cairo");
INSERT INTO "city" VALUES ("9", "Sydney");
INSERT INTO "city" VALUES ("10", "Rio de Janeiro");
INSERT INTO "country" VALUES ("USA", "United States", "North America", "1776", "331000000");
INSERT INTO "country" VALUES ("CAN", "Canada", "North America", "1867", "38000000");
INSERT INTO "country" VALUES ("MEX", "Mexico", "North America", "1810", "128000000");
INSERT INTO "country" VALUES ("BRA", "Brazil", "South America", "1822", "213000000");
INSERT INTO "country" VALUES ("ARG", "Argentina", "South America", "1816", "45000000");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "Europe", "1707", "67000000");
INSERT INTO "country" VALUES ("FRA", "France", "Europe", "843", "65000000");
INSERT INTO "country" VALUES ("GER", "Germany", "Europe", "1871", "83000000");
INSERT INTO "country" VALUES ("ITA", "Italy", "Europe", "1861", "59000000");
INSERT INTO "country" VALUES ("ESP", "Spain", "Europe", "1492", "47000000");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "1947", "1380000000");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "1949", "1440000000");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "660", "126000000");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Asia", "1948", "51000000");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "1901", "25000000");
INSERT INTO "country" VALUES ("NZL", "New Zealand", "Oceania", "1907", "5000000");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "1922", "102000000");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Africa", "1960", "206000000");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "1910", "59000000");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "Asia", "1945", "97000000");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "Asia", "1945", "273000000");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "Asia", "1947", "220000000");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "Asia", "1957", "32000000");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Asia", "1965", "5700000");
INSERT INTO "country" VALUES ("PHL", "Philippines", "Asia", "1946", "109000000");
INSERT INTO "country" VALUES ("DZA", "Algeria", "Africa", "1962", "44000000");
INSERT INTO "country" VALUES ("KEN", "Kenya", "Africa", "1963", "53000000");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "Africa", "1941", "115000000");
INSERT INTO "country" VALUES ("GHA", "Ghana", "Africa", "1957", "31000000");
INSERT INTO "country" VALUES ("CIV", "Cote d'Ivoire", "Africa", "1960", "26000000");
INSERT INTO "country" VALUES ("CMR", "Cameroon", "Africa", "1960", "26000000");
INSERT INTO "country" VALUES ("TZA", "Tanzania", "Africa", "1961", "59000000");
INSERT INTO "country" VALUES ("UGA", "Uganda", "Africa", "1962", "45000000");
INSERT INTO "country" VALUES ("AGO", "Angola", "Africa", "1975", "32000000");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "Africa", "1975", "31000000");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "Africa", "1964", "18000000");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "Africa", "1980", "14000000");
INSERT INTO "country" VALUES ("NAM", "Namibia", "Africa", "1990", "2500000");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "Africa", "1993", "3500000");
INSERT INTO "country" VALUES ("SSD", "South Sudan", "Africa", "2011", "11000000");
INSERT INTO "country" VALUES ("TLS", "Timor-Leste", "Asia", "2002", "1300000");
INSERT INTO "country" VALUES ("MNE", "Montenegro", "Europe", "2006", "620000");
INSERT INTO "country" VALUES ("SRB", "Serbia", "Europe", "2006", "7000000");
INSERT INTO "country" VALUES ("KOS", "Kosovo", "Europe", "2008", "1800000");
INSERT INTO "country" VALUES ("CUB", "Cuba", "North America", "1902", "11000000");
INSERT INTO "country" VALUES ("PRK", "North Korea", "Asia", "1948", "25000000");
INSERT INTO "country" VALUES ("ISR", "Israel", "Asia", "1948", "9000000");
INSERT INTO "country" VALUES ("LBY", "Libya", "Africa", "1951", "6800000");
INSERT INTO "country" VALUES ("SDN", "Sudan", "Africa", "1956", "43000000");
INSERT INTO "country" VALUES ("MAR", "Morocco", "Africa", "1956", "36000000");
INSERT INTO "country" VALUES ("TUN", "Tunisia", "Africa", "1956", "11000000");
INSERT INTO "country" VALUES ("GNB", "Guinea-Bissau", "Africa", "1973", "1900000");
INSERT INTO "country" VALUES ("CPV", "Cabo Verde", "Africa", "1975", "550000");
INSERT INTO "country" VALUES ("STP", "Sao Tome and Principe", "Africa", "1975", "210000");
INSERT INTO "country" VALUES ("COM", "Comoros", "Africa", "1975", "870000");
INSERT INTO "country" VALUES ("DJI", "Djibouti", "Africa", "1977", "980000");
INSERT INTO "country" VALUES ("MDV", "Maldives", "Asia", "1965", "540000");
INSERT INTO "country" VALUES ("BRN", "Brunei", "Asia", "1984", "430000");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "Asia", "1971", "9800000");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Asia", "1971", "2800000");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "Asia", "1971", "1700000");
INSERT INTO "country" VALUES ("OMN", "Oman", "Asia", "1971", "5100000");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "Asia", "1961", "4200000");
INSERT INTO "country" VALUES ("YEM", "Yemen", "Asia", "1990", "29000000");
INSERT INTO "country" VALUES ("SYR", "Syria", "Asia", "1946", "17000000");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "Asia", "1943", "6800000");
INSERT INTO "country" VALUES ("JOR", "Jordan", "Asia", "1946", "10000000");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "Asia", "1932", "40000000");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "1919", "38000000");
INSERT INTO "country" VALUES ("IRN", "Iran", "Asia", "1925", "83000000");
INSERT INTO "country" VALUES ("TUR", "Turkey", "Asia", "1923", "84000000");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "Asia", "1960", "1200000");
INSERT INTO "country" VALUES ("MLT", "Malta", "Europe", "1964", "500000");
INSERT INTO "country" VALUES ("ISL", "Iceland", "Europe", "1944", "360000");
INSERT INTO "country" VALUES ("IRL", "Ireland", "Europe", "1922", "4900000");
INSERT INTO "country" VALUES ("FIN", "Finland", "Europe", "1917", "5500000");
INSERT INTO "country" VALUES ("SWE", "Sweden", "Europe", "1523", "10000000");
INSERT INTO "country" VALUES ("NOR", "Norway", "Europe", "1905", "5300000");
INSERT INTO "country" VALUES ("DNK", "Denmark", "Europe", "800", "5800000");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "Europe", "1579", "17000000");
INSERT INTO "country" VALUES ("BEL", "Belgium", "Europe", "1830", "11000000");
INSERT INTO "country" VALUES ("LUX", "Luxembourg", "Europe", "1839", "620000");
INSERT INTO "country" VALUES ("CHE", "Switzerland", "Europe", "1291", "8600000");
INSERT INTO "country" VALUES ("AUT", "Austria", "Europe", "1918", "8900000");
INSERT INTO "country" VALUES ("POL", "Poland", "Europe", "1918", "37000000");
INSERT INTO "country" VALUES ("CZE", "Czech Republic", "Europe", "1993", "10000000");
INSERT INTO "country" VALUES ("SVK", "Slovakia", "Europe", "1993", "5400000");
INSERT INTO "country" VALUES ("HUN", "Hungary", "Europe", "1918", "9600000");
INSERT INTO "country" VALUES ("ROU", "Romania", "Europe", "1877", "19000000");
INSERT INTO "country" VALUES ("BGR", "Bulgaria", "Europe", "1908", "6900000");
INSERT INTO "country" VALUES ("GRC", "Greece", "Europe", "1821", "10000000");
INSERT INTO "country" VALUES ("ALB", "Albania", "Europe", "1912", "2800000");
INSERT INTO "country" VALUES ("MKD", "North Macedonia", "Europe", "1991", "2000000");
INSERT INTO "country" VALUES ("BIH", "Bosnia and Herzegovina", "Europe", "1992", "3200000");
INSERT INTO "country" VALUES ("HRV", "Croatia", "Europe", "1991", "4000000");
INSERT INTO "country" VALUES ("SVN", "Slovenia", "Europe", "1991", "2000000");
INSERT INTO "country" VALUES ("EST", "Estonia", "Europe", "1991", "1300000");
INSERT INTO "country" VALUES ("LVA", "Latvia", "Europe", "1991", "1900000");
INSERT INTO "country" VALUES ("LTU", "Lithuania", "Europe", "1991", "2700000");
INSERT INTO "country" VALUES ("BLR", "Belarus", "Europe", "1991", "9400000");
INSERT INTO "country" VALUES ("UKR", "Ukraine", "Europe", "1991", "43000000");
INSERT INTO "country" VALUES ("MDA", "Moldova", "Europe", "1991", "2600000");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Asia", "1991", "3700000");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Asia", "1991", "2900000");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "Asia", "1991", "10000000");
INSERT INTO "country" VALUES ("KAZ", "Kazakhstan", "Asia", "1991", "18000000");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "Asia", "1991", "6500000");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "Asia", "1991", "9500000");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "Asia", "1991", "6000000");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "1991", "33000000");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "Asia", "1921", "3300000");
INSERT INTO "country" VALUES ("LAO", "Laos", "Asia", "1953", "7200000");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "Asia", "1953", "16000000");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "Asia", "1948", "54000000");
INSERT INTO "country" VALUES ("THA", "Thailand", "Asia", "1238", "69000000");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "1971", "164000000");
INSERT INTO "country" VALUES ("NPL", "Nepal", "Asia", "1768", "29000000");
INSERT INTO "country" VALUES ("BTN", "Bhutan", "Asia", "1907", "770000");
INSERT INTO "country" VALUES ("LKA", "Sri Lanka", "Asia", "1948", "21000000");
INSERT INTO "country" VALUES ("FJI", "Fiji", "Oceania", "1970", "890000");
INSERT INTO "country" VALUES ("PNG", "Papua New Guinea", "Oceania", "1975", "8900000");
INSERT INTO "country" VALUES ("SLB", "Solomon Islands", "Oceania", "1978", "680000");
INSERT INTO "country" VALUES ("VUT", "Vanuatu", "Oceania", "1980", "300000");
INSERT INTO "country" VALUES ("WSM", "Samoa", "Oceania", "1962", "200000");
INSERT INTO "country" VALUES ("TON", "Tonga", "Oceania", "1970", "100000");
INSERT INTO "country" VALUES ("KIR", "Kiribati", "Oceania", "1979", "110000");
INSERT INTO "country" VALUES ("TUV", "Tuvalu", "Oceania", "1978", "11000");
INSERT INTO "country" VALUES ("NRU", "Nauru", "Oceania", "1968", "10000");
INSERT INTO "country" VALUES ("MHL", "Marshall Islands", "Oceania", "1986", "59000");
INSERT INTO "country" VALUES ("FSM", "Micronesia", "Oceania", "1986", "110000");
INSERT INTO "country" VALUES ("PLW", "Palau", "Oceania", "1994", "18000");
INSERT INTO "country" VALUES ("ATG", "Antigua and Barbuda", "North America", "1981", "97000");
INSERT INTO "country" VALUES ("BHS", "Bahamas", "North America", "1973", "390000");
INSERT INTO "country" VALUES ("BRB", "Barbados", "North America", "1966", "280000");
INSERT INTO "country" VALUES ("BLZ", "Belize", "North America", "1981", "390000");
INSERT INTO "country" VALUES ("CRI", "Costa Rica", "North America", "1821", "5000000");
INSERT INTO "country" VALUES ("DMA", "Dominica", "North America", "1978", "72000");
INSERT INTO "country" VALUES ("DOM", "Dominican Republic", "North America", "1844", "10000000");
INSERT INTO "country" VALUES ("SLV", "El Salvador", "North America", "1821", "6400000");
INSERT INTO "country" VALUES ("GRD", "Grenada", "North America", "1974", "110000");
INSERT INTO "country" VALUES ("GTM", "Guatemala", "North America", "1821", "17000000");
INSERT INTO "country" VALUES ("HTI", "Haiti", "North America", "1804", "11000000");
INSERT INTO "country" VALUES ("HND", "Honduras", "North America", "1821", "9900000");
INSERT INTO "country" VALUES ("JAM", "Jamaica", "North America", "1962", "2900000");
INSERT INTO "country" VALUES ("NIC", "Nicaragua", "North America", "1821", "6600000");
INSERT INTO "country" VALUES ("PAN", "Panama", "North America", "1903", "4300000");
INSERT INTO "country" VALUES ("KNA", "Saint Kitts and Nevis", "North America", "1983", "53000");
INSERT INTO "country" VALUES ("LCA", "Saint Lucia", "North America", "1979", "180000");
INSERT INTO "country" VALUES ("VCT", "Saint Vincent and the Grenadines", "North America", "1979", "110000");
INSERT INTO "country" VALUES ("TTO", "Trinidad and Tobago", "North America", "1962", "1300000");
INSERT INTO "country" VALUES ("BOL", "Bolivia", "South America", "1825", "11000000");
INSERT INTO "country" VALUES ("CHL", "Chile", "South America", "1818", "19000000");
INSERT INTO "country" VALUES ("COL", "Colombia", "South America", "1810", "50000000");
INSERT INTO "country" VALUES ("ECU", "Ecuador", "South America", "1822", "17000000");
INSERT INTO "country" VALUES ("GUY", "Guyana", "South America", "1966", "780000");
INSERT INTO "country" VALUES ("PRY", "Paraguay", "South America", "1811", "7100000");
INSERT INTO "country" VALUES ("PER", "Peru", "South America", "1821", "32000000");
INSERT INTO "country" VALUES ("SUR", "Suriname", "South America", "1975", "580000");
INSERT INTO "country" VALUES ("URY", "Uruguay", "South America", "1825", "3400000");
INSERT INTO "country" VALUES ("VEN", "Venezuela", "South America", "1811", "28000000");