-
Notifications
You must be signed in to change notification settings - Fork 0
/
insert_commands.sql
320 lines (318 loc) · 19 KB
/
insert_commands.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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
INSERT INTO department (dep_id,dep_name) VALUES
(0,"SALES"),
(1,"MARKETING"),
(2,"PRODUCT DESIGN"),
(3,"ENGINEERING");
INSERT INTO employee (type,emp_id,first_name,last_name,gender,hire_date,termination_date,department1,department2,bonus,manager_start_date) VALUES
("MANAGER","0TV9L32IOR","ANTHONY","ANDREWS","MALE","2012-05-27",NULL,0,NULL,12000,"2012-06-25"),
("MANAGER","1G2XUW329O","LYDIA","PETERS","FEMALE","2010-06-20","2012-09-30",1,NULL,6000,"2011-12-05"),
("MANAGER","16A4844UHD","LILIANA","MORGAN","FEMALE","2005-08-25",NULL,2,NULL,6000,"2007-06-19"),
("MANAGER","LI448V9A21","ERICA","BENNETT","FEMALE","2010-05-03","2013-08-05",3,NULL,6000,"2010-05-20"),
("EMPLOYEE","AU98267EFD","LOGAN","GILBERT","MALE","2000-10-05","2006-02-24",0,1,NULL,NULL),
("EMPLOYEE","RS6A64O467","SELENA","HERRERA","FEMALE","2013-11-22","2013-12-29",0,NULL,NULL,NULL),
("EMPLOYEE","16DPW1TAQR","MARIANA","CASTRO","FEMALE","2009-05-21",NULL,2,NULL,NULL,NULL),
("EMPLOYEE","38N49Q46MQ","SEAN","CARROLL","MALE","2005-09-06","2012-11-18",1,NULL,NULL,NULL),
("EMPLOYEE","0F9RTW28P7","COLE","MARSHALL","MALE","2004-03-22","2013-06-08",3,NULL,NULL,NULL),
("EMPLOYEE","TL10G3Y562","MEGAN","CARPENTER","FEMALE","2009-04-01",NULL,0,2,NULL,NULL),
("EMPLOYEE","403AW88EVB","DILLON","COLLINS","MALE","2004-05-06","2010-07-30",2,1,NULL,NULL),
("EMPLOYEE","JYJ4S3QYB8","KEEGAN","GUZMAN","MALE","2003-12-09","2010-12-12",0,NULL,NULL,NULL),
("EMPLOYEE","GUT2F2YH2O","AVERY","DAVIS","MALE","2011-07-22",NULL,1,NULL,NULL,NULL),
("EMPLOYEE","76Z6S5NYV4","SYDNEY","SIMMONS","FEMALE","2010-03-16",NULL,3,0,NULL,NULL),
("EMPLOYEE","B59Q6AEN9E","VANESSA","REYNOLDS","FEMALE","2000-11-30",NULL,1,3,NULL,NULL),
("EMPLOYEE","375F7CA5N8","AUDREY","MARSHALL","FEMALE","2004-06-15",NULL,2,3,NULL,NULL),
("EMPLOYEE","ND173O338H","PAYTON","BISHOP","FEMALE","2012-02-25","2013-04-13",0,NULL,NULL,NULL),
("EMPLOYEE","RXR5B3GO4E","KADEN","COLE","MALE","2013-09-21",NULL,0,NULL,NULL,NULL),
("EMPLOYEE","IVI0758030","CONNER","DIXON","MALE","2000-08-11","2011-03-09",0,NULL,NULL,NULL),
("EMPLOYEE","S7T9LYX8WA","BRENDA","RUSSELL","FEMALE","2005-03-15",NULL,2,NULL,NULL,NULL),
("EMPLOYEE","175MM39B33","TRAVIS","THOMAS","MALE","2013-02-22",NULL,2,NULL,NULL,NULL),
("EMPLOYEE","9B8C17Q3Q6","ROBERTO","CASTRO","MALE","2010-06-10","2012-06-21",3,1,NULL,NULL),
("EMPLOYEE","4MSW8NM8H9","CAITLIN","SILVA","FEMALE","2010-07-09",NULL,1,NULL,NULL,NULL),
("EMPLOYEE","6SQ1V5LE3T","AARON","HOFFMAN","MALE","2011-04-02",NULL,2,NULL,NULL,NULL),
("EMPLOYEE","K9M50WQ770","ISABEL","GRIFFIN","FEMALE","2004-07-19",NULL,3,1,NULL,NULL),
("EMPLOYEE","1TI9979806","LUIS","RICE","MALE","2011-12-10",NULL,1,NULL,NULL,NULL),
("EMPLOYEE","1GO95BM241","MARK","HUNT","MALE","2005-09-16","2007-01-04",3,NULL,NULL,NULL),
("EMPLOYEE","L4L13AY37A","MARCOS","WAGNER","MALE","2006-07-10","2012-01-02",1,NULL,NULL,NULL),
("EMPLOYEE","U5P59EF9KW","ALICIA","ANDERSON","FEMALE","2000-02-08","2013-01-20",3,NULL,NULL,NULL),
("EMPLOYEE","T770U75244","JEREMIAH","DUNCAN","MALE","2007-03-30","2014-01-11",3,NULL,NULL,NULL),
("EMPLOYEE","L5705542T8","TIMOTHY","JORDAN","MALE","2004-06-15",NULL,2,NULL,NULL,NULL),
("EMPLOYEE","C15HYVNUKR","LESLIE","COX","FEMALE","2006-04-10","2013-09-01",0,NULL,NULL,NULL),
("EMPLOYEE","97J4UO6QNE","SKYLAR","GILBERT","FEMALE","2010-11-14",NULL,0,NULL,NULL,NULL),
("EMPLOYEE","4F7KI1GS79","MADELINE","MOORE","FEMALE","2002-02-09","2011-06-07",3,2,NULL,NULL),
("EMPLOYEE","09NE7S3209","FRANCISCO","THOMAS","MALE","2011-11-05",NULL,0,NULL,NULL,NULL),
("EMPLOYEE","WR38I3FD39","SAMANTHA","CRAWFORD","FEMALE","2003-03-01",NULL,0,NULL,NULL,NULL),
("EMPLOYEE","4W99VW1Y70","KADEN","AUSTIN","MALE","2006-08-24","2007-10-08",3,NULL,NULL,NULL),
("EMPLOYEE","66820835YP","KIRA","HARPER","FEMALE","2008-12-05",NULL,3,NULL,NULL,NULL),
("EMPLOYEE","Z63X0I1J44","BRENDAN","LAWSON","MALE","2001-04-14","2013-06-09",1,NULL,NULL,NULL),
("EMPLOYEE","ZWAY4G968S","DESTINY","CARTER","FEMALE","2013-06-28",NULL,3,NULL,NULL,NULL),
("EMPLOYEE","JPZ0MWFCSA","ABRAHAM","HAMILTON","MALE","2002-07-22","2008-11-04",0,NULL,NULL,NULL),
("EMPLOYEE","R33588O5I4","JACKSON","BRYANT","MALE","2006-11-07",NULL,0,2,NULL,NULL),
("EMPLOYEE","YF9TGHUAR5","CRISTIAN","OLIVER","MALE","2011-11-01",NULL,2,NULL,NULL,NULL),
("EMPLOYEE","MTI52B6K1G","ANDREA","CARLSON","FEMALE","2010-08-09",NULL,0,NULL,NULL,NULL),
("EMPLOYEE","MQ7V4E771U","CARSON","NGUYEN","MALE","2003-05-30","2009-05-01",3,NULL,NULL,NULL),
("EMPLOYEE","3537I3057E","DYLAN","KELLY","MALE","2011-08-03",NULL,2,NULL,NULL,NULL),
("EMPLOYEE","MUFJU657O3","MONICA","CARROLL","FEMALE","2010-03-18",NULL,0,2,NULL,NULL),
("EMPLOYEE","380I2WN876","BENJAMIN","PERKINS","MALE","2008-01-25",NULL,1,NULL,NULL,NULL),
("EMPLOYEE","ETK446ZV99","LILLIAN","PORTER","FEMALE","2010-09-24",NULL,3,NULL,NULL,NULL),
("EMPLOYEE","X16E330E6V","DEVIN","JOHNSTON","MALE","2002-12-11","2008-05-10",0,NULL,NULL,NULL),
("EMPLOYEE","W5JKLT3K63","MALLORY","ANDERSON","FEMALE","2011-02-23",NULL,0,NULL,NULL,NULL),
("EMPLOYEE","4CYGN37W85","RUBEN","ANDERSON","MALE","2010-03-05","2012-03-14",3,0,NULL,NULL),
("EMPLOYEE","D506Q6897K","DANIELA","RAMOS","FEMALE","2000-04-17",NULL,0,NULL,NULL,NULL),
("EMPLOYEE","H6288DO991","MACKENZIE","BARNES","FEMALE","2004-04-27",NULL,1,NULL,NULL,NULL),
("EMPLOYEE","4UZYO6ULG8","ALONDRA","FORD","FEMALE","2008-10-29",NULL,3,NULL,NULL,NULL),
("EMPLOYEE","574VE1XKPJ","JOSIAH","POWELL","MALE","2010-02-25",NULL,1,NULL,NULL,NULL),
("EMPLOYEE","5Q273P11K7","ALEXANDRA","ROSE","FEMALE","2003-04-09","2007-09-27",2,NULL,NULL,NULL),
("EMPLOYEE","P0Q3YWUA90","KELLY","HOWARD","FEMALE","2008-11-28","2010-11-30",2,NULL,NULL,NULL),
("EMPLOYEE","1OIJ033D2T","CASSANDRA","GARCIA","FEMALE","2009-01-28",NULL,1,NULL,NULL,NULL),
("EMPLOYEE","T5NGTQP0J4","JAYDEN","DUNN","MALE","2007-07-28",NULL,3,NULL,NULL,NULL),
("EMPLOYEE","66S3T5M0MV","ALYSSA","JACOBS","FEMALE","2004-05-17","2010-01-20",2,NULL,NULL,NULL),
("EMPLOYEE","1JMZG79C0I","JOSEPHINE","SMITH","FEMALE","2011-05-26",NULL,1,NULL,NULL,NULL),
("EMPLOYEE","J8X7Z32M05","EDUARDO","ROBERTS","MALE","2001-02-20","2004-06-30",3,NULL,NULL,NULL),
("EMPLOYEE","AZGPSTO6LF","COREY","COX","MALE","2005-01-26",NULL,3,2,NULL,NULL),
("EMPLOYEE","0D558D2BQN","MAXWELL","BURKE","MALE","2003-01-19",NULL,3,2,NULL,NULL),
("EMPLOYEE","QOP8E6F2F2","REAGAN","SIMPSON","FEMALE","2002-09-25",NULL,1,NULL,NULL,NULL),
("EMPLOYEE","C400P1Q8V5","RILEY","TURNER","MALE","2005-01-08","2011-10-10",1,NULL,NULL,NULL),
("EMPLOYEE","50B1MPO71X","SAMANTHA","ALLEN","FEMALE","2008-11-01",NULL,1,NULL,NULL,NULL),
("EMPLOYEE","2M7N8H8BUR","JOSEPHINE","ALLEN","FEMALE","2009-11-28","2011-12-01",3,NULL,NULL,NULL),
("EMPLOYEE","2YJ4ML8P8Y","MARIANA","ARMSTRONG","FEMALE","2003-08-13","2011-04-19",0,NULL,NULL,NULL),
("EMPLOYEE","M9Y07M26SV","BRIAN","GARCIA","MALE","2003-12-02","2010-07-30",2,NULL,NULL,NULL),
("EMPLOYEE","YOI6F45M89","SADIE","LOPEZ","FEMALE","2007-03-05","2010-07-21",0,NULL,NULL,NULL),
("EMPLOYEE","4QWTMX76W6","ASHLEY","KELLEY","FEMALE","2002-03-05",NULL,0,3,NULL,NULL),
("EMPLOYEE","3O853K6ZVP","DYLAN","PETERS","MALE","2004-12-11",NULL,1,NULL,NULL,NULL),
("EMPLOYEE","588MYBCN1W","BENJAMIN","FERGUSON","MALE","2010-08-28","2011-04-14",0,2,NULL,NULL),
("EMPLOYEE","XU9WW551Z6","MICHELLE","GARCIA","FEMALE","2000-03-09","2004-05-07",2,NULL,NULL,NULL),
("EMPLOYEE","09MY1SPBNQ","LILY","GRAY","FEMALE","2009-04-08",NULL,2,NULL,NULL,NULL),
("EMPLOYEE","MB9AI123OH","IVAN","TURNER","MALE","2009-10-07",NULL,3,NULL,NULL,NULL),
("EMPLOYEE","6I8KZPWYCZ","ISAIAH","MENDEZ","MALE","2002-04-14","2010-01-09",2,NULL,NULL,NULL),
("EMPLOYEE","JXC0PE05L5","HOPE","RAMIREZ","FEMALE","2005-09-24","2009-10-13",2,3,NULL,NULL),
("EMPLOYEE","YN9F7702B9","HANNAH","CHAPMAN","FEMALE","2013-05-02",NULL,0,NULL,NULL,NULL),
("EMPLOYEE","JXK9OWRDZ9","NICOLAS","WOOD","MALE","2008-01-19",NULL,3,NULL,NULL,NULL),
("EMPLOYEE","79Z69R2B8Z","MYA","BURNS","FEMALE","2005-10-28","2010-05-18",3,0,NULL,NULL),
("EMPLOYEE","782Y989504","JASMINE","PERKINS","FEMALE","2009-09-18","2010-06-18",2,3,NULL,NULL),
("EMPLOYEE","933JXW736O","PATRICK","RILEY","MALE","2003-11-30","2013-02-08",0,NULL,NULL,NULL),
("EMPLOYEE","7B4315KVJL","JOSEPH","SIMPSON","MALE","2010-07-11",NULL,1,NULL,NULL,NULL),
("EMPLOYEE","S8IF96LT7V","JONAH","WRIGHT","MALE","2007-08-09",NULL,0,NULL,NULL,NULL),
("EMPLOYEE","IV02RXWKLX","LUCY","CHAPMAN","FEMALE","2006-01-13",NULL,0,NULL,NULL,NULL),
("EMPLOYEE","HFS0N3Q5IW","MARGARET","THOMPSON","FEMALE","2012-05-15",NULL,3,1,NULL,NULL),
("EMPLOYEE","D48MT6NC35","NADIA","RAMOS","FEMALE","2007-12-25",NULL,3,NULL,NULL,NULL),
("EMPLOYEE","JAQK909Q6H","MOLLY","HUNTER","FEMALE","2013-01-25",NULL,2,NULL,NULL,NULL),
("EMPLOYEE","DA615S1ZSZ","SPENCER","ANDREWS","MALE","2010-09-10","2012-01-14",0,NULL,NULL,NULL),
("EMPLOYEE","L3B4ROT295","GRIFFIN","HAWKINS","MALE","2001-05-15",NULL,3,1,NULL,NULL),
("EMPLOYEE","836715BW45","ELISE","ROSE","FEMALE","2012-02-19","2013-06-11",0,1,NULL,NULL),
("EMPLOYEE","3970XI2827","STEPHEN","MILLS","MALE","2012-06-24",NULL,0,NULL,NULL,NULL),
("EMPLOYEE","YB9Y81M4E7","MARIO","ROGERS","MALE","2003-10-09","2006-12-22",1,NULL,NULL,NULL),
("EMPLOYEE","361S13UI44","RILEY","AUSTIN","FEMALE","2008-08-13",NULL,3,NULL,NULL,NULL),
("EMPLOYEE","80R5Z40X41","JESSICA","CLARK","FEMALE","2003-11-02","2013-11-15",1,NULL,NULL,NULL),
("EMPLOYEE","0J671AHKQ4","KYLIE","HARRISON","FEMALE","2006-06-09",NULL,0,NULL,NULL,NULL),
("EMPLOYEE","J2WNJ52221","THOMAS","ALLEN","MALE","2011-10-04","2012-07-25",1,NULL,NULL,NULL);
INSERT INTO salary (emp_id,start_date,end_date,salary_amt) VALUES
("0TV9L32IOR","2012-05-27","2013-04-01",100000),
("0TV9L32IOR","2013-04-01",NULL,110000),
("1G2XUW329O","2010-06-20","2011-08-10",90000),
("1G2XUW329O","2011-08-10","2012-09-30",108000),
("16A4844UHD","2005-08-25","2008-06-18",100000),
("16A4844UHD","2008-06-18","2011-04-12",120000),
("16A4844UHD","2011-04-12",NULL,132000),
("LI448V9A21","2010-05-03","2013-08-05",100000),
("AU98267EFD","2000-10-05","2003-06-16",40000),
("AU98267EFD","2003-06-16","2006-02-24",52000),
("RS6A64O467","2013-11-22","2013-12-10",60000),
("RS6A64O467","2013-12-10","2013-12-29",78000),
("16DPW1TAQR","2009-05-21","2011-09-28",40000),
("16DPW1TAQR","2011-09-28",NULL,52000),
("38N49Q46MQ","2005-09-06","2008-01-30",40000),
("38N49Q46MQ","2008-01-30","2010-06-24",44000),
("38N49Q46MQ","2010-06-24","2012-11-18",57200),
("0F9RTW28P7","2004-03-22","2013-06-08",40000),
("TL10G3Y562","2009-04-01",NULL,50000),
("403AW88EVB","2004-05-06","2006-06-03",70000),
("403AW88EVB","2006-06-03","2008-06-30",84000),
("403AW88EVB","2008-06-30","2010-07-30",92400),
("JYJ4S3QYB8","2003-12-09","2010-12-12",30000),
("GUT2F2YH2O","2011-07-22","2012-10-28",60000),
("GUT2F2YH2O","2012-10-28",NULL,78000),
("76Z6S5NYV4","2010-03-16","2011-07-02",50000),
("76Z6S5NYV4","2011-07-02","2012-10-17",60000),
("76Z6S5NYV4","2012-10-17",NULL,72000),
("B59Q6AEN9E","2000-11-30","2005-04-22",40000),
("B59Q6AEN9E","2005-04-22","2009-09-12",48000),
("B59Q6AEN9E","2009-09-12",NULL,57600),
("375F7CA5N8","2004-06-15","2009-04-10",30000),
("375F7CA5N8","2009-04-10",NULL,39000),
("ND173O338H","2012-02-25","2013-04-13",50000),
("RXR5B3GO4E","2013-09-21","2013-11-05",60000),
("RXR5B3GO4E","2013-11-05","2013-12-20",66000),
("RXR5B3GO4E","2013-12-20",NULL,79200),
("IVI0758030","2000-08-11","2004-02-19",70000),
("IVI0758030","2004-02-19","2007-08-29",84000),
("IVI0758030","2007-08-29","2011-03-09",92400),
("S7T9LYX8WA","2005-03-15",NULL,40000),
("175MM39B33","2013-02-22","2013-08-14",70000),
("175MM39B33","2013-08-14",NULL,84000),
("9B8C17Q3Q6","2010-06-10","2012-06-21",70000),
("4MSW8NM8H9","2010-07-09","2012-04-22",60000),
("4MSW8NM8H9","2012-04-22",NULL,78000),
("6SQ1V5LE3T","2011-04-02","2012-09-02",60000),
("6SQ1V5LE3T","2012-09-02",NULL,72000),
("K9M50WQ770","2004-07-19","2009-04-27",30000),
("K9M50WQ770","2009-04-27",NULL,33000),
("1TI9979806","2011-12-10","2012-08-28",60000),
("1TI9979806","2012-08-28","2013-05-17",78000),
("1TI9979806","2013-05-17",NULL,85800),
("1GO95BM241","2005-09-16","2006-05-11",30000),
("1GO95BM241","2006-05-11","2007-01-04",36000),
("L4L13AY37A","2006-07-10","2009-04-06",50000),
("L4L13AY37A","2009-04-06","2012-01-02",65000),
("U5P59EF9KW","2000-02-08","2004-06-02",30000),
("U5P59EF9KW","2004-06-02","2008-09-25",36000),
("U5P59EF9KW","2008-09-25","2013-01-20",46800),
("T770U75244","2007-03-30","2014-01-11",60000),
("L5705542T8","2004-06-15",NULL,40000),
("C15HYVNUKR","2006-04-10","2013-09-01",60000),
("97J4UO6QNE","2010-11-14","2011-12-11",60000),
("97J4UO6QNE","2011-12-11","2013-01-06",78000),
("97J4UO6QNE","2013-01-06",NULL,101400),
("4F7KI1GS79","2002-02-09","2011-06-07",30000),
("09NE7S3209","2011-11-05","2012-08-05",40000),
("09NE7S3209","2012-08-05","2013-05-06",48000),
("09NE7S3209","2013-05-06",NULL,57600),
("WR38I3FD39","2003-03-01",NULL,70000),
("4W99VW1Y70","2006-08-24","2007-10-08",60000),
("66820835YP","2008-12-05",NULL,70000),
("Z63X0I1J44","2001-04-14","2005-05-02",30000),
("Z63X0I1J44","2005-05-02","2009-05-20",36000),
("Z63X0I1J44","2009-05-20","2013-06-09",46800),
("ZWAY4G968S","2013-06-28",NULL,50000),
("JPZ0MWFCSA","2002-07-22","2004-08-25",30000),
("JPZ0MWFCSA","2004-08-25","2006-09-29",33000),
("JPZ0MWFCSA","2006-09-29","2008-11-04",39600),
("R33588O5I4","2006-11-07","2009-04-07",40000),
("R33588O5I4","2009-04-07","2011-09-06",48000),
("R33588O5I4","2011-09-06",NULL,52800),
("YF9TGHUAR5","2011-11-01","2012-08-02",40000),
("YF9TGHUAR5","2012-08-02","2013-05-04",44000),
("YF9TGHUAR5","2013-05-04",NULL,48400),
("MTI52B6K1G","2010-08-09","2012-05-07",50000),
("MTI52B6K1G","2012-05-07",NULL,55000),
("MQ7V4E771U","2003-05-30","2005-05-20",60000),
("MQ7V4E771U","2005-05-20","2007-05-11",72000),
("MQ7V4E771U","2007-05-11","2009-05-01",86400),
("3537I3057E","2011-08-03","2012-11-03",50000),
("3537I3057E","2012-11-03",NULL,65000),
("MUFJU657O3","2010-03-18",NULL,60000),
("380I2WN876","2008-01-25","2011-01-30",40000),
("380I2WN876","2011-01-30",NULL,44000),
("ETK446ZV99","2010-09-24","2011-11-07",40000),
("ETK446ZV99","2011-11-07","2012-12-20",52000),
("ETK446ZV99","2012-12-20",NULL,67600),
("X16E330E6V","2002-12-11","2004-09-29",40000),
("X16E330E6V","2004-09-29","2006-07-19",44000),
("X16E330E6V","2006-07-19","2008-05-10",57200),
("W5JKLT3K63","2011-02-23","2012-08-14",30000),
("W5JKLT3K63","2012-08-14",NULL,39000),
("4CYGN37W85","2010-03-05","2010-11-06",60000),
("4CYGN37W85","2010-11-06","2011-07-10",72000),
("4CYGN37W85","2011-07-10","2012-03-14",86400),
("D506Q6897K","2000-04-17",NULL,30000),
("H6288DO991","2004-04-27","2007-07-31",60000),
("H6288DO991","2007-07-31","2010-11-02",78000),
("H6288DO991","2010-11-02",NULL,93600),
("4UZYO6ULG8","2008-10-29","2011-06-18",60000),
("4UZYO6ULG8","2011-06-18",NULL,72000),
("574VE1XKPJ","2010-02-25","2011-06-20",30000),
("574VE1XKPJ","2011-06-20","2012-10-12",39000),
("574VE1XKPJ","2012-10-12",NULL,50700),
("5Q273P11K7","2003-04-09","2005-07-03",60000),
("5Q273P11K7","2005-07-03","2007-09-27",72000),
("P0Q3YWUA90","2008-11-28","2009-07-30",70000),
("P0Q3YWUA90","2009-07-30","2010-03-31",91000),
("P0Q3YWUA90","2010-03-31","2010-11-30",100100),
("1OIJ033D2T","2009-01-28","2011-08-02",60000),
("1OIJ033D2T","2011-08-02",NULL,72000),
("T5NGTQP0J4","2007-07-28","2010-10-31",70000),
("T5NGTQP0J4","2010-10-31",NULL,91000),
("66S3T5M0MV","2004-05-17","2006-04-08",30000),
("66S3T5M0MV","2006-04-08","2008-02-28",39000),
("66S3T5M0MV","2008-02-28","2010-01-20",46800),
("1JMZG79C0I","2011-05-26","2012-04-18",60000),
("1JMZG79C0I","2012-04-18","2013-03-12",66000),
("1JMZG79C0I","2013-03-12",NULL,72600),
("J8X7Z32M05","2001-02-20","2002-10-25",60000),
("J8X7Z32M05","2002-10-25","2004-06-30",66000),
("AZGPSTO6LF","2005-01-26",NULL,70000),
("0D558D2BQN","2003-01-19","2006-09-24",60000),
("0D558D2BQN","2006-09-24","2010-05-30",78000),
("0D558D2BQN","2010-05-30",NULL,93600),
("QOP8E6F2F2","2002-09-25","2006-07-09",70000),
("QOP8E6F2F2","2006-07-09","2010-04-22",84000),
("QOP8E6F2F2","2010-04-22",NULL,100800),
("C400P1Q8V5","2005-01-08","2007-04-09",30000),
("C400P1Q8V5","2007-04-09","2009-07-08",39000),
("C400P1Q8V5","2009-07-08","2011-10-10",42900),
("50B1MPO71X","2008-11-01","2011-06-19",70000),
("50B1MPO71X","2011-06-19",NULL,77000),
("2M7N8H8BUR","2009-11-28","2010-11-29",70000),
("2M7N8H8BUR","2010-11-29","2011-12-01",84000),
("2YJ4ML8P8Y","2003-08-13","2007-06-16",60000),
("2YJ4ML8P8Y","2007-06-16","2011-04-19",66000),
("M9Y07M26SV","2003-12-02","2007-03-31",70000),
("M9Y07M26SV","2007-03-31","2010-07-30",84000),
("YOI6F45M89","2007-03-05","2010-07-21",50000),
("4QWTMX76W6","2002-03-05","2006-02-23",40000),
("4QWTMX76W6","2006-02-23","2010-02-13",52000),
("4QWTMX76W6","2010-02-13",NULL,62400),
("3O853K6ZVP","2004-12-11","2007-12-30",70000),
("3O853K6ZVP","2007-12-30","2011-01-17",91000),
("3O853K6ZVP","2011-01-17",NULL,118300),
("588MYBCN1W","2010-08-28","2011-04-14",70000),
("XU9WW551Z6","2000-03-09","2001-07-28",50000),
("XU9WW551Z6","2001-07-28","2002-12-16",55000),
("XU9WW551Z6","2002-12-16","2004-05-07",71500),
("09MY1SPBNQ","2009-04-08",NULL,30000),
("MB9AI123OH","2009-10-07","2011-12-06",40000),
("MB9AI123OH","2011-12-06",NULL,52000),
("6I8KZPWYCZ","2002-04-14","2010-01-09",60000),
("JXC0PE05L5","2005-09-24","2007-01-30",30000),
("JXC0PE05L5","2007-01-30","2008-06-06",36000),
("JXC0PE05L5","2008-06-06","2009-10-13",39600),
("YN9F7702B9","2013-05-02",NULL,60000),
("JXK9OWRDZ9","2008-01-19","2010-01-24",70000),
("JXK9OWRDZ9","2010-01-24","2012-01-30",91000),
("JXK9OWRDZ9","2012-01-30",NULL,100100),
("79Z69R2B8Z","2005-10-28","2010-05-18",60000),
("782Y989504","2009-09-18","2010-02-01",50000),
("782Y989504","2010-02-01","2010-06-18",55000),
("933JXW736O","2003-11-30","2013-02-08",30000),
("7B4315KVJL","2010-07-11","2012-04-23",30000),
("7B4315KVJL","2012-04-23",NULL,36000),
("S8IF96LT7V","2007-08-09","2010-11-06",60000),
("S8IF96LT7V","2010-11-06",NULL,78000),
("IV02RXWKLX","2006-01-13","2008-09-20",60000),
("IV02RXWKLX","2008-09-20","2011-05-29",78000),
("IV02RXWKLX","2011-05-29",NULL,85800),
("HFS0N3Q5IW","2012-05-15","2012-12-11",30000),
("HFS0N3Q5IW","2012-12-11","2013-07-09",39000),
("HFS0N3Q5IW","2013-07-09",NULL,46800),
("D48MT6NC35","2007-12-25",NULL,60000),
("JAQK909Q6H","2013-01-25","2013-07-31",30000),
("JAQK909Q6H","2013-07-31",NULL,39000),
("DA615S1ZSZ","2010-09-10","2011-02-20",50000),
("DA615S1ZSZ","2011-02-20","2011-08-02",65000),
("DA615S1ZSZ","2011-08-02","2012-01-14",84500),
("L3B4ROT295","2001-05-15","2007-09-25",40000),
("L3B4ROT295","2007-09-25",NULL,44000),
("836715BW45","2012-02-19","2012-10-14",60000),
("836715BW45","2012-10-14","2013-06-11",78000),
("3970XI2827","2012-06-24","2013-01-06",30000),
("3970XI2827","2013-01-06","2013-07-21",39000),
("3970XI2827","2013-07-21",NULL,42900),
("YB9Y81M4E7","2003-10-09","2004-11-02",30000),
("YB9Y81M4E7","2004-11-02","2005-11-27",33000),
("YB9Y81M4E7","2005-11-27","2006-12-22",39600),
("361S13UI44","2008-08-13","2011-05-10",60000),
("361S13UI44","2011-05-10",NULL,72000),
("80R5Z40X41","2003-11-02","2008-11-08",60000),
("80R5Z40X41","2008-11-08","2013-11-15",66000),
("0J671AHKQ4","2006-06-09","2008-12-27",30000),
("0J671AHKQ4","2008-12-27","2011-07-17",36000),
("0J671AHKQ4","2011-07-17",NULL,43200),
("J2WNJ52221","2011-10-04","2012-07-25",40000);