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", "USA", "Eve");
INSERT INTO "people" VALUES ("6", "Canada", "Frank");
INSERT INTO "people" VALUES ("7", "USA", "Grace");
INSERT INTO "people" VALUES ("8", "UK", "Heidi");
INSERT INTO "people" VALUES ("9", "USA", "Ivan");
INSERT INTO "people" VALUES ("10", "Canada", "Judy");
INSERT INTO "people" VALUES ("11", "UK", "Kevin");
INSERT INTO "people" VALUES ("12", "Mexico", "Liam");
INSERT INTO "people" VALUES ("13", "USA", "Mia");
INSERT INTO "people" VALUES ("14", "Canada", "Noah");
INSERT INTO "people" VALUES ("15", "USA", "Olivia");
INSERT INTO "people" VALUES ("16", "Germany", "Paul");
INSERT INTO "people" VALUES ("17", "Germany", "Quinn");
INSERT INTO "people" VALUES ("18", "France", "Rachel");
INSERT INTO "people" VALUES ("19", "France", "Sam");
INSERT INTO "people" VALUES ("20", "USA", "Tina");