-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathEMPLOYEE.sql
100 lines (100 loc) · 12.8 KB
/
EMPLOYEE.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (1, 'Buck', 'Sherme', 16.53, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (2, 'Kingsley', 'Zannolli', 19.49, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (3, 'Wyn', 'Schuh', 22.36, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (4, 'Tilda', 'Ayrs', 26.97, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (5, 'Sharron', 'Jenny', 27.26, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (6, 'Caty', 'Ortzen', 21.59, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (7, 'Alfonse', 'Oldershaw', 28.83, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (8, 'Johna', 'Enbury', 16.39, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (9, 'Donavon', 'Siddell', 25.2, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (10, 'Tine', 'Dohms', 19.81, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (11, 'Jillie', 'Braidman', 24.51, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (12, 'Noble', 'Chaikovski', 20.9, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (13, 'Rab', 'Olechnowicz', 14.6, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (14, 'Emmeline', 'Kunkler', 14.78, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (15, 'Janeta', 'Frackiewicz', 26.91, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (16, 'Roarke', 'Huckett', 29.49, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (17, 'Marleen', 'Grombridge', 23.72, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (18, 'Jonas', 'Peschet', 18.01, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (19, 'Devan', 'Tomaszkiewicz', 19.62, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (20, 'Chalmers', 'Mummery', 14.4, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (21, 'Kimball', 'Simenet', 26.74, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (22, 'Dallis', 'Awmack', 27.31, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (23, 'Godfrey', 'Lukacs', 29.8, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (24, 'Reggie', 'Sleicht', 13.56, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (25, 'Lu', 'McCaughey', 24.09, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (26, 'Gerald', 'Biesinger', 26.38, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (27, 'Lockwood', 'Dearman', 18.63, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (28, 'Stacy', 'Longstreet', 13.03, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (29, 'Emmit', 'Ebbers', 22.96, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (30, 'Belia', 'Rosser', 21.96, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (31, 'Babette', 'Grafton-Herbert', 24.19, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (32, 'Sutton', 'Biggadyke', 14.57, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (33, 'Carly', 'Thumim', 15.99, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (34, 'Nancey', 'Mariotte', 18.74, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (35, 'Dacie', 'Marsters', 24.83, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (36, 'Hinda', 'Stowe', 23.89, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (37, 'Parsifal', 'Sturror', 18.94, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (38, 'Othilia', 'Macbeth', 14.03, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (39, 'Ferrel', 'Seeley', 22.07, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (40, 'Marji', 'Whitehurst', 27.4, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (41, 'Angele', 'McGready', 22.11, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (42, 'Mannie', 'Attyeo', 22.05, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (43, 'Daffie', 'Wixey', 21.72, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (44, 'Una', 'Creed', 21.48, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (45, 'Emmanuel', 'Conaboy', 29.08, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (46, 'Inigo', 'Pattemore', 22.85, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (47, 'Patrica', 'Gethyn', 22.9, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (48, 'Hobard', 'Birdwhistle', 12.99, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (49, 'Coop', 'Yeandel', 25.83, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (50, 'Mufi', 'Godspeede', 29.29, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (51, 'Katee', 'Beavis', 22.95, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (52, 'Cristionna', 'Croysdale', 23.42, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (53, 'Udale', 'Turn', 19.62, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (54, 'Shae', 'Fawcett', 18.02, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (55, 'Hilly', 'Truter', 20.49, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (56, 'Ulrikaumeko', 'Comazzo', 26.69, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (57, 'Leopold', 'Jacobsen', 24.45, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (58, 'Essy', 'O''Fogerty', 24.94, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (59, 'Lavina', 'Manz', 19.64, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (60, 'Cordelia', 'Crewther', 25.02, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (61, 'Devon', 'Beaver', 19.41, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (62, 'Anthony', 'Pargetter', 19.77, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (63, 'Vite', 'Jiroudek', 12.93, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (64, 'Mercie', 'Maffiotti', 28.25, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (65, 'Johan', 'Gasgarth', 20.3, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (66, 'Cindi', 'Negro', 26.36, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (67, 'Nefen', 'Laycock', 23.91, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (68, 'Gerick', 'Huburn', 27.0, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (69, 'Armando', 'Shapiro', 19.5, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (70, 'Finlay', 'Brager', 23.77, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (71, 'Christi', 'MacDuffie', 23.28, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (72, 'Kati', 'FitzGilbert', 29.38, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (73, 'Roy', 'Pratte', 23.52, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (74, 'Elijah', 'Gullen', 16.33, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (75, 'Winna', 'Frenzel;', 18.49, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (76, 'Jenny', 'Peachment', 15.26, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (77, 'Lucinda', 'Trevett', 15.64, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (78, 'Maurie', 'Elvy', 12.7, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (79, 'Loren', 'Reeks', 19.63, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (80, 'Willey', 'Freda', 24.3, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (81, 'Cybil', 'Govett', 28.98, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (82, 'Tabbatha', 'Kytter', 22.74, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (83, 'Alfie', 'Pook', 13.41, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (84, 'Faunie', 'Cawse', 23.54, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (85, 'Ode', 'Waters', 20.68, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (86, 'Tremayne', 'Abate', 12.45, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (87, 'Myrtice', 'Ager', 27.51, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (88, 'Andris', 'Hemerijk', 27.93, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (89, 'Paulie', 'MacNulty', 24.77, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (90, 'Maressa', 'Mavin', 28.38, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (91, 'Codi', 'Biggs', 14.94, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (92, 'Norrie', 'Halfhyde', 17.73, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (93, 'Niki', 'Geockle', 24.54, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (94, 'Gustavo', 'Greenhead', 18.49, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (95, 'Artemus', 'Housden', 14.78, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (96, 'Binnie', 'Balfour', 16.41, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (97, 'Jack', 'Bennion', 15.96, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (98, 'Tova', 'Nuemann', 20.62, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (99, 'Parke', 'Dack', 17.46, 0);
insert into EMPLOYEE (Employee_ID, First_Name, Last_Name, Salary, Cumulative_Pickrate) values (100, 'Felicity', 'Kerman', 21.31, 0);