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),
"SurfaceArea" FLOAT,
"IndepYear" INT,
"Population" INT,
"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", "500000");
INSERT INTO "city" VALUES ("2", "1500000");
INSERT INTO "city" VALUES ("3", "300000");
INSERT INTO "city" VALUES ("4", "100000");
INSERT INTO "city" VALUES ("5", "750000");
INSERT INTO "city" VALUES ("6", "200000");
INSERT INTO "city" VALUES ("7", "1200000");
INSERT INTO "city" VALUES ("8", "400000");
INSERT INTO "city" VALUES ("9", "90000");
INSERT INTO "city" VALUES ("10", "250000");
INSERT INTO "country" VALUES ("AAA", "Alphaland", "123456.78", "1950", "1000000", "75.5");
INSERT INTO "country" VALUES ("BBB", "Betatown", "234567.89", "1900", "500000", "70.2");
INSERT INTO "country" VALUES ("CCC", "Gammaria", "345678.90", "1800", "2000000", "80.1");
INSERT INTO "country" VALUES ("DDD", "Deltora", "456789.01", "2000", "300000", "65.0");
INSERT INTO "country" VALUES ("EEE", "Epsilonia", "567890.12", "1850", "300000", "68.3");
INSERT INTO "country" VALUES ("FFF", "Zetania", "678901.23", "1750", "90000", "72.0");
INSERT INTO "country" VALUES ("GGG", "Etaland", "789012.34", "1955", "1200000", "77.7");
INSERT INTO "countrylanguage" VALUES ("AAA", "English", "80.0");
INSERT INTO "countrylanguage" VALUES ("AAA", "French", "20.0");
INSERT INTO "countrylanguage" VALUES ("BBB", "Spanish", "90.0");
INSERT INTO "countrylanguage" VALUES ("BBB", "English", "10.0");
INSERT INTO "countrylanguage" VALUES ("CCC", "German", "100.0");
INSERT INTO "countrylanguage" VALUES ("DDD", "Italian", "60.0");
INSERT INTO "countrylanguage" VALUES ("DDD", "English", "40.0");
INSERT INTO "countrylanguage" VALUES ("EEE", "Portuguese", "100.0");
INSERT INTO "countrylanguage" VALUES ("FFF", "Dutch", "100.0");
INSERT INTO "countrylanguage" VALUES ("GGG", "Russian", "50.0");
INSERT INTO "countrylanguage" VALUES ("GGG", "English", "50.0");