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", "Kabul", "1780000");
INSERT INTO "city" VALUES ("2", "Qandahar", "237500");
INSERT INTO "city" VALUES ("3", "Herat", "186800");
INSERT INTO "city" VALUES ("4", "Mazar-e-Sharif", "237600");
INSERT INTO "city" VALUES ("5", "Amsterdam", "731200");
INSERT INTO "city" VALUES ("6", "Rotterdam", "593321");
INSERT INTO "city" VALUES ("7", "The Hague", "440900");
INSERT INTO "city" VALUES ("8", "Utrecht", "234323");
INSERT INTO "city" VALUES ("9", "Eindhoven", "201843");
INSERT INTO "city" VALUES ("10", "Groningen", "172700");
INSERT INTO "city" VALUES ("11", "Tehran", "7711230");
INSERT INTO "city" VALUES ("12", "Mashhad", "1887300");
INSERT INTO "city" VALUES ("13", "Esfahan", "1266072");
INSERT INTO "city" VALUES ("14", "Tabriz", "1191713");
INSERT INTO "city" VALUES ("15", "Shiraz", "1053025");
INSERT INTO "city" VALUES ("16", "Karaj", "940968");
INSERT INTO "city" VALUES ("17", "Qom", "777677");
INSERT INTO "city" VALUES ("18", "Ahvaz", "773444");
INSERT INTO "city" VALUES ("19", "Kermanshah", "692983");
INSERT INTO "city" VALUES ("20", "Urmia", "435200");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "22720000", "45.9");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "Europe", "15864000", "78.3");
INSERT INTO "country" VALUES ("IRN", "Iran", "Asia", "67151000", "69.5");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "126714000", "80.7");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "1013662000", "62.5");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "1277558000", "71.4");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "Asia", "156483000", "61.1");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "129155000", "60.2");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "Asia", "212107000", "68.0");
INSERT INTO "country" VALUES ("PHL", "Philippines", "Asia", "77621000", "67.0");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "Asia", "79832000", "69.3");
INSERT INTO "country" VALUES ("LAO", "Laos", "Asia", "5493000", "53.1");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "Asia", "11168000", "55.3");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "Asia", "45611000", "54.9");
INSERT INTO "country" VALUES ("PRK", "North Korea", "Asia", "23968000", "70.7");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Asia", "46844000", "74.4");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "Asia", "2654000", "67.3");
INSERT INTO "country" VALUES ("NPL", "Nepal", "Asia", "23949000", "57.8");
INSERT INTO "country" VALUES ("BTN", "Bhutan", "Asia", "2124000", "52.4");
INSERT INTO "country" VALUES ("LKA", "Sri Lanka", "Asia", "18827000", "71.5");
INSERT INTO "country" VALUES ("MDV", "Maldives", "Asia", "311000", "66.0");
INSERT INTO "country" VALUES ("TLS", "East Timor", "Asia", "885000", "46.0");
INSERT INTO "country" VALUES ("YEM", "Yemen", "Asia", "18112000", "59.8");
INSERT INTO "country" VALUES ("OMN", "Oman", "Asia", "2441000", "73.4");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "Asia", "21607000", "67.8");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "Asia", "2441000", "74.1");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Asia", "769000", "72.4");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "Asia", "617000", "73.0");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "Asia", "1972000", "74.9");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "Asia", "23115000", "66.5");
INSERT INTO "country" VALUES ("SYR", "Syria", "Asia", "16227000", "68.5");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "Asia", "3286000", "71.3");
INSERT INTO "country" VALUES ("JOR", "Jordan", "Asia", "4828000", "71.3");
INSERT INTO "country" VALUES ("ISR", "Israel", "Asia", "6217000", "78.6");
INSERT INTO "country" VALUES ("PSE", "Palestine", "Asia", "3112000", "71.4");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "Asia", "787000", "76.7");
INSERT INTO "country" VALUES ("TUR", "Turkey", "Asia", "66591000", "71.8");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Asia", "3520000", "66.1");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "Asia", "7734000", "62.9");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Asia", "5404000", "64.5");
INSERT INTO "country" VALUES ("KAZ", "Kazakhstan", "Asia", "16223000", "63.2");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "24318000", "63.7");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "Asia", "4518000", "60.9");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "Asia", "4699000", "63.4");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "Asia", "6188000", "63.7");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Asia", "3567000", "80.1");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "Asia", "22244000", "72.2");
INSERT INTO "country" VALUES ("BRN", "Brunei", "Asia", "336000", "73.6");
INSERT INTO "country" VALUES ("THA", "Thailand", "Asia", "61399000", "69.1");
INSERT INTO "country" VALUES ("TWN", "Taiwan", "Asia", "22283000", "76.4");
INSERT INTO "country" VALUES ("HKG", "Hong Kong", "Asia", "6782000", "79.5");
INSERT INTO "country" VALUES ("MAC", "Macao", "Asia", "473000", "81.6");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "Asia", "2441000", "74.1");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Asia", "769000", "72.4");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "Asia", "617000", "73.0");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "Asia", "1972000", "74.9");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "Asia", "23115000", "66.5");
INSERT INTO "country" VALUES ("SYR", "Syria", "Asia", "16227000", "68.5");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "Asia", "3286000", "71.3");
INSERT INTO "country" VALUES ("JOR", "Jordan", "Asia", "4828000", "71.3");
INSERT INTO "country" VALUES ("ISR", "Israel", "Asia", "6217000", "78.6");
INSERT INTO "country" VALUES ("PSE", "Palestine", "Asia", "3112000", "71.4");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "Asia", "787000", "76.7");
INSERT INTO "country" VALUES ("TUR", "Turkey", "Asia", "66591000", "71.8");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Asia", "3520000", "66.1");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "Asia", "7734000", "62.9");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Asia", "5404000", "64.5");
INSERT INTO "country" VALUES ("KAZ", "Kazakhstan", "Asia", "16223000", "63.2");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "24318000", "63.7");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "Asia", "4518000", "60.9");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "Asia", "4699000", "63.4");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "Asia", "6188000", "63.7");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Asia", "3567000", "80.1");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "Asia", "22244000", "72.2");
INSERT INTO "country" VALUES ("BRN", "Brunei", "Asia", "336000", "73.6");
INSERT INTO "country" VALUES ("THA", "Thailand", "Asia", "61399000", "69.1");
INSERT INTO "country" VALUES ("TWN", "Taiwan", "Asia", "22283000", "76.4");
INSERT INTO "country" VALUES ("HKG", "Hong Kong", "Asia", "6782000", "79.5");
INSERT INTO "country" VALUES ("MAC", "Macao", "Asia", "473000", "81.6");