ADD SAMPLE DATA TO EMPLOYEES TABLE

INSERT INTO EMPLOYEES (EMPLOYEEID, FIRSTNAME, LASTNAME, DATEOFBIRTH, SIN#, MONTHLYSALARY, YEARLYBONUS, POSITION, EMPLOYEMENTDATE)

VALUES (5259876, ‘SARAH’, ‘FISHER’, ‘1988-07-31’, 987600555, 3000.00, NULL, ‘FRONT DESK STAFF’, ‘2016-05-23’);

INSERT INTO EMPLOYEES (EMPLOYEEID, FIRSTNAME, LASTNAME, DATEOFBIRTH, SIN#, MONTHLYSALARY, YEARLYBONUS, POSITION, EMPLOYEMENTDATE)

VALUES (5258765, ‘REBECCA’, ‘SIMPSONS’, ‘1990-08-22’, 876500345, 3100.00, 1350.00, ‘FRONT DESK STAFF’, ‘2015-05-23’);

INSERT INTO EMPLOYEES (EMPLOYEEID, FIRSTNAME, LASTNAME, DATEOFBIRTH, SIN#, MONTHLYSALARY, YEARLYBONUS, POSITION, EMPLOYEMENTDATE)

VALUES (5257654, ‘MICHELE’, ‘PFIFFER’, ‘1978-03-28’, 765400234, 4500.00, 2500.00, ‘SUPERVISOR’, ‘2011-08-29’);

INSERT INTO EMPLOYEES (EMPLOYEEID, FIRSTNAME, LASTNAME, DATEOFBIRTH, SIN#, MONTHLYSALARY, YEARLYBONUS, POSITION, EMPLOYEMENTDATE)

VALUES (5256543, ‘MICHAEL’, ‘JORDAN’, ‘1970-07-26’, 654300123, 5500.00, 3700.00, ‘MANAGER’, ‘2000-09-24’);

INSERT INTO EMPLOYEES (EMPLOYEEID, FIRSTNAME, LASTNAME, DATEOFBIRTH, SIN#, MONTHLYSALARY, YEARLYBONUS, POSITION, EMPLOYEMENTDATE)

VALUES (7885432, ‘SHIRLEY’, ‘VALENTINE’, ‘1990-08-26’, 543200345, 2900.00, 1100.00, ‘FRONT DESK STAFF’, ‘2016-05-23’);

INSERT INTO EMPLOYEES (EMPLOYEEID, FIRSTNAME, LASTNAME, DATEOFBIRTH, SIN#, MONTHLYSALARY, YEARLYBONUS, POSITION, EMPLOYEMENTDATE)

VALUES (7884321, ‘SARAH’, ‘MCDONALDS’, ‘1978-09-28’, 432100234, 4200.00, 2450.00, ‘SUPERVISOR’, ‘2016-02-28’);

INSERT INTO EMPLOYEES (EMPLOYEEID, FIRSTNAME, LASTNAME, DATEOFBIRTH, SIN#, MONTHLYSALARY, YEARLYBONUS, POSITION, EMPLOYEMENTDATE)

VALUES (7881234, ‘SOFIA’, ‘COPOLA’, ‘1970-01-26’, 123400123, 5150.00, 3680.00, ‘MANAGER’, ‘2016-01-01’);