CREATE TABLE IF NOT EXISTS school."students" (
    "id" INT,
    "first_name" TEXT,
    "last_name" TEXT,
    "email" TEXT,
    "class_id" INT,
	PRIMARY KEY("id"),
	FOREIGN KEY("class_id") REFERENCES school."classes"("id")
);
INSERT INTO school."students" VALUES
    (74262,'Berry','Bartelson','Berry.Bartelson@gsnail.com',3),
    (67047,'Pearlie','Palomar','PP7361@gsnail.com',4),
    (42490,'Tillie','Brinlee','TillieBrinlee10@gsnail.com',4),
    (33442,'Malika','Giannetti','Malika.Giannetti@gsnail.com',2),
    (82591,'Collen','Margis','CMargis1980@gsnail.com',2),
    (61559,'Leigha','Mani','LM1846@gsnail.com',4),
    (19006,'Cristi','Funderburk','CFunderburk1988@coldmail.com',4),
    (52156,'Arcelia','Rendler','ArceliaRendler75@gsnail.com',2),
    (51370,'Penelope','Skemp','Penelope.Skemp@gsnail.com',3),
    (53818,'Breana','Pree','Breana.Pree@coldmail.com',3),
    (45985,'Emelia','Shum','EShum1988@gsnail.com',1),
    (92215,'Aurora','Flavors','AuroraFlavors39@gsnail.com',2),
    (91494,'Ali','Roskop','AR5364@gsnail.com',4),
    (53042,'Lidia','Ashfield','LidiaAshfield31@gsnail.com',1),
    (48447,'Edwin','Voigtlander','EdwinVoigtlander24@gsnail.com',1),
    (88153,'Cleo','Delaurie','CD5205@gsnail.com',4),
    (25862,'Larita','Wadden','LW6686@gsnail.com',4),
    (54061,'Eric','Ximenez','EXimenez1990@inlook.com',1),
    (48361,'Maricela','Haith','MHaith1990@gsnail.com',3),
    (52074,'Lanny','Doop','Lanny.Doop@gsnail.com',4),
    (70627,'Jack','Haney','Jack.Haney@coldmail.com',1),
    (76849,'Faustina','Marchello','FM9997@gsnail.com',3),
    (96009,'Kirstin','Kahre','KKahre1981@gsnail.com',4),
    (38832,'Minda','Oberlander','MindaOberlander44@inlook.com',1),
    (35699,'Kazuko','Buddemeyer','Kazuko.Buddemeyer@gsnail.com',1),
    (76884,'Clare','Lauretta','CL9794@gsnail.com',3),
    (14847,'Tangela','Sadorra','TSadorra1974@gsnail.com',4),
    (78983,'Maura','Bynoe','MauraBynoe51@gsnail.com',3),
    (47189,'Cammy','Aden','CA4745@gsnail.com',2),
    (71067,'Celinda','Lummis','CLummis1990@gsnail.com',4),
    (21361,'Flor','Rittie','FlorRittie1@gsnail.com',1),
    (95241,'Gisele','Bethea','Gisele.Bethea@gsnail.com',3),
    (55867,'Adrien','Siggins','ASiggins1999@gsnail.com',4),
    (57470,'Jefferey','Gribbins','JeffereyGribbins97@gsnail.com',4),
    (99176,'Heike','Granado','HGranado1971@gsnail.com',4),
    (91373,'Freddie','Cherwinski','Freddie.Cherwinski@gsnail.com',3),
    (24749,'Aura','Longin','Aura.Longin@gsnail.com',1),
    (87158,'Kala','Hathorne','KalaHathorne20@gsnail.com',4),
    (10442,'Fern','Buchbinder','FBuchbinder1982@gsnail.com',3),
    (82898,'Patrick','Barbella','PB9978@gsnail.com',1),
    (11752,'Arnita','Castera','AC2289@gsnail.com',1),
    (12572,'Maynard','Gunia','MG8854@gsnail.com',4),
    (30226,'Meghann','Mortland','MeghannMortland40@gsnail.com',3),
    (86455,'Delmer','Knightly','DKnightly1972@yoohoo.com',4),
    (26320,'Lucille','Delongis','Lucille.Delongis@gsnail.com',4),
    (86095,'Kelly','Dabadie','Kelly.Dabadie@inlook.com',1),
    (60546,'Dorthea','Breeding','DBreeding1990@gsnail.com',4),
    (17547,'Angela','Kimber','Angela.Kimber@gsnail.com',3),
    (68193,'Marci','Jenness','MJenness1999@gsnail.com',1),
    (22097,'Loria','Bordon','LBordon1990@gsnail.com',4);
