1 INSERT INTO employee VALUES
2 (1, 'Gavin', 'Mcclure', 'gmcclure@[Link]', '238.898.2338x72', DATE '2018-02-09',
'FIN004', 5308, 0.17, 104, 10),
3 (2, 'Anthony', 'Long', 'along@[Link]', '439-710-9359', DATE '2021-02-13', 'HR002',
5043, 0.18, 100, 50),
4 (3, 'Ruth', 'Obrien', 'robrien@[Link]', '(437)991-8762', DATE '2020-04-08', 'HR002',
5253, 0.09, 100, 40),
5 (4, 'William', 'Davis', 'wdavis@[Link]', '681-232-5768x57', DATE '2023-08-11',
'HR002', 7515, 0.07, 103, 60),
6 (5, 'Michelle', 'Gaines', 'mgaines@[Link]', '774.457.4076x95', DATE '2023-02-13',
'ENG007', 6494, 0.14, 103, 50),
7 (6, 'Christopher', 'Chen', 'cchen@[Link]', '001-377-567-811', DATE '2021-09-15',
'MKT003', 4723, 0.16, 102, 20),
8 (7, 'John', 'Rose', 'jrose@[Link]', '001-449-452-889', DATE '2021-09-23', 'ENG007',
8114, 0.05, 100, 50),
9 (8, 'Sherri', 'Wood', 'swood@[Link]', '+1-735-617-7144', DATE '2023-10-03', 'OPS006'
, 5258, 0.01, 102, 20),
10 (9, 'Eric', 'Bond', 'ebond@[Link]', '(599)583-4716x9', DATE '2017-02-03', 'FIN004',
4113, 0.04, 104, 30),
11 (10, 'Joy', 'Parker', 'jparker@[Link]', '(555)453-4566x3', DATE '2021-05-14',
'MKT003', 7078, 0.01, 102, 60),
12 (11, 'Elizabeth', 'Medina', 'emedina@[Link]', '450-660-7879', DATE '2017-02-03',
'DEV001', 7989, 0.15, 102, 60),
13 (12, 'Douglas', 'Li', 'dli@[Link]', '001-591-717-718', DATE '2021-05-13', 'MKT003',
7490, 0.03, 102, 50),
14 (13, 'Courtney', 'Johnson', 'cjohnson@[Link]', '780.483.5034', DATE '2021-05-09',
'IT005', 7256, 0.11, 103, 10),
15 (14, 'Robert', 'Morales', 'rmorales@[Link]', '(919)406-0152x3', DATE '2023-11-04',
'DEV001', 4650, 0.15, 101, 50),
16 (15, 'Jenny', 'Dennis', 'jdennis@[Link]', '343.679.9780', DATE '2024-03-04',
'FIN004', 6328, 0.06, 102, 30),
17 (16, 'Donald', 'Jackson', 'djackson@[Link]', '530-273-6567', DATE '2024-12-10',
'HR002', 6031, 0.07, 104, 40),
18 (17, 'Eric', 'Sandoval', 'esandoval@[Link]', '(446)884-1643x8', DATE '2023-03-08',
'MKT003', 7542, 0.16, 102, 60),
19 (18, 'Jared', 'Potter', 'jpotter@[Link]', '(359)238-6227x3', DATE '2022-02-15',
'DEV001', 5479, 0.02, 102, 30),
20 (19, 'Nicholas', 'Dickerson', 'ndickerson@[Link]', '001-491-207-461', DATE
'2024-04-02', 'OPS006', 5488, 0.07, 100, 20),
21 (20, 'James', 'Johnson', 'jjohnson@[Link]', '+1-852-747-0744', DATE '2021-07-18',
'DEV001', 8595, 0.19, 101, 40),
22 (21, 'Shannon', 'Cruz', 'scruz@[Link]', '001-705-622-124', DATE '2017-03-14',
'MKT003', 8098, 0.1, 100, 50),
23 (22, 'Rodney', 'Watkins', 'rwatkins@[Link]', '001-741-383-840', DATE '2018-08-28',
'ENG007', 5517, 0.15, 101, 60),
24 (23, 'Brian', 'Owen', 'bowen@[Link]', '+1-214-795-2939', DATE '2018-10-05', 'FIN004'
, 5482, 0.18, 103, 50),
25 (24, 'Elizabeth', 'Jacobs', 'ejacobs@[Link]', '+1-702-950-4235', DATE '2016-01-12',
'ENG007', 5354, 0.1, 100, 10),
26 (25, 'Angela', 'Murphy', 'amurphy@[Link]', '(674)747-7560x5', DATE '2023-08-16',
'MKT003', 7300, 0.19, 103, 50),
27 (26, 'Bridget', 'Foley', 'bfoley@[Link]', '719-645-7556x99', DATE '2019-01-13',
'ENG007', 6968, 0.12, 103, 50),
28 (27, 'Megan', 'Heath', 'mheath@[Link]', '572.933.8205x14', DATE '2025-01-11',
'MKT003', 5873, 0.15, 104, 10),
29 (28, 'Michelle', 'Parrish', 'mparrish@[Link]', '+1-551-981-7518', DATE '2018-09-27',
'ENG007', 6720, 0.17, 103, 10),
30 (29, 'Mark', 'Gardner', 'mgardner@[Link]', '001-867-874-236', DATE '2024-06-05',
'ENG007', 7820, 0.04, 102, 40),
31 (30, 'Karla', 'Reed', 'kreed@[Link]', '(394)304-8415', DATE '2017-12-16', 'DEV001',
5867, 0.12, 101, 30),
32 (31, 'April', 'Martinez', 'amartinez@[Link]', '634-792-4303x74', DATE '2015-10-18',
'OPS006', 3813, 0.04, 104, 10),
33 (32, 'Michelle', 'Hayes', 'mhayes@[Link]', '(856)455-1879x6', DATE '2018-07-04',
'DEV001', 5135, 0.08, 101, 50),
34 (33, 'Jennifer', 'Benson', 'jbenson@[Link]', '468-983-9065', DATE '2019-09-03',
'ENG007', 7241, 0.04, 101, 20),
35 (34, 'Kathleen', 'Edwards', 'kedwards@[Link]', '001-386-340-087', DATE '2019-05-08',
'OPS006', 4100, 0.18, 102, 10),
36 (35, 'Natasha', 'Rivera', 'nrivera@[Link]', '362-579-3877x21', DATE '2017-07-20',
'FIN004', 7476, 0.04, 101, 20),
37 (36, 'Anthony', 'Brown', 'abrown@[Link]', '702.415.3383x30', DATE '2022-04-14',
'IT005', 4538, 0.15, 102, 40),
38 (37, 'Yesenia', 'Garcia', 'ygarcia@[Link]', '580-413-0952x18', DATE '2021-11-14',
'DEV001', 6276, 0.13, 101, 20),
39 (38, 'John', 'Jordan', 'jjordan@[Link]', '4143167514', DATE '2017-03-28', 'FIN004',
3593, 0.08, 104, 50),
40 (39, 'Joel', 'Johnson', 'jjohnson@[Link]', '379.407.3701', DATE '2017-02-02',
'HR002', 8460, 0.13, 101, 20),
41 (40, 'Kenneth', 'Lynch', 'klynch@[Link]', '847-529-2136x34', DATE '2018-04-05',
'HR002', 3242, 0.09, 102, 40),
42 (41, 'James', 'Campbell', 'jcampbell@[Link]', '+1-296-636-8558', DATE '2021-01-23',
'MKT003', 3810, 0.03, 102, 30),
43 (42, 'Tracy', 'Flores', 'tflores@[Link]', '+1-605-993-5258', DATE '2019-06-11',
'OPS006', 4912, 0.14, 103, 20),
44 (43, 'Bryan', 'Weaver', 'bweaver@[Link]', '+1-427-929-9441', DATE '2018-12-25',
'MKT003', 7171, 0.13, 104, 40),
45 (44, 'Kenneth', 'Knight', 'kknight@[Link]', '5928781622', DATE '2022-06-14',
'ENG007', 6288, 0.07, 100, 20),
46 (45, 'Lance', 'Wilson', 'lwilson@[Link]', '643.854.0729x43', DATE '2021-07-29',
'MKT003', 7318, 0.14, 102, 60),
47 (46, 'Paul', 'Mosley', 'pmosley@[Link]', '310.213.4404x81', DATE '2021-05-04',
'ENG007', 8448, 0.04, 103, 60),
48 (47, 'Jeffery', 'Baxter', 'jbaxter@[Link]', '001-639-680-113', DATE '2019-07-16',
'FIN004', 3574, 0.09, 101, 10),
49 (48, 'Gerald', 'Murphy', 'gmurphy@[Link]', '5282067807', DATE '2015-09-23', 'IT005',
4505, 0.17, 103, 10),
50 (49, 'Megan', 'King', 'mking@[Link]', '638.945.6343x25', DATE '2022-11-03', 'ENG007'
, 6515, 0.11, 102, 50),
51 (50, 'James', 'Stone', 'jstone@[Link]', '2803881820', DATE '2019-03-23', 'MKT003',
3397, 0.04, 104, 30);