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 "people" (
"People_ID" INT,
"Nationality" TEXT,
"Name" TEXT,
PRIMARY KEY ("People_ID")
);





INSERT INTO "people" VALUES ("1", "USA", "Alice");
INSERT INTO "people" VALUES ("2", "Canada", "Bob");
INSERT INTO "people" VALUES ("3", "USA", "Charlie");
INSERT INTO "people" VALUES ("4", "Mexico", "David");
INSERT INTO "people" VALUES ("5", "Canada", "Eve");
INSERT INTO "people" VALUES ("6", "USA", "Frank");
INSERT INTO "people" VALUES ("7", "Germany", "Grace");
INSERT INTO "people" VALUES ("8", "Germany", "Heidi");
INSERT INTO "people" VALUES ("9", "France", "Ivan");
INSERT INTO "people" VALUES ("10", "France", "Julia");
INSERT INTO "people" VALUES ("11", "USA", "Kyle");
INSERT INTO "people" VALUES ("12", "Mexico", "Liam");
INSERT INTO "people" VALUES ("13", "Canada", "Mia");
INSERT INTO "people" VALUES ("14", "Germany", "Noah");
INSERT INTO "people" VALUES ("15", "France", "Olivia");