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 "Students" (
"student_id" INT,
"first_name" VARCHAR(80),
"middle_name" VARCHAR(40),
"last_name" VARCHAR(40),
"cell_mobile_number" VARCHAR(40),
"email_address" VARCHAR(40),
"date_first_registered" DATETIME,
"date_left" DATETIME,
PRIMARY KEY ("student_id")
);





INSERT INTO "Students" VALUES ("1", "Alice", "M", "Smith", "111-222-3333", "alice.smith@example.com", "2010-09-01", "2014-05-15");
INSERT INTO "Students" VALUES ("2", "Bob", "J", "Johnson", "444-555-6666", "bob.j@example.com", "2011-09-01", "2015-05-20");
INSERT INTO "Students" VALUES ("3", "Charlie", "NULL", "Brown", "777-888-9999", "charlie.b@example.com", "2010-09-01", "2014-05-10");
INSERT INTO "Students" VALUES ("4", "Diana", "L", "Prince", "123-456-7890", "diana.p@example.com", "2012-09-01", "2016-05-25");
INSERT INTO "Students" VALUES ("5", "Eve", "K", "Davis", "987-654-3210", "eve.d@example.com", "2011-09-01", "2015-05-18");
INSERT INTO "Students" VALUES ("6", "Frank", "NULL", "Miller", "555-111-2222", "frank.m@example.com", "2013-09-01", "NULL");
INSERT INTO "Students" VALUES ("7", "Grace", "A", "Taylor", "333-444-5555", "grace.t@example.com", "2010-09-01", "2014-05-10");
INSERT INTO "Students" VALUES ("8", "Henry", "P", "Wilson", "666-777-8888", "henry.w@example.com", "2012-09-01", "2016-05-20");
INSERT INTO "Students" VALUES ("9", "Ivy", "NULL", "Moore", "222-333-4444", "ivy.m@example.com", "2011-09-01", "2015-05-15");
INSERT INTO "Students" VALUES ("10", "Jack", "R", "White", "000-111-2222", "jack.w@example.com", "2013-09-01", "2017-05-30");
INSERT INTO "Students" VALUES ("11", "Karen", "S", "Green", "999-888-7777", "karen.g@example.com", "2010-09-01", "2014-05-09");
INSERT INTO "Students" VALUES ("12", "Liam", "NULL", "Black", "111-000-9999", "liam.b@example.com", "2014-09-01", "NULL");