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 "country" (
"Code" CHAR(3),
"Continent" TEXT,
"Population" INT,
"LifeExpectancy" FLOAT,
PRIMARY KEY ("Code")
);





INSERT INTO "country" VALUES ("AFG", "Asia", "22720000", "45.9");
INSERT INTO "country" VALUES ("NLD", "Europe", "15987000", "78.3");
INSERT INTO "country" VALUES ("ALB", "Europe", "3401200", "71.5");
INSERT INTO "country" VALUES ("DZA", "Africa", "31471000", "69.7");
INSERT INTO "country" VALUES ("ASM", "Oceania", "68000", "75.1");
INSERT INTO "country" VALUES ("AND", "Europe", "78000", "83.5");
INSERT INTO "country" VALUES ("AGO", "Africa", "12878000", "38.3");
INSERT INTO "country" VALUES ("AIA", "North America", "8000", "76.1");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "0", "NULL");
INSERT INTO "country" VALUES ("ATG", "North America", "68000", "70.5");
INSERT INTO "country" VALUES ("ARG", "South America", "37032000", "75.1");
INSERT INTO "country" VALUES ("ARM", "Asia", "3520000", "66.4");
INSERT INTO "country" VALUES ("ABW", "North America", "103000", "78.4");
INSERT INTO "country" VALUES ("AUS", "Oceania", "18886000", "79.8");
INSERT INTO "country" VALUES ("AUT", "Europe", "8078900", "78.7");
INSERT INTO "country" VALUES ("AZE", "Asia", "7734000", "62.9");
INSERT INTO "country" VALUES ("BHS", "North America", "307000", "71.1");
INSERT INTO "country" VALUES ("BHR", "Asia", "617000", "74.7");
INSERT INTO "country" VALUES ("BGD", "Asia", "129155000", "60.2");
INSERT INTO "country" VALUES ("BRB", "North America", "270000", "73.0");
INSERT INTO "country" VALUES ("BLR", "Europe", "10236000", "68.0");
INSERT INTO "country" VALUES ("BEL", "Europe", "10239000", "77.8");
INSERT INTO "country" VALUES ("BLZ", "North America", "241000", "70.9");
INSERT INTO "country" VALUES ("BEN", "Africa", "6097000", "50.4");
INSERT INTO "country" VALUES ("BMU", "North America", "65000", "76.9");