CREATE TABLE EMPLOYEE (
E_NUM int,
E_TITLE varchar(4),
E_LNAME varchar(15),
E_FNAME varchar(15),
E_INIT varchar(1),
E_DOB datetime,
E_HIRED datetime,
E_AREACODE varchar(3),
E_PHONE varchar(8),
E_MGR INT
);
INSERT INTO EMPLOYEE VALUES('100','Mr.','Kolmycz','George','D','1942-6-15','1985-3-15','615','324-5456', NULL);
INSERT INTO EMPLOYEE VALUES('101','Ms.','Lewis','Rhonda','G','1965-3-19','1986-4-25','615','324-4472', 100);
INSERT INTO EMPLOYEE VALUES('102','Mr.','VanDam','Rhett','','1958-11-14','1990-12-20','901','675-8993', 100);
INSERT INTO EMPLOYEE VALUES('103','Ms.','Jones','Anne','M','1974-10-16','1994-8-28','615','898-3456', 100);
INSERT INTO EMPLOYEE VALUES('104','Mr.','Lange','John','P','1971-11-8','1994-10-20','901','504-4430', 105);
INSERT INTO EMPLOYEE VALUES('105','Mr.','Williams','Robert','D','1975-3-14','1998-11-8','615','890-3220', NULL);
INSERT INTO EMPLOYEE VALUES('106','Mrs.','Smith','Jeanine','K','1968-2-12','1989-1-5','615','324-7883', 105);
INSERT INTO EMPLOYEE VALUES('107','Mr.','Diante','Jorge','D','1974-8-21','1994-7-2','615','890-4567', 105);
INSERT INTO EMPLOYEE VALUES('108','Mr.','Wiesenbach','Paul','R','1966-2-14','1992-11-18','615','897-4358', NULL);
INSERT INTO EMPLOYEE VALUES('109','Mr.','Smith','George','K','1961-6-18','1989-4-14','901','504-3339', 108);
INSERT INTO EMPLOYEE VALUES('110','Mrs.','Genkazi','Leighla','W','1970-5-19','1990-12-1','901','569-0093', 108);
INSERT INTO EMPLOYEE VALUES('111','Mr.','Washington','Rupert','E','1966-1-3','1993-6-21','615','890-4925', 105);
INSERT INTO EMPLOYEE VALUES('112','Mr.','Johnson','Edward','E','1961-5-14','1983-12-1','615','898-4387', 100);
INSERT INTO EMPLOYEE VALUES('113','Ms.','Smythe','Melanie','P','1970-9-15','1999-5-11','615','324-9006', 105);
INSERT INTO EMPLOYEE VALUES('114','Ms.','Brandon','Marie','G','1956-11-2','1979-11-15','901','882-0845', 108);
INSERT INTO EMPLOYEE VALUES('115','Mrs.','Saranda','Hermine','R','1972-7-25','1993-4-23','615','324-5505', 105);
INSERT INTO EMPLOYEE VALUES('116','Mr.','Smith','George','A','1965-11-8','1988-12-10','615','890-2984', 108);