CREATE TABLE TeamMembers(
   tm_number    INTEGER  NOT NULL PRIMARY KEY 
  ,first_name   VARCHAR(9) NOT NULL
  ,last_name    VARCHAR(15) NOT NULL
  ,job          VARCHAR(24) NOT NULL
  ,hire_date    DATE  NOT NULL
  ,entry_date   DATE  NOT NULL
  ,tl_alignment VARCHAR(4) NOT NULL
);
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76775844,'Aidan','Molina','Guest Advocate','2024-05-03','2024-05-03','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76913928,'Lexi','Erickson','Guest Advocate','2024-10-09','2025-01-05','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76442619,'Amy','Perdomo','Guest Advocate','2022-12-10','2024-09-15','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76422874,'Anali','Policarpo','Guest Advocate','2022-11-21','2023-01-15','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (77021204,'Andrew','Garcia Zambrano','On Demand Guest Advocate','2024-12-04','2025-01-05','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76527328,'Andrew','Michalski','On Demand Guest Advocate','2023-06-17','2023-06-17','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76905547,'Angel','Zazueta','Guest Advocate','2024-10-02','2024-10-02','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76907883,'Audrey','Brown','On Demand Guest Advocate','2024-10-04','2025-01-05','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (72146491,'Austin','Lennon','Front of Store Attendant','2017-09-08','2023-05-21','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (77028687,'Ayelen','Sanchez','On Demand Guest Advocate','2024-12-10','2025-01-05','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (72114242,'Barbara','Logan','Guest Advocate','2017-09-05','2022-07-31','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (71034060,'Benjamin','Sarrasin','Guest Advocate','2017-02-28','2025-01-19','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (77021580,'Bri','Hilario','Guest Advocate','2024-12-04','2025-01-05','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (77024860,'Bryant','Avila','Guest Advocate','2024-12-06','2025-01-05','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76865967,'Cade','Clemons','Guest Advocate','2024-08-23','2024-09-15','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76833886,'Camren','Motamed','On Demand Guest Advocate','2024-07-19','2024-09-15','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (77029608,'Cash','Frederick','Guest Advocate','2024-12-11','2025-01-12','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76904777,'Connor','Hutcheson','Guest Advocate','2024-10-02','2024-10-02','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76791051,'Connor','Muldoon','Front of Store Attendant','2024-05-22','2024-05-22','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76108657,'Cooper','Decair','Front of Store Attendant','2021-12-12','2025-01-05','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (77036400,'Daniel','Kindron','Guest Advocate','2025-01-08','2025-01-08','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (77008763,'Ethan','Kulba','Guest Advocate','2024-11-22','2025-01-05','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76781484,'Evelyn','Velazquez','Guest Advocate','2024-05-08','2025-01-05','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76555905,'Gavin','Van Cleve','Guest Advocate','2023-08-02','2023-08-02','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76623927,'Grace','Santillan','Guest Advocate','2023-10-13','2024-08-18','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76884684,'Gunner','Bareng','Front of Store Attendant','2024-09-11','2024-09-11','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76984983,'Heidi','Skiles','Guest Advocate','2024-11-12','2025-01-05','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76501038,'Jason','Lewandowski','Guest Advocate','2023-05-02','2024-07-07','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (77015331,'Jenna','Fomenko','Guest Advocate','2024-11-26','2025-01-05','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (75205141,'Julie','Pompei','On Demand Guest Advocate','2019-12-01','2024-09-29','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76363591,'Katherine','Margiotta','Guest Advocate','2022-10-23','2023-05-21','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (71284020,'KATHLEEN','FLAGG','On Demand Guest Advocate','2017-05-02','2024-09-29','Erik');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (77003306,'Kevin','De La Puente','Guest Advocate','2024-11-19','2025-01-05','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76714903,'Koston','Snavely','Guest Advocate','2023-12-11','2024-10-20','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76856442,'Laney','Hansell','Guest Advocate','2024-08-14','2024-08-14','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76828247,'Lisa','Hart','Guest Advocate','2024-07-12','2024-07-12','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76584272,'Marc','Cordero','Front of Store Attendant','2023-09-01','2023-09-01','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (75388398,'Margot','Gonzales','Guest Advocate','2020-09-12','2020-09-12','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76758910,'Maria','Boero','On Demand Guest Advocate','2024-03-29','2024-09-29','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76705084,'Maria','Camarillo','Guest Advocate','2023-12-01','2024-01-07','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76977220,'Max','Hernandez','Guest Advocate','2024-11-08','2025-01-05','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (77024842,'Mea','Marvin','Guest Advocate','2024-12-13','2025-01-05','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76810752,'Megan','Hall','Guest Advocate','2024-06-19','2024-06-19','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (75243489,'Michael','Bennett','Guest Advocate','2020-03-20','2020-03-20','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76173697,'Mika','Ishii','Guest Advocate','2022-04-18','2022-04-18','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (77014167,'Natalie','Gonzales','Guest Advocate','2024-11-26','2025-01-05','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76181310,'Natasha','Akroush','Guest Advocate','2022-05-01','2022-05-01','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76800496,'Nathan','Valdez','On Demand Guest Advocate','2024-06-05','2024-09-01','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76531610,'Nicholas','Hunt','Guest Advocate','2023-06-17','2024-10-20','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76390510,'Nicole','Grummer','Guest Advocate','2022-11-06','2025-01-05','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76670583,'Nolan','Giesbrecht','Guest Advocate','2023-11-07','2024-01-07','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (75374017,'Randy','Rutman','Guest Advocate','2020-08-30','2022-04-10','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (62858592,'Ryan','Candelaria','Front of Store Attendant','2013-09-03','2013-09-03','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76326447,'Ryder','Erickson','Guest Advocate','2022-10-08','2024-01-07','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76669890,'Samuel','Viveros','Guest Advocate','2023-11-08','2024-07-21','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (66033549,'Sangeeta','Jambusaria','Guest Advocate','2014-11-24','2019-06-02','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76469957,'Shawn','Lockhart','Front of Store Attendant','2023-03-01','2023-09-24','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (77019594,'Sofia','Martinez','Guest Advocate','2024-12-03','2025-01-05','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76863811,'Taylor','Murphy','Guest Advocate','2024-08-23','2024-08-23','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (7965585,'Veronica','Delorenzo','Guest Advocate','1989-08-31','2024-12-15','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (75199918,'Vincent','Trinh','Guest Advocate','2019-11-23','2024-01-07','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76297674,'Vincent','Mazza','Guest Advocate','2022-09-10','2022-09-10','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76717454,'Wyatt','Murdy','On Demand Guest Advocate','2023-12-13','2023-12-31','Benn');
INSERT INTO TeamMembers(tm_number,first_name,last_name,job,hire_date,entry_date,tl_alignment) VALUES (76413445,'Xia','Hou','Guest Advocate','2022-11-16','2024-07-21','Benn');
