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", "France", "Heidi");
INSERT INTO "people" VALUES ("9", "Germany", "Ivan");
INSERT INTO "people" VALUES ("10", "USA", "Judy");
INSERT INTO "people" VALUES ("11", "UK", "Kyle");
INSERT INTO "people" VALUES ("12", "UK", "Liam");
INSERT INTO "people" VALUES ("13", "Australia", "Mia");
INSERT INTO "people" VALUES ("14", "Australia", "Noah");
INSERT INTO "people" VALUES ("15", "Japan", "Olivia");
INSERT INTO "people" VALUES ("16", "Japan", "Peter");
INSERT INTO "people" VALUES ("17", "China", "Quinn");
INSERT INTO "people" VALUES ("18", "China", "Rachel");
INSERT INTO "people" VALUES ("19", "India", "Sam");
INSERT INTO "people" VALUES ("20", "India", "Tina");