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", "123-456-7890", "alice.smith@example.com", "2023-01-15 10:00:00", "2023-12-01 15:30:00");
INSERT INTO "Students" VALUES ("2", "Bob", "", "Johnson", "987-654-3210", "bob.j@example.com", "2023-01-15 10:05:00", "2023-11-20 11:00:00");
INSERT INTO "Students" VALUES ("3", "Charlie", "D.", "Brown", "555-123-4567", "charlie.b@example.com", "2023-01-16 09:00:00", "NULL");
INSERT INTO "Students" VALUES ("4", "Diana", "L.", "Miller", "111-222-3333", "diana.m@example.com", "2023-01-14 14:30:00", "2023-10-10 09:00:00");
INSERT INTO "Students" VALUES ("5", "Eve", "", "Davis", "444-555-6666", "eve.d@example.com", "2023-01-15 09:59:59", "NULL");
INSERT INTO "Students" VALUES ("6", "Frank", "P.", "Garcia", "777-888-9999", "frank.g@example.com", "2023-01-17 11:00:00", "2023-09-01 16:00:00");
INSERT INTO "Students" VALUES ("7", "Grace", "A.", "Rodriguez", "222-333-4444", "grace.r@example.com", "2023-01-15 10:00:01", "NULL");
INSERT INTO "Students" VALUES ("8", "Henry", "", "Martinez", "666-777-8888", "henry.m@example.com", "2023-01-14 14:29:59", "2023-08-15 10:00:00");
INSERT INTO "Students" VALUES ("9", "Ivy", "K.", "Hernandez", "999-000-1111", "ivy.h@example.com", "2023-01-18 12:00:00", "NULL");
INSERT INTO "Students" VALUES ("10", "Jack", "", "Lopez", "333-444-5555", "jack.l@example.com", "2023-01-15 10:00:00", "2023-07-01 14:00:00");