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),
"IndepYear" INT,
"Population" INT,
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", "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", "Madrid");
INSERT INTO "city" VALUES ("9", "Moscow");
INSERT INTO "city" VALUES ("10", "Sydney");
INSERT INTO "country" VALUES ("USA", "United States", "1776", "330000000");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "1707", "67000000");
INSERT INTO "country" VALUES ("FRA", "France", "843", "65000000");
INSERT INTO "country" VALUES ("JPN", "Japan", "660", "126000000");
INSERT INTO "country" VALUES ("CHN", "China", "221", "1400000000");
INSERT INTO "country" VALUES ("DEU", "Germany", "1871", "83000000");
INSERT INTO "country" VALUES ("ITA", "Italy", "1861", "59000000");
INSERT INTO "country" VALUES ("ESP", "Spain", "1492", "47000000");
INSERT INTO "country" VALUES ("RUS", "Russia", "862", "146000000");
INSERT INTO "country" VALUES ("AUS", "Australia", "1901", "26000000");
INSERT INTO "country" VALUES ("CAN", "Canada", "1867", "38000000");
INSERT INTO "country" VALUES ("IND", "India", "1947", "1380000000");
INSERT INTO "country" VALUES ("BRA", "Brazil", "1822", "215000000");
INSERT INTO "country" VALUES ("MEX", "Mexico", "1810", "128000000");
INSERT INTO "country" VALUES ("EGY", "Egypt", "1922", "102000000");
INSERT INTO "country" VALUES ("TUR", "Turkey", "1923", "84000000");
INSERT INTO "country" VALUES ("GRC", "Greece", "1830", "10000000");
INSERT INTO "country" VALUES ("BEL", "Belgium", "1830", "11000000");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "1579", "17000000");
INSERT INTO "country" VALUES ("SWE", "Sweden", "1523", "10000000");
INSERT INTO "country" VALUES ("NOR", "Norway", "1905", "5000000");
INSERT INTO "country" VALUES ("DNK", "Denmark", "965", "5000000");
INSERT INTO "country" VALUES ("FIN", "Finland", "1917", "5000000");
INSERT INTO "country" VALUES ("POL", "Poland", "1918", "38000000");
INSERT INTO "country" VALUES ("CZE", "Czech Republic", "1993", "10000000");
INSERT INTO "country" VALUES ("SVK", "Slovakia", "1993", "5000000");
INSERT INTO "country" VALUES ("HUN", "Hungary", "1000", "9000000");
INSERT INTO "country" VALUES ("AUT", "Austria", "1918", "9000000");
INSERT INTO "country" VALUES ("CHE", "Switzerland", "1291", "8000000");
INSERT INTO "country" VALUES ("PRT", "Portugal", "1143", "10000000");
INSERT INTO "country" VALUES ("IRL", "Ireland", "1922", "5000000");
INSERT INTO "country" VALUES ("ARG", "Argentina", "1816", "45000000");
INSERT INTO "country" VALUES ("CHL", "Chile", "1818", "19000000");
INSERT INTO "country" VALUES ("COL", "Colombia", "1810", "51000000");
INSERT INTO "country" VALUES ("PER", "Peru", "1821", "33000000");
INSERT INTO "country" VALUES ("VEN", "Venezuela", "1811", "28000000");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "1910", "60000000");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "1960", "210000000");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "1941", "115000000");
INSERT INTO "country" VALUES ("KEN", "Kenya", "1963", "53000000");
INSERT INTO "country" VALUES ("DZA", "Algeria", "1962", "44000000");
INSERT INTO "country" VALUES ("MAR", "Morocco", "1956", "37000000");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "1932", "35000000");
INSERT INTO "country" VALUES ("IRN", "Iran", "1925", "85000000");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "1932", "40000000");
INSERT INTO "country" VALUES ("ISR", "Israel", "1948", "9000000");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "1947", "220000000");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "1971", "166000000");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "1945", "275000000");
INSERT INTO "country" VALUES ("PHL", "Philippines", "1898", "110000000");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "1945", "97000000");
INSERT INTO "country" VALUES ("THA", "Thailand", "1238", "70000000");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "1957", "32000000");
INSERT INTO "country" VALUES ("SGP", "Singapore", "1965", "5000000");
INSERT INTO "country" VALUES ("NZL", "New Zealand", "1907", "5000000");
INSERT INTO "country" VALUES ("KOR", "South Korea", "1948", "51000000");
INSERT INTO "country" VALUES ("PRK", "North Korea", "1948", "25000000");
INSERT INTO "country" VALUES ("CUB", "Cuba", "1902", "11000000");
INSERT INTO "country" VALUES ("DOM", "Dominican Republic", "1844", "10000000");
INSERT INTO "country" VALUES ("HTI", "Haiti", "1804", "11000000");
INSERT INTO "country" VALUES ("JAM", "Jamaica", "1962", "2000000");
INSERT INTO "country" VALUES ("CRI", "Costa Rica", "1821", "5000000");
INSERT INTO "country" VALUES ("PAN", "Panama", "1903", "4000000");
INSERT INTO "country" VALUES ("GTM", "Guatemala", "1821", "17000000");
INSERT INTO "country" VALUES ("HND", "Honduras", "1821", "9000000");
INSERT INTO "country" VALUES ("SLV", "El Salvador", "1821", "6000000");
INSERT INTO "country" VALUES ("NIC", "Nicaragua", "1821", "6000000");
INSERT INTO "country" VALUES ("BOL", "Bolivia", "1825", "11000000");
INSERT INTO "country" VALUES ("ECU", "Ecuador", "1822", "17000000");
INSERT INTO "country" VALUES ("PRY", "Paraguay", "1811", "7000000");
INSERT INTO "country" VALUES ("URY", "Uruguay", "1828", "3000000");
INSERT INTO "country" VALUES ("VEN", "Venezuela", "1811", "28000000");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "1919", "40000000");
INSERT INTO "country" VALUES ("ARM", "Armenia", "1991", "3000000");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "1991", "10000000");
INSERT INTO "country" VALUES ("GEO", "Georgia", "1991", "3000000");
INSERT INTO "country" VALUES ("KAZ", "Kazakhstan", "1991", "19000000");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "1991", "6000000");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "1991", "9000000");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "1991", "6000000");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "1991", "34000000");
INSERT INTO "country" VALUES ("BLR", "Belarus", "1991", "9000000");
INSERT INTO "country" VALUES ("MDA", "Moldova", "1991", "2000000");
INSERT INTO "country" VALUES ("UKR", "Ukraine", "1991", "43000000");
INSERT INTO "country" VALUES ("EST", "Estonia", "1991", "1000000");
INSERT INTO "country" VALUES ("LVA", "Latvia", "1991", "1000000");
INSERT INTO "country" VALUES ("LTU", "Lithuania", "1991", "2000000");
INSERT INTO "country" VALUES ("ALB", "Albania", "1912", "2000000");
INSERT INTO "country" VALUES ("BIH", "Bosnia and Herzegovina", "1992", "3000000");
INSERT INTO "country" VALUES ("BGR", "Bulgaria", "1908", "6000000");
INSERT INTO "country" VALUES ("HRV", "Croatia", "1991", "4000000");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "1960", "1000000");
INSERT INTO "country" VALUES ("MKD", "North Macedonia", "1991", "2000000");
INSERT INTO "country" VALUES ("MNE", "Montenegro", "2006", "600000");
INSERT INTO "country" VALUES ("ROU", "Romania", "1877", "19000000");
INSERT INTO "country" VALUES ("SRB", "Serbia", "2006", "7000000");
INSERT INTO "country" VALUES ("SVN", "Slovenia", "1991", "2000000");
INSERT INTO "country" VALUES ("KOS", "Kosovo", "2008", "1000000");
INSERT INTO "country" VALUES ("MLT", "Malta", "1964", "500000");
INSERT INTO "country" VALUES ("ISL", "Iceland", "1944", "300000");
INSERT INTO "country" VALUES ("LUX", "Luxembourg", "1839", "600000");
INSERT INTO "country" VALUES ("MCO", "Monaco", "1861", "30000");
INSERT INTO "country" VALUES ("AND", "Andorra", "1278", "70000");
INSERT INTO "country" VALUES ("SMR", "San Marino", "301", "30000");
INSERT INTO "country" VALUES ("VAT", "Vatican City", "1929", "800");
INSERT INTO "country" VALUES ("LIE", "Liechtenstein", "1806", "30000");
INSERT INTO "country" VALUES ("SXM", "Sint Maarten", "2010", "40000");
INSERT INTO "country" VALUES ("CUW", "Curacao", "2010", "160000");
INSERT INTO "country" VALUES ("ABW", "Aruba", "1986", "100000");
INSERT INTO "country" VALUES ("BHS", "Bahamas", "1973", "400000");
INSERT INTO "country" VALUES ("BRB", "Barbados", "1966", "200000");
INSERT INTO "country" VALUES ("BLZ", "Belize", "1981", "400000");
INSERT INTO "country" VALUES ("DMA", "Dominica", "1978", "70000");
INSERT INTO "country" VALUES ("GRD", "Grenada", "1974", "100000");
INSERT INTO "country" VALUES ("GUY", "Guyana", "1966", "800000");
INSERT INTO "country" VALUES ("KNA", "Saint Kitts and Nevis", "1983", "50000");
INSERT INTO "country" VALUES ("LCA", "Saint Lucia", "1979", "180000");
INSERT INTO "country" VALUES ("VCT", "Saint Vincent and the Grenadines", "1979", "110000");
INSERT INTO "country" VALUES ("SUR", "Suriname", "1975", "600000");
INSERT INTO "country" VALUES ("TTO", "Trinidad and Tobago", "1962", "1000000");
INSERT INTO "country" VALUES ("ATG", "Antigua and Barbuda", "1981", "90000");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "1971", "1000000");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "1961", "4000000");
INSERT INTO "country" VALUES ("OMN", "Oman", "1970", "5000000");
INSERT INTO "country" VALUES ("QAT", "Qatar", "1971", "2000000");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "1971", "9000000");
INSERT INTO "country" VALUES ("YEM", "Yemen", "1990", "30000000");
INSERT INTO "country" VALUES ("JOR", "Jordan", "1946", "10000000");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "1943", "6000000");
INSERT INTO "country" VALUES ("SYR", "Syria", "1946", "17000000");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "1919", "40000000");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "1971", "1000000");
INSERT INTO "country" VALUES ("BTN", "Bhutan", "1907", "700000");
INSERT INTO "country" VALUES ("BRN", "Brunei", "1984", "400000");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "1953", "16000000");
INSERT INTO "country" VALUES ("TLS", "East Timor", "2002", "1000000");
INSERT INTO "country" VALUES ("LAO", "Laos", "1953", "7000000");
INSERT INTO "country" VALUES ("MDV", "Maldives", "1965", "500000");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "1921", "3000000");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "1948", "54000000");
INSERT INTO "country" VALUES ("NPL", "Nepal", "1768", "30000000");
INSERT INTO "country" VALUES ("LKA", "Sri Lanka", "1948", "21000000");
INSERT INTO "country" VALUES ("TWN", "Taiwan", "1912", "23000000");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "1991", "34000000");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "1945", "97000000");
INSERT INTO "country" VALUES ("FJI", "Fiji", "1970", "900000");
INSERT INTO "country" VALUES ("KIR", "Kiribati", "1979", "100000");
INSERT INTO "country" VALUES ("MHL", "Marshall Islands", "1986", "50000");
INSERT INTO "country" VALUES ("FSM", "Micronesia", "1986", "100000");
INSERT INTO "country" VALUES ("NRU", "Nauru", "1968", "10000");
INSERT INTO "country" VALUES ("PLW", "Palau", "1994", "10000");
INSERT INTO "country" VALUES ("PNG", "Papua New Guinea", "1975", "9000000");
INSERT INTO "country" VALUES ("WSM", "Samoa", "1962", "200000");
INSERT INTO "country" VALUES ("SLB", "Solomon Islands", "1978", "700000");
INSERT INTO "country" VALUES ("TON", "Tonga", "1970", "100000");
INSERT INTO "country" VALUES ("TUV", "Tuvalu", "1978", "10000");
INSERT INTO "country" VALUES ("VUT", "Vanuatu", "1980", "300000");
INSERT INTO "countrylanguage" VALUES ("USA", "English", "T");
INSERT INTO "countrylanguage" VALUES ("USA", "Spanish", "F");
INSERT INTO "countrylanguage" VALUES ("GBR", "English", "T");
INSERT INTO "countrylanguage" VALUES ("FRA", "French", "T");
INSERT INTO "countrylanguage" VALUES ("JPN", "Japanese", "T");
INSERT INTO "countrylanguage" VALUES ("CHN", "Mandarin", "T");
INSERT INTO "countrylanguage" VALUES ("DEU", "German", "T");
INSERT INTO "countrylanguage" VALUES ("ITA", "Italian", "T");
INSERT INTO "countrylanguage" VALUES ("ESP", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("RUS", "Russian", "T");
INSERT INTO "countrylanguage" VALUES ("AUS", "English", "T");
INSERT INTO "countrylanguage" VALUES ("CAN", "English", "T");
INSERT INTO "countrylanguage" VALUES ("CAN", "French", "T");
INSERT INTO "countrylanguage" VALUES ("IND", "Hindi", "T");
INSERT INTO "countrylanguage" VALUES ("IND", "English", "F");
INSERT INTO "countrylanguage" VALUES ("BRA", "Portuguese", "T");
INSERT INTO "countrylanguage" VALUES ("MEX", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("EGY", "Arabic", "T");
INSERT INTO "countrylanguage" VALUES ("TUR", "Turkish", "T");
INSERT INTO "countrylanguage" VALUES ("GRC", "Greek", "T");
INSERT INTO "countrylanguage" VALUES ("BEL", "Dutch", "T");
INSERT INTO "countrylanguage" VALUES ("BEL", "French", "T");
INSERT INTO "countrylanguage" VALUES ("BEL", "German", "T");
INSERT INTO "countrylanguage" VALUES ("NLD", "Dutch", "T");
INSERT INTO "countrylanguage" VALUES ("SWE", "Swedish", "T");
INSERT INTO "countrylanguage" VALUES ("NOR", "Norwegian", "T");
INSERT INTO "countrylanguage" VALUES ("DNK", "Danish", "T");
INSERT INTO "countrylanguage" VALUES ("FIN", "Finnish", "T");
INSERT INTO "countrylanguage" VALUES ("FIN", "Swedish", "F");
INSERT INTO "countrylanguage" VALUES ("POL", "Polish", "T");
INSERT INTO "countrylanguage" VALUES ("CZE", "Czech", "T");
INSERT INTO "countrylanguage" VALUES ("SVK", "Slovak", "T");
INSERT INTO "countrylanguage" VALUES ("HUN", "Hungarian", "T");
INSERT INTO "countrylanguage" VALUES ("AUT", "German", "T");
INSERT INTO "countrylanguage" VALUES ("CHE", "German", "T");
INSERT INTO "countrylanguage" VALUES ("CHE", "French", "T");
INSERT INTO "countrylanguage" VALUES ("CHE", "Italian", "T");
INSERT INTO "countrylanguage" VALUES ("PRT", "Portuguese", "T");
INSERT INTO "countrylanguage" VALUES ("IRL", "Irish", "T");
INSERT INTO "countrylanguage" VALUES ("IRL", "English", "F");
INSERT INTO "countrylanguage" VALUES ("ARG", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("CHL", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("COL", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("PER", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("VEN", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("ZAF", "Afrikaans", "T");
INSERT INTO "countrylanguage" VALUES ("ZAF", "English", "T");
INSERT INTO "countrylanguage" VALUES ("NGA", "English", "T");
INSERT INTO "countrylanguage" VALUES ("ETH", "Amharic", "T");
INSERT INTO "countrylanguage" VALUES ("KEN", "Swahili", "T");
INSERT INTO "countrylanguage" VALUES ("KEN", "English", "F");
INSERT INTO "countrylanguage" VALUES ("DZA", "Arabic", "T");
INSERT INTO "countrylanguage" VALUES ("MAR", "Arabic", "T");
INSERT INTO "countrylanguage" VALUES ("SAU", "Arabic", "T");
INSERT INTO "countrylanguage" VALUES ("IRN", "Persian", "T");
INSERT INTO "countrylanguage" VALUES ("IRQ", "Arabic", "T");
INSERT INTO "countrylanguage" VALUES ("ISR", "Hebrew", "T");
INSERT INTO "countrylanguage" VALUES ("ISR", "Arabic", "F");
INSERT INTO "countrylanguage" VALUES ("PAK", "Urdu", "T");
INSERT INTO "countrylanguage" VALUES ("PAK", "English", "F");
INSERT INTO "countrylanguage" VALUES ("BGD", "Bengali", "T");
INSERT INTO "countrylanguage" VALUES ("IDN", "Indonesian", "T");
INSERT INTO "countrylanguage" VALUES ("PHL", "Filipino", "T");
INSERT INTO "countrylanguage" VALUES ("PHL", "English", "F");
INSERT INTO "countrylanguage" VALUES ("VNM", "Vietnamese", "T");
INSERT INTO "countrylanguage" VALUES ("THA", "Thai", "T");
INSERT INTO "countrylanguage" VALUES ("MYS", "Malay", "T");
INSERT INTO "countrylanguage" VALUES ("SGP", "Malay", "T");
INSERT INTO "countrylanguage" VALUES ("SGP", "English", "T");
INSERT INTO "countrylanguage" VALUES ("SGP", "Mandarin", "T");
INSERT INTO "countrylanguage" VALUES ("SGP", "Tamil", "T");
INSERT INTO "countrylanguage" VALUES ("NZL", "English", "T");
INSERT INTO "countrylanguage" VALUES ("NZL", "Maori", "T");
INSERT INTO "countrylanguage" VALUES ("KOR", "Korean", "T");
INSERT INTO "countrylanguage" VALUES ("PRK", "Korean", "T");
INSERT INTO "countrylanguage" VALUES ("CUB", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("DOM", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("HTI", "Haitian Creole", "T");
INSERT INTO "countrylanguage" VALUES ("HTI", "French", "F");
INSERT INTO "countrylanguage" VALUES ("JAM", "English", "T");
INSERT INTO "countrylanguage" VALUES ("CRI", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("PAN", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("GTM", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("HND", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("SLV", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("NIC", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("BOL", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("ECU", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("PRY", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("PRY", "Guarani", "T");
INSERT INTO "countrylanguage" VALUES ("URY", "Spanish", "T");
INSERT INTO "countrylanguage" VALUES ("AFG", "Dari", "T");
INSERT INTO "countrylanguage" VALUES ("AFG", "Pashto", "T");
INSERT INTO "countrylanguage" VALUES ("ARM", "Armenian", "T");
INSERT INTO "countrylanguage" VALUES ("AZE", "Azerbaijani", "T");
INSERT INTO "countrylanguage" VALUES ("GEO", "Georgian", "T");
INSERT INTO "countrylanguage" VALUES ("KAZ", "Kazakh", "T");
INSERT INTO "countrylanguage" VALUES ("KAZ", "Russian", "F");
INSERT INTO "countrylanguage" VALUES ("KGZ", "Kyrgyz", "T");
INSERT INTO "countrylanguage" VALUES ("KGZ", "Russian", "F");
INSERT INTO "countrylanguage" VALUES ("TJK", "Tajik", "T");
INSERT INTO "countrylanguage" VALUES ("TKM", "Turkmen", "T");
INSERT INTO "countrylanguage" VALUES ("UZB", "Uzbek", "T");
INSERT INTO "countrylanguage" VALUES ("BLR", "Belarusian", "T");
INSERT INTO "countrylanguage" VALUES ("BLR", "Russian", "T");
INSERT INTO "countrylanguage" VALUES ("MDA", "Romanian", "T");