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

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

CREATE TABLE "countrylanguage" (
"CountryCode" CHAR(3),
"Language" CHAR(30),
"Percentage" FLOAT,
PRIMARY KEY ("CountryCode", "Language")
);





INSERT INTO "city" VALUES ("1", "14000000");
INSERT INTO "city" VALUES ("2", "9000000");
INSERT INTO "city" VALUES ("3", "12000000");
INSERT INTO "city" VALUES ("4", "5000000");
INSERT INTO "city" VALUES ("5", "3000000");
INSERT INTO "city" VALUES ("6", "7000000");
INSERT INTO "city" VALUES ("7", "4000000");
INSERT INTO "city" VALUES ("8", "6000000");
INSERT INTO "city" VALUES ("9", "2000000");
INSERT INTO "city" VALUES ("10", "1000000");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "Eastern Asia", "77.3");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "Southern Asia", "69.7");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "Eastern Asia", "84.5");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "Asia", "Southern Asia", "67.3");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "Southern Asia", "72.6");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Asia", "Eastern Asia", "83.0");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "Asia", "South-Eastern Asia", "75.4");
INSERT INTO "country" VALUES ("NPL", "Nepal", "Asia", "Southern Asia", "70.0");
INSERT INTO "country" VALUES ("LAO", "Laos", "Asia", "South-Eastern Asia", "67.3");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "Asia", "Eastern Asia", "69.5");
INSERT INTO "country" VALUES ("THA", "Thailand", "Asia", "South-Eastern Asia", "75.0");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "Asia", "South-Eastern Asia", "65.8");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "Southern Asia", "60.5");
INSERT INTO "country" VALUES ("IRQ", "Iraq", "Asia", "Western Asia", "70.6");
INSERT INTO "country" VALUES ("SYR", "Syria", "Asia", "Western Asia", "71.0");
INSERT INTO "country" VALUES ("ISR", "Israel", "Asia", "Western Asia", "82.7");
INSERT INTO "country" VALUES ("TUR", "Turkey", "Asia", "Western Asia", "75.9");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Asia", "Western Asia", "75.1");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Asia", "Western Asia", "73.5");
INSERT INTO "country" VALUES ("YEM", "Yemen", "Asia", "Western Asia", "65.0");
INSERT INTO "countrylanguage" VALUES ("CHN", "Mandarin", "70.0");
INSERT INTO "countrylanguage" VALUES ("CHN", "Cantonese", "5.0");
INSERT INTO "countrylanguage" VALUES ("IND", "Hindi", "41.0");
INSERT INTO "countrylanguage" VALUES ("IND", "English", "12.0");
INSERT INTO "countrylanguage" VALUES ("JPN", "Japanese", "99.0");
INSERT INTO "countrylanguage" VALUES ("PAK", "Urdu", "8.0");
INSERT INTO "countrylanguage" VALUES ("PAK", "Punjabi", "44.0");
INSERT INTO "countrylanguage" VALUES ("BGD", "Bengali", "98.0");
INSERT INTO "countrylanguage" VALUES ("KOR", "Korean", "100.0");
INSERT INTO "countrylanguage" VALUES ("VNM", "Vietnamese", "86.0");
INSERT INTO "countrylanguage" VALUES ("NPL", "Nepali", "44.0");
INSERT INTO "countrylanguage" VALUES ("LAO", "Lao", "55.0");
INSERT INTO "countrylanguage" VALUES ("MNG", "Mongolian", "95.0");
INSERT INTO "countrylanguage" VALUES ("THA", "Thai", "90.0");
INSERT INTO "countrylanguage" VALUES ("KHM", "Khmer", "96.0");
INSERT INTO "countrylanguage" VALUES ("AFG", "Pashto", "50.0");
INSERT INTO "countrylanguage" VALUES ("AFG", "Dari", "35.0");
INSERT INTO "countrylanguage" VALUES ("IRQ", "Arabic", "75.0");
INSERT INTO "countrylanguage" VALUES ("IRQ", "Kurdish", "20.0");
INSERT INTO "countrylanguage" VALUES ("SYR", "Arabic", "90.0");
INSERT INTO "countrylanguage" VALUES ("ISR", "Hebrew", "53.0");
INSERT INTO "countrylanguage" VALUES ("ISR", "Arabic", "20.0");
INSERT INTO "countrylanguage" VALUES ("TUR", "Turkish", "85.0");
INSERT INTO "countrylanguage" VALUES ("ARM", "Armenian", "97.0");
INSERT INTO "countrylanguage" VALUES ("GEO", "Georgian", "87.0");
INSERT INTO "countrylanguage" VALUES ("YEM", "Arabic", "99.0");