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),
"Name" CHAR(52),
"Population" INT,
"LifeExpectancy" FLOAT,
PRIMARY KEY ("Code")
);





INSERT INTO "country" VALUES ("BRA", "Brazil", "215000000", "75.5");
INSERT INTO "country" VALUES ("USA", "United States", "330000000", "78.5");
INSERT INTO "country" VALUES ("CAN", "Canada", "38000000", "82.0");
INSERT INTO "country" VALUES ("MEX", "Mexico", "128000000", "75.0");
INSERT INTO "country" VALUES ("ARG", "Argentina", "45000000", "76.0");
INSERT INTO "country" VALUES ("COL", "Colombia", "51000000", "77.0");
INSERT INTO "country" VALUES ("PER", "Peru", "33000000", "74.0");
INSERT INTO "country" VALUES ("CHL", "Chile", "19000000", "80.0");
INSERT INTO "country" VALUES ("ECU", "Ecuador", "18000000", "76.5");
INSERT INTO "country" VALUES ("VEN", "Venezuela", "28000000", "72.0");