-
Notifications
You must be signed in to change notification settings - Fork 1
/
Team8-Phase2-2.sql
1086 lines (1076 loc) · 125 KB
/
Team8-Phase2-2.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
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
SET DEFINE OFF;
INSERT INTO BANK VALUES (0, 'JPMorgan Chase Bank Main Office', '1111 Polaris Parkway', 'Columbus', 'OH', 43240);
INSERT INTO BANK VALUES (1, 'JPMorgan Chase Bank Mobile', NULL, NULL, NULL, NULL);
INSERT INTO BANK VALUES (2, 'College Grove Branch', '3490 College Avenue', 'San Diego', 'CA', 92115);
INSERT INTO BANK VALUES (3, 'Athens Main Branch', '2 S Court Street', 'Athens', 'OH', 45701);
INSERT INTO BANK VALUES (4, 'South Salem Branch', '3450 Commercial St Se', 'Salem', 'OR', 97302);
INSERT INTO BANK VALUES (5, 'Chauncey Village Branch', '210 W State St', 'West Lafayette', 'IN', 47906);
INSERT INTO BANK VALUES (6, 'Oakley Branch', '2535 Main Street', 'Oakley', 'CA', 94561);
INSERT INTO BANK VALUES (7, 'LA Frontera Banking Center Branch', '2711 LA Frontera Boulevard, Suite 300', 'Round Rock', 'TX', 78681);
INSERT INTO BANK VALUES (8, 'Walled Lake Branch', '2181 North Pontiac Trail', 'Walled Lake', 'MI', 48390);
INSERT INTO BANK VALUES (9, 'Preston Center Motor Bank Branch', '6015 Weldon Howell Pkwy', 'Dallas', 'TX', 75225);
INSERT INTO BANK VALUES (10, 'North Richland Hills Brnch Branch', '8901 Tarrant Parkway', 'North Richland Hills', 'TX', 76180);
INSERT INTO BANK VALUES (11, 'Santa Clara Branch', '60 Division', 'Eugene', 'OR', 97404);
INSERT INTO BANK VALUES (12, 'Greenspoint Branch', '12450 Greenspoint Drive', 'Houston', 'TX', 77060);
INSERT INTO BANK VALUES (13, 'Fairfield Center Branch', '1401 Post Road', 'Fairfield', 'CT', 6824);
INSERT INTO BANK VALUES (14, 'Cudahy Branch', '4702 South Packard Avenue', 'Cudahy', 'WI', 53110);
INSERT INTO BANK VALUES (15, 'Lindenhurst Branch', '655 North Wellwood Avenue', 'Lindenhurst', 'NY', 11757);
INSERT INTO BANK VALUES (16, 'Atlanta - Buckhead Branch', '3330 Piedmont Road, Suite 28', 'Atlanta', 'GA', 30305);
INSERT INTO BANK VALUES (17, 'Oakhurst Branch', '40003 Hwy 49', 'Oakhurst', 'CA', 93644);
INSERT INTO BANK VALUES (18, 'Alliance Center Branch', '1207 West State Street', 'Alliance', 'OH', 44601);
INSERT INTO BANK VALUES (19, 'Bae Mar Branch', '2 Bae Mar Place', 'Wheeling', 'WV', 26003);
INSERT INTO BANK VALUES (20, 'North Bellmore Branch', '1542 Bellmore Avenue', 'North Bellmore', 'NY', 11710);
INSERT INTO BANK VALUES (21, 'Eastwind Center Branch', '2165 E Windmill Ln, Ste 100', 'Las Vegas', 'NV', 89123);
INSERT INTO BANK VALUES (22, 'Powell North Branch', '7451 Sawmill Pkwy', 'Powell', 'OH', 43065);
INSERT INTO BANK VALUES (23, 'Brentwood Branch', '1800 Brentwood Road', 'Brentwood', 'NY', 11717);
INSERT INTO BANK VALUES (24, 'Birdrock Banking Center', '5605 LA Jolla Blvd', 'LA Jolla', 'CA', 92037);
INSERT INTO BANK VALUES (25, 'Lake Worth Road Branch', '6492 Lake Worth Road', 'Lake Worth', 'FL', 33463);
Commit;
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (0,'Jainna','Female','4651 Trainer Avenue, Peoria, Illinois','USA','309-518-7596');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (1,'Tyrion','Male','2191 Nash Street, Livonia, Michigan','USA','313-247-8612');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (2,'Annaleigh','Female','2780 Adonais Way, Marietta, Georgia','USA','678-419-6591');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (3,'Arlene','Female','1495 Timber Ridge Road, Richgrove, California','USA','916-828-5971');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (4,'Tsukiko','Female','1835 Alpha Avenue, Baldwin, Florida','Japan','904-266-5681');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (5,'Duante','Male','4271 Fairway Drive, Oakland, California','USA','707-519-5527');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (6,'Veradisia','Female','2671 Meadow Lane, Dublin, California','USA','707-340-1173');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (7,'Tangie','Female','2840 Stoney Lonesome Road, Pompano Beach, Florida','USA','570-353-4612');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (8,'Daquan','Male','2933 Preston Street, Wichita, Kansas','USA','620-910-9827');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (9,'Makalia','Female','2532 Lightning Point Drive, Salter Path, North Carolina','USA','901-569-7618');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (10,'Colandra','Female','1599 Oak Ridge Drive, Cape Girardeau, Missouri','USA','573-587-0134');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (11,'Emelyn','Female','3495 Centennial Farm Road, Hawarden, Iowa','USA','712-552-1930');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (12,'Meliffany','Female','369 Joseph Street, Waukesha, Wisconsin','USA','262-873-7955');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (13,'Brykita','Female','3518 Byrd Lane, Albuquerque, New Mexico','USA','505-252-6475');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (14,'Deja','Female','520 Fire Access Road, Advance, North Carolina','USA','336-909-2186');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (15,'Chevelle','Female','2205 Hope Street, Portland, Oregon','USA','971-232-0675');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (16,'Prudencia','Female','1124 Worley Avenue, Charlottesville, Virginia','USA','434-481-7385');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (17,'Sedona','Female','4194 Rockwell Lane, Rocky Mount, North Carolina','USA','252-562-6219');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (18,'Hiromichi','Male','522 Cook Hill Road, Bridgeport, Connecticut','Japan','203-521-0374');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (19,'Elitia','Female','597 Carolina Avenue, Brownsville, Texas','USA','956-838-0814');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (20,'Amara','Female','3524 Rocky Road, Antelope, Montana','India','215-625-8838');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (21,'Naruto','Male','2825 Pinnickinick Street, Burlington, Washington','Japan','360-757-7216');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (22,'Melinda','Female','2238 Godfrey Road, New York, New York','USA','212-588-9284');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (23,'Quineisha','Female','1586 Chicago Avenue, Waite Park, Minnesota','USA','559-501-4460');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (24,'Veradisia','Female','967 Ingram Street, Dayton, Ohio','USA','937-536-0178');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (25,'Leighanne','Female','2290 Maxwell Street, Bloomfield, Connecticut','USA','860-710-9788');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (26,'Destiny','Female','4546 Parrish Avenue, Sattler, Texas','USA','830-907-6289');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (27,'Kesia','Female','3715 Oakwood Avenue, Cullman, Alabama','USA','212-624-4884');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (28,'Ezell','Male','689 Chestnut Street, Tampa, Florida','USA','727-452-8453');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (29,'Leighanne','Female','4802 Meadowcrest Lane, Barataria, Louisiana','USA','606-418-1535');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (30,'Hodor','Male','836 Eastland Avenue, Chino, California','USA','601-432-0170');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (31,'Eddard','Male','3945 Lang Avenue, Park Valley, Utah','USA','435-871-7714');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (32,'Marv','Male','3485 Settlers Lane, New York, New York','USA','917-802-7048');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (33,'Novalee','Female','1150 Chestnut Street, Winter Haven, Florida','USA','727-451-0516');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (34,'Daiki','Male','3888 Fairway Drive, Healdsburg, California','Japan','707-431-0739');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (35,'Mikayla','Female','3142 Mulberry Lane, West Palm Beach, Florida','USA','561-876-2954');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (36,'Quanita','Female','2010 Isaacs Creek Road, Decatur, Illinois','USA','217-424-3777');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (37,'Tamira','Female','4685 Monroe Street, Houston, Texas','USA','713-390-7171');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (38,'Lapronda','Female','3615 Pine Tree Lane, Mc Lean, Maryland','USA','240-492-1798');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (39,'Julissa','Female','1793 Paradise Lane, Claremont, California','USA','909-625-4284');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (40,'Studs','Male','4989 Oak Drive, Albany, New York','USA','518-528-9972');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (41,'Sharlene','Female','4441 West Drive, Lombard, Illinois','USA','312-437-5328');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (42,'Candie','Female','1266 Rosemont Avenue, Los Angeles, California','USA','323-227-3367');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (43,'Hisayo','Female','2545 Cherry Ridge Drive, Warren, Michigan','Japan','586-268-8825');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (44,'Jamareon','Male','1099 Watson Lane, Henryville, Pennsylvania','USA','828-980-7255');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (45,'Jayashri','Female','2619 Ray Court, Murrayville, Illinois','India','910-262-9951');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (46,'Cherine','Female','3275 Pursglove Court, Dayton, Ohio','USA','937-277-0698');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (47,'Chailyn','Female','1042 Essex Court, Grand Isle, Vermont','USA','802-372-3858');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (48,'Eara','Female','1602 Jail Drive, Harbor Beach, Michigan','USA','309-975-6042');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (49,'Latanya','Female','4774 George Street, Beverly Hills, Florida','USA','352-527-6723');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (50,'Novalee','Female','1089 Poplar Chase Lane, Boise, Idaho','USA','208-341-4280');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (51,'Roep','Male','624 Brentwood Drive, El Paso, Texas','USA','512-727-3972');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (52,'Shawanna','Female','857 Longview Avenue, Brooklyn, New York','USA','718-573-8688');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (53,'Janae','Female','1552 Caldwell Road, Rochester, New York','USA','585-303-7947');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (54,'Kikuyo','Female','3890 Candlelight Drive, Houston, Texas','Japan','281-448-6020');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (55,'Latanya','Female','3101 Memory Lane, Hopkins Park, Illinois','USA','815-944-2988');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (56,'Macadrian','Female','3358 Jody Road, Philadelphia, Pennsylvania','USA','140-646-9014');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (57,'Dilanne','Female','3886 State Street, San Diego, California','USA','313-971-2081');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (58,'Chantoya','Female','1974 Cerullo Road, Louisville, Kentucky','USA','502-361-0310');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (59,'Doniel','Male','4270 Metz Lane, Woburn, Massachusetts','USA','857-526-6735');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (60,'Jayashri','Female','511 Victoria Court, Alton, Maine','India','207-394-9366');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (61,'Jovie','Female','3996 Junkins Avenue, Albany, Georgia','USA','229-443-1118');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (62,'Jeana','Female','3904 B Street, New Brighton, Minnesota','USA','651-639-2772');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (63,'Racquel','Female','3756 Lodgeville Road, Tipton, California','France','612-335-5321');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (64,'Laina','Female','4491 Long Street, Ocala, Florida','USA','352-220-0159');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (65,'Isabis','Female','1358 White Lane, Macon, Georgia','USA','478-787-5620');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (66,'Dangereuse','Female','2344 Comfort Court, Verona, Wisconsin','France','608-230-7812');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (67,'Jennique','Female','4886 Benedum Drive, Poughkeepsie, New York','USA','845-350-2243');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (68,'Tomoko','Female','3574 Travis Street, West Palm Beach, Florida','Japan','772-519-0083');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (69,'Achelle','Female','4768 Meadowcrest Lane, Pikeville, Kentucky','USA','606-437-7212');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (70,'Adymn','Male','3169 Brown Avenue, Simpsonville, South Carolina','USA','864-967-8686');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (71,'Sharmane','Female','338 Worley Avenue, Charlottesville, Virginia','USA','434-326-0833');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (72,'Jenibelle','Female','3285 Thompson Drive, San Francisco, California','USA','510-367-5572');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (73,'Arnola','Female','4765 Raver Croft Drive, Knoxville, Tennessee','USA','423-714-6529');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (74,'Quanda','Female','3084 Fincham Road, Seekonk, Massachusetts','USA','760-509-7153');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (75,'Cherris','Female','50 Ersel Street, Red Wing, Minnesota','USA','214-338-0017');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (76,'Tiya','Female','2697 Ersel Street, Huntington, West Virginia','USA','214-364-9235');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (77,'Leon','Male','4642 Grove Avenue, Clinton, Oklahoma','France','580-383-8391');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (78,'Jaheim','Male','2778 Glenwood Avenue, Beaverton, Oregon','USA','216-344-9364');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (79,'Laquinta','Female','872 Wines Lane, Bayside, New York','USA','832-265-1597');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (80,'Kimbella','Female','3330 Meadowcrest Lane, Winchester, Kentucky','USA','606-402-0214');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (81,'Kya','Female','3068 Kelley Road, Gulfport, Mississippi','USA','228-304-8624');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (82,'Jeor','Male','2711 Eden Drive, Richmond, Virginia','USA','804-828-2789');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (83,'Tameka','Female','4548 Harper Street, Tompkinsville, Kentucky','USA','270-487-3153');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (84,'Anada','Female','2394 Leroy Lane, Plankinton, South Dakota','USA','605-942-9843');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (85,'Sansa','Female','4663 Sampson Street, Denver, Colorado','USA','303-560-6980');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (86,'Coleka','Female','2313 Spirit Drive, Orange City, Florida','USA','386-851-0542');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (87,'Jazelle','Female','4955 Philadelphia Avenue, Morgantown, West Virginia','USA','801-282-6624');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (88,'Marlie','Female','1436 Carriage Court, Camp Pendleton, California','USA','760-385-7041');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (89,'Coco','Female','3254 Wood Street, Saint Johns, Michigan','USA','989-224-0083');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (90,'Jolivette','Female','4026 Traders Alley, Kansas City, Missouri','USA','816-439-4539');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (91,'Lizina','Female','2838 Petunia Way, Birmingham, Alabama','USA','205-799-0637');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (92,'Anjolie','Female','2692 Chandler Drive, Republic, Missouri','USA','417-732-2486');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (93,'Shevaughn','Female','822 Lynn Ogden Lane, Orange, Texas','USA','409-883-4130');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (94,'Celous','Male','898 Quilly Lane, Columbus, Ohio','USA','614-501-0498');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (95,'Marilee','Female','4306 Blackwell Street, St Marys, Alaska','USA','907-438-0667');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (96,'Dashania','Female','425 Smith Road, Marietta, Georgia','USA','770-951-2147');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (97,'Sariah','Female','4760 Randall Drive, Kahului, Hawaii','USA','808-871-4072');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (98,'Joshlynn','Female','786 Tyler Avenue, Hialeah, Florida','USA','305-363-0370');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (99,'Ellasyn','Female','1113 Green Acres Road, Spring Hope, North Carolina','USA','252-478-1164');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (100,'Avayah','Female','1538 Shingleton Road, Grand Rapids, Michigan','USA','269-357-7957');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (101,'Gerianne','Female','2887 Camden Place, Bluffton, South Carolina','USA','843-836-2124');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (102,'Morrisa','Female','603 Shobe Lane, Aurora, Colorado','USA','970-452-6635');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (103,'Nichole','Female','3355 Eagle Street, East Saint Louis, Illinois','USA','618-397-8653');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (104,'Joshwa','Male','1554 Mulberry Avenue, Little Rock, Arkansas','USA','501-433-7448');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (105,'Davion','Male','1518 Gateway Avenue, Bakersfield, California','USA','689-840-3389');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (106,'Uki','Female','3344 Stadium Drive, Mansfield, Massachusetts','Japan','508-304-4186');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (107,'Shaunna','Female','422 Sycamore Street, San Jose, California','USA','408-973-9751');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (108,'Davion','Male','3775 Point Street, Burr Ridge, Illinois','USA','773-903-9832');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (109,'Jessa','Female','4163 Victoria Court, Bucksport, Maine','USA','207-469-4715');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (110,'Carrie','Female','1595 Heliport Loop, Corvallis, Oregon','USA','812-717-7879');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (111,'Oaklynn','Female','1502 Joanne Lane, Quincy, Massachusetts','USA','978-428-9160');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (112,'Iyeshia','Female','1303 Spring Avenue, Norristown, Pennsylvania','USA','267-653-1121');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (113,'Condoleeza','Female','1030 Goosetown Drive, Charlotte, North Carolina','USA','828-615-4663');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (114,'Sarda','Female','652 Sardis Station, Newton, Texas','USA','612-385-8921');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (115,'Benniton','Male','345 Pheasant Ridge Road, Ambler, Pennsylvania','USA','215-540-6689');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (116,'Tandice','Female','288 North Street, Orlando, Florida','USA','434-961-1751');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (117,'Linaeve','Female','2386 Chapmans Lane, Carlsbad, New Mexico','USA','505-887-2211');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (118,'Jayla','Female','4045 Ward Road, El Paso, Texas','USA','915-383-8674');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (119,'Stannis','Male','691 Stoney Lane, Dallas, Texas','USA','972-894-8595');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (120,'Chelsia','Female','3058 Green Street, Oak Grove, Tennessee','USA','615-572-0094');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (121,'Darion','Male','179 Overlook Drive, Indianapolis, Indiana','USA','765-327-4842');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (122,'Lol','Female','1780 Bruce Street, Manchester, Missouri','USA','314-258-7898');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (123,'Keshawn','Male','3775 Point Street, Burr Ridge, Illinois','USA','773-903-9852');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (124,'Datherine','Female','1016 Cabell Avenue, Alexandria, Virginia','USA','703-536-8536');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (125,'Maree','Female','3225 Winding Way, Providence, Rhode Island','USA','401-679-3252');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (126,'Pink','Female','3167 Illinois Avenue, Portland, Oregon','USA','503-716-1346');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (127,'Astrea','Female','1774 Loving Acres Road, Kansas City, Missouri','USA','816-918-2735');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (128,'Drayson','Male','2352 Sunny Glen Lane, Cleveland, Ohio','USA','216-754-4593');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (129,'Bud','Male','620 Stone Lane, Reading, Pennsylvania','USA','610-375-2815');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (130,'Donae','Female','1238 Whitetail Lane, Richardson, Texas','USA','469-330-6412');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (131,'Meaghan','Female','3134 Washburn Street, Baton Rouge, Louisiana','USA','225-386-5945');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (132,'Danina','Female','887 Burwell Heights Road, Houston, Texas','USA','409-555-8233');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (133,'Lovie','Female','4961 Chicago Avenue, Reedley, California','USA','559-643-9593');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (134,'Carlynda','Female','865 Lake Forest Drive, Kansas City, Kansas','USA','913-915-7742');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (135,'Jodell','Female','3339 Oakway Lane, Dry Run, Pennsylvania','USA','818-288-8441');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (136,'Kateisha','Female','1040 Todds Lane, San Antonio, Texas','USA','210-565-4686');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (137,'Channery','Female','462 Platinum Drive, Greensburg, Pennsylvania','USA','724-836-1225');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (138,'Jaheim','Male','4832 County Line Road, Tampa, Florida','USA','727-843-9924');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (139,'Barbra','Female','4451 Mount Street, Marlette, Michigan','USA','989-635-2832');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (140,'Emmalia','Female','3047 Wilkinson Court, Fort Myers, Florida','USA','239-561-5811');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (141,'Finnick','Male','4086 Huntz Lane, Cambridge, Massachusetts','USA','978-627-3226');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (142,'Jaliyah','Female','2706 Wilkinson Court, Immokalee, Florida','USA','239-657-5924');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (143,'Akeelah','Female','1557 Sun Valley Road, Cle Elum, Washington','USA','509-852-3392');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (144,'Bevelyn','Female','1270 Walnut Avenue, Lyndhurst, New Jersey','USA','201-202-7943');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (145,'Shawna','Female','1451 Chenoweth Drive, Pulaski, Tennessee','USA','931-468-9598');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (146,'Abbatha','Female','4706 Hillside Street, Scottsdale, Arizona','USA','480-343-3934');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (147,'Garcelle','Female','2768 Hillside Drive, Cambridge, Massachusetts','USA','339-814-4513');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (148,'Dericia','Female','3102 Bingamon Road, Cleveland, Ohio','USA','440-551-6647');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (149,'Vadin','Male','1815 Lilac Lane, Savannah, Georgia','India','925-441-6325');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (150,'Myeisha','Female','4205 Romines Mill Road, Dallas, Texas','USA','214-674-0148');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (151,'Donda','Female','4208 Meadow Drive, Billings, Montana','USA','406-213-1384');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (152,'Akilah','Female','4453 Fire Access Road, Alberton, Montana','USA','336-922-9931');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (153,'Kennita','Female','4336 Echo Lane, Grand Rapids, Michigan','USA','269-759-4699');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (154,'Bev','Female','4150 Hart Ridge Road, Grayling, Michigan','USA','989-344-0044');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (155,'Keisha','Female','3795 West Street, Baltimore, Maryland','USA','616-723-2717');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (156,'Vashon','Male','729 Brown Avenue, Knoxville, Tennessee','USA','865-238-7844');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (157,'Jayvon','Male','3054 Sunrise Road, Boise, Idaho','USA','702-988-1289');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (158,'Lancelot','Male','3255 Turkey Pen Lane, Dothan, Alabama','France','334-498-8861');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (159,'Ambrea','Female','887 Ottis Street, Yukon, Oklahoma','USA','405-354-5378');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (160,'Dularee','Female','3272 Charter Street, Olathe, Kansas','India','913-791-7235');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (161,'Efrain','Male','1849 Gateway Road, Tigard, Oregon','USA','503-332-1317');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (162,'Adita','Female','2590 Blackwell Street, Winger, Minnesota','India','907-383-2640');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (163,'Saundra','Female','2556 Cody Ridge Road, Henry, Tennessee','USA','580-539-7049');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (164,'Patch','Male','3694 Kennedy Court, Bedford, Massachusetts','USA','774-541-3141');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (165,'Richelle','Female','945 Brooklyn Street, Eugene, Oregon','USA','541-238-4843');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (166,'Ishan','Male','626 Cerullo Road, Louisville, Kentucky','India','502-417-4058');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (167,'Timila','Female','4727 Carolyns Circle, Dallas, Texas','India','214-703-4826');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (168,'Nikki','Female','3991 Hill Croft Farm Road, Sacramento, California','USA','530-555-6912');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (169,'Katsurou','Male','2384 Smithfield Avenue, Lubbock, Texas','Japan','806-776-3030');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (170,'Isako','Female','489 Trymore Road, Vesta, Minnesota','Japan','507-762-7814');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (171,'Herman','Male','4651 Hanover Street, New York, New York','Germany','917-716-6457');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (172,'Dason','Male','2979 Horizon Circle, Tacoma, Washington','USA','253-531-6464');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (173,'Oralee','Female','2196 Hannah Street, Asheville, North Carolina','USA','828-338-4646');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (174,'Mandelina','Female','4757 Reynolds Alley, Bellflower, California','USA','562-285-6053');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (175,'Orrtha','Female','3007 Oak Ridge Drive, Saint Louis, Missouri','USA','573-552-7343');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (176,'Nelton','Male','1024 Cinnamon Lane, San Antonio, Texas','USA','210-832-6950');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (177,'Raylan','Male','1842 Rockford Mountain Lane, Appleton, Wisconsin','USA','920-225-0089');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (178,'Jailene','Female','1594 Duke Lane, Cassatt, South Carolina','USA','732-771-9287');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (179,'Shaunta','Female','1197 Oak Street, Syracuse, New York','USA','315-270-7770');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (180,'Arissa','Female','458 Summit Park Avenue, Southfield, Michigan','USA','248-942-7513');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (181,'Huck','Male','3334 Bedford Street, Norwalk, Connecticut','USA','203-945-8362');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (182,'Artie','Male','1095 Martha Ellen Drive, Reno, Nevada','USA','775-796-7021');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (183,'Jevin','Male','967 Glory Road, Collinwood, Tennessee','USA','931-724-4059');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (184,'Jesiah','Male','2985 Jennifer Lane, Raleigh, North Carolina','USA','919-447-9875');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (185,'Elmarie','Female','2849 Patterson Fork Road, Chicago, Illinois','USA','312-562-9587');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (186,'Shawnda','Female','2862 Williams Mine Road, Elizabeth, New Jersey','USA','908-289-0969');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (187,'Kelis','Female','3137 Myra Street, Bedford, Rhode Island','USA','401-526-7713');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (188,'Jamarcus','Male','3143 Payne Street, Beallsville, Maryland','USA','276-807-5889');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (189,'Irela','Female','4330 Christie Way, Framingham, Massachusetts','USA','978-831-6652');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (190,'Chamomile','Female','769 Center Street, Fresno, California','USA','559-208-6426');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (191,'Myeisha','Female','3388 Locust View Drive, San Francisco, California','USA','415-982-0772');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (192,'Sherlyn','Female','2325 Chicago Avenue, Fresno, California','USA','559-868-4886');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (193,'Ridhi','Female','4446 Steele Street, Houston, Texas','India','630-665-5465');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (194,'Karleshia','Female','1764 Bird Street, Tacoma, Washington','USA','505-633-2859');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (195,'Kaspar','Male','595 Pearcy Avenue, Wolcottville, Indiana','Germany','260-854-8528');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (196,'Malisha','Female','1313 Lakewood Drive, Secaucus, New Jersey','USA','201-829-8635');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (197,'Shaylynn','Female','1455 Rhode Island Avenue, Washington, Washington DC','USA','202-331-7137');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (198,'Lorene','Female','3894 Colony Street, Wallingford, Connecticut','USA','203-269-7981');
Insert into HOLDER (H_ID,NAME,SEX,ADDRESS,NATIONALITY,PHONE_NUMBER) values (199,'Ianna','Female','1999 Waldeck Street, Denton, Texas','USA','817-403-1183');
Commit;
INSERT INTO DNG_HOLDER VALUES (73, 93.94);
INSERT INTO DNG_HOLDER VALUES (136, 92.97);
INSERT INTO DNG_HOLDER VALUES (152, 98.09);
INSERT INTO DNG_HOLDER VALUES (185, 92.55);
INSERT INTO DNG_HOLDER VALUES (11, 94.68);
INSERT INTO DNG_HOLDER VALUES (90, 92.08);
INSERT INTO DNG_HOLDER VALUES (199, 90.69);
INSERT INTO DNG_HOLDER VALUES (40, 96.11);
INSERT INTO DNG_HOLDER VALUES (188, 90.77);
INSERT INTO DNG_HOLDER VALUES (45, 91.64);
INSERT INTO DNG_HOLDER VALUES (7, 94.97);
INSERT INTO DNG_HOLDER VALUES (1, 92.1);
INSERT INTO DNG_HOLDER VALUES (173, 93.3);
INSERT INTO DNG_HOLDER VALUES (128, 94.2);
INSERT INTO DNG_HOLDER VALUES (4, 90.24);
INSERT INTO DNG_HOLDER VALUES (83, 91.87);
INSERT INTO DNG_HOLDER VALUES (146, 97.13);
INSERT INTO DNG_HOLDER VALUES (62, 90.29);
INSERT INTO DNG_HOLDER VALUES (80, 97.84);
INSERT INTO DNG_HOLDER VALUES (105, 95.58);
Commit;
INSERT INTO ACCOUNT VALUES ('011954352501', 1184744, '7ea87c1a2d26f655fea9a5f3cd2ebf6811b28bf067acb2cee13001ce4f92563e', 65);
INSERT INTO ACCOUNT VALUES ('052803119033', 1982331, '5081cabfcd7db1f9adc4589b5e36238d3730af1861a3db39c6211542175406e1', 43);
INSERT INTO ACCOUNT VALUES ('057518800352', 690774, 'd61ade16f8ef6d79f99fe8e22980aaf0c138896be3dd6c9b4c896d57bcff64dd', 60);
INSERT INTO ACCOUNT VALUES ('101407441009', 73662, 'f95a59e9e4595fee49522a15bb7dd6d9a0e997127977d07d2283191f5486e790', 71);
INSERT INTO ACCOUNT VALUES ('011149240176', 392754, '6a0cc37f573212d972023061d98b37d7a4dc52f39b6a43a89f3acd57b37327f4', 22);
INSERT INTO ACCOUNT VALUES ('003137006202', 1007117, '2c39379185fa4b5292df4f37d9d862ce64639af3f8fee69aca08fc70b92bf854', 120);
INSERT INTO ACCOUNT VALUES ('057084098979', 1973966, '302ef3f834a55a2d217c026c6d12564d7c0bded6730cb5e8ef683b3ca3b37941', 150);
INSERT INTO ACCOUNT VALUES ('057442301506', 304879, '018b806679f0279d9c196710d34aa654f9547b3ea32571c4ad2920047b5be8dd', 97);
INSERT INTO ACCOUNT VALUES ('057261773990', 533737, 'c69e2eec5bb7d5a6e21a31a7e0fed0b58f6dc73799d2ab63ff286194447b54ce', 57);
INSERT INTO ACCOUNT VALUES ('101142061799', 738706, '74275bd02f6c3993a06174219c1d99fe21099b74ec87f3befd389e4b5554640b', 46);
INSERT INTO ACCOUNT VALUES ('057319873710', 673764, '15d16fde77835a265475cbb8199c125b75bb1cc7d3f8cbceef7145e1ba50e7c6', 160);
INSERT INTO ACCOUNT VALUES ('101117740739', 1350275, '65f4df672536c565bd18a6ea6a7133ea03542ddbd7b255e5550af047c0f7a281', 17);
INSERT INTO ACCOUNT VALUES ('057235750774', 799060, 'f37213895a2d39a5d862fc81232685fc213962bb861b415c17cfd4b862f356db', 88);
INSERT INTO ACCOUNT VALUES ('003858892273', 1100379, '588847391d9a52b6bbe442d5321af1d9d41e1bfdc173c0f123a984dddf897a9a', 86);
INSERT INTO ACCOUNT VALUES ('101021791107', 29294, '130a4ecdb11afb8621d7097c14329cd5c356a9c11dc9a772df14509dbd5662a9', 82);
INSERT INTO ACCOUNT VALUES ('101693522641', 496678, 'ae6def8993e437c0e49d6b5d0f1a22f4cc6289542e9cbff9e5ac98807c3e2f96', 77);
INSERT INTO ACCOUNT VALUES ('003569596128', 548865, '2c5b3ad931dc9006aad0359ed48d4c88820a803ea285653a47f92e95a9e88c44', 101);
INSERT INTO ACCOUNT VALUES ('052997048486', 972475, '78efb51813edaa75dd747f3126449a676c8adc42319fc649979049972abfb8af', 56);
INSERT INTO ACCOUNT VALUES ('011225810264', 641045, 'f919cafa11a8b1fe598f5eec7ef0a50bf36a59c4ce685fd5dec7b2c3aa5dfe5c', 122);
INSERT INTO ACCOUNT VALUES ('101595234458', 1131763, '3dfca3b2435bd5bedc86e2f69cd2dc04c8ba37a2e1e62718099e794c12840fcd', 199);
INSERT INTO ACCOUNT VALUES ('101335585762', 104291, 'f5a8d0dc2f501c964bf63e10984e3562fc74e21d9bb19753943e09fdbf5e6441', 27);
INSERT INTO ACCOUNT VALUES ('003943484500', 1903830, '4d5cd3eecfe634272da2e93c9f27e1a0f04cc22c5fa42f704a7275d5a38e90f6', 53);
INSERT INTO ACCOUNT VALUES ('003278624111', 445257, '7ccb495cd83191eec9303592bc5ced7391f6768f88c33ad5023bd5f297bc45fb', 137);
INSERT INTO ACCOUNT VALUES ('057886228306', 778103, '0739c0d327a341f8019ac92e2bf5ea606896c765a48f4e7c7d72d555ec706543', 12);
INSERT INTO ACCOUNT VALUES ('101424863051', 1272512, 'aa21d488f7bbd89519f23ddc02a3549bba030fb8402f9d099d7debbe3e1f397f', 93);
INSERT INTO ACCOUNT VALUES ('057225463149', 485363, '6dfb470cb10db9a4855afd405a023a866c73f18ba9558c8a8592b245d040c2dd', 194);
INSERT INTO ACCOUNT VALUES ('057477132870', 1643854, '52ab868a354d6ec31fb688222169d3043508212abab109327ca86bb94cd40d90', 92);
INSERT INTO ACCOUNT VALUES ('057295435415', 560350, 'edd3fb6baf667ba6731d2de6c93c2b72a3bd75b529bd4b248c39f5ee9e6b07cb', 33);
INSERT INTO ACCOUNT VALUES ('052582428379', 1435823, 'c896a71a84677289b1aeb0e79c87c406591819c55099e2866bfa04dde80654a4', 1);
INSERT INTO ACCOUNT VALUES ('011909198382', 317859, '2eb6b4944df407b492e5c1812913f1a34e90d9797fe73de67305e6832b100517', 0);
INSERT INTO ACCOUNT VALUES ('011580381107', 1030745, 'f90f879a7fb74c93fcfde7e0ccfa83f14c612c3342e083b945892370dcd4208f', 170);
INSERT INTO ACCOUNT VALUES ('052730201364', 1801704, 'bc63e165f6abc411d47364fee140f4c3c5fc6c61fa496b89a80684d987c80d97', 118);
INSERT INTO ACCOUNT VALUES ('057910663379', 314680, '4c8ecbb8e3a5d0a7276adf81b3d386f1bddd4c5723d875b053aa397cfdbd20f1', 168);
INSERT INTO ACCOUNT VALUES ('052531069330', 10022, '1b221fe1459bdd96d234d68883a20f77aee0821fa9b6fac11552c65c1d0f9b5c', 138);
INSERT INTO ACCOUNT VALUES ('003851388311', 378728, '868406bd11aa90328ea005b82d25d4c09041f494f426dbd85f7a5aa554e1097e', 7);
INSERT INTO ACCOUNT VALUES ('011933182651', 614931, 'e6beb29e110fd94509b2c54fb6f67c24684489bd5483f3311258727d35df5406', 106);
INSERT INTO ACCOUNT VALUES ('003984724883', 335814, '457184b62e0f2f2928e3af829c0af9b0761af20b9a63d00532e5044ce536735b', 6);
INSERT INTO ACCOUNT VALUES ('011311287885', 1140836, '2224e6585ae57757cba8d40da472bf1771de02488d638ee7ded906dcebca47ee', 3);
INSERT INTO ACCOUNT VALUES ('057832164618', 1206774, '118c71c7548ad94d3010ca3a57a91f1da4188fc5d3ae5a28a9063785cbd1d7b9', 63);
INSERT INTO ACCOUNT VALUES ('057357816051', 94514, 'b068d6e7d6ae4e822fb9fb1b1201b61309463fbcaeb03be7a10d07cde2568918', 61);
INSERT INTO ACCOUNT VALUES ('057480841627', 582971, '8fba8e2dc7a66f4250fc114bf6eb616d9654f2e1e4c966e55d1c1ce60f6a635d', 116);
INSERT INTO ACCOUNT VALUES ('011555061659', 1065664, '101f554f1fddd898e8558b5482bf7a1ac6a46c9da41fc28062ceef8bea9d9bc4', 31);
INSERT INTO ACCOUNT VALUES ('052599785220', 1678836, '12fb26e677882bca87b2531994e46c716623dff56c42c064a745f64bd396c447', 96);
INSERT INTO ACCOUNT VALUES ('011443261999', 501943, '441651e50c94fd761a720d8a88efb9a52906f3e8fde2205f6e68802a16f63034', 34);
INSERT INTO ACCOUNT VALUES ('003867477392', 712358, '69b8b0fc1a506e0475880d4431c98fda66a8f3c34484f17a23417b727e361d5d', 126);
INSERT INTO ACCOUNT VALUES ('011949065994', 868467, '1f94d62224af17f484bb7f938321d6bf4c0f018f1271fea40a1220aa8ac21554', 13);
INSERT INTO ACCOUNT VALUES ('057650774252', 734616, '557c34936e3e631054fe21cbe613fa1d03b648c91ca58f1667cd0ca0a0298072', 20);
INSERT INTO ACCOUNT VALUES ('052294474267', 779216, '1c23a10c1cbe8a7434df568ab02692a78cdf22380cc4c7050edc7dc04dadd43e', 183);
INSERT INTO ACCOUNT VALUES ('003953613760', 782086, 'd8f4a8c63c2e51b2ec33cda433762879eef23cfaa916bc712ca1e404d59dc400', 174);
INSERT INTO ACCOUNT VALUES ('101219379546', 1353399, 'e292e5eee3e1bb49e180533e66eaf5481efe4e1175c23a46d9f1a39248bb7d06', 45);
INSERT INTO ACCOUNT VALUES ('052971554289', 46349, '0743fdd8e270a51b5b44ff53ce1a168786709410e470cfb883a1395998959bbb', 119);
INSERT INTO ACCOUNT VALUES ('057983606917', 354765, '68f2fd74b0649f9372ae4e5203c72618c7b5a4af2a50b44545f405a956a3795c', 127);
INSERT INTO ACCOUNT VALUES ('057565924564', 1013207, '1f6cffd257d67b0da14067dbe9b8472df1a42de448304f4dcaa8fd47bf015241', 128);
INSERT INTO ACCOUNT VALUES ('011993250517', 292500, '8bdd40e906f5389e6ccae8d5075d471caa12fe286d4ef369c6992fd22f3b03ac', 26);
INSERT INTO ACCOUNT VALUES ('003446112496', 2000707, 'a76655fcf4b5d376845761dba31b6476c4cd7515c38d39d37f461abd10987dd2', 193);
INSERT INTO ACCOUNT VALUES ('052724495892', 772120, '21069a420775bcc72d27beea0494e090cb971120530d407cdcf189151fea1818', 161);
INSERT INTO ACCOUNT VALUES ('101699375837', 1025187, '961dfc644da93313d26bb7acca1179a7df8d94abffbbb74f0446771d7b2d54d6', 152);
INSERT INTO ACCOUNT VALUES ('052571837993', 1887253, 'c8208dc1feff89814dcc33af5952b1c1a4d5c0ea2f473259a2c686e811e48555', 141);
INSERT INTO ACCOUNT VALUES ('057132673282', 112055, '6c7c3e037d1858f94be09cc181968056933702aed34d7a0e92a94bab1c42ca3b', 195);
INSERT INTO ACCOUNT VALUES ('052775358563', 1083702, '97fa44d28f1cb4435b73d2b2f82b9b53d8a820ca3e2e48d1c46600ec7ad1cd58', 78);
INSERT INTO ACCOUNT VALUES ('011522995891', 450148, '5d5740ac326612ccc8678710356b5a3746e2f23c01d38c6ac66ca946922b24c4', 158);
INSERT INTO ACCOUNT VALUES ('052771093716', 369639, '126a539c4e3bfd1fec2dd5b843d08942bc16aaf3d9d39eeeb5f3bd1b30776fd6', 15);
INSERT INTO ACCOUNT VALUES ('101245269417', 191094, 'c72df05698bfc18e02ee1e5b1dac0484c6ceaf70815ba550d83e7def48531ae2', 84);
INSERT INTO ACCOUNT VALUES ('052256693637', 959394, '06058dfa913a75485f5428b1bc33b5cd71e8748f308238d285babb109fe42299', 51);
INSERT INTO ACCOUNT VALUES ('052905438795', 1201977, '09d0b28c632441bdcf1167ee42410fd89936f5eba281bcc931029a4e3f2c7573', 42);
INSERT INTO ACCOUNT VALUES ('052259444746', 1124477, '636b4f8c12402944cd4846cbe186d6c85a8946f7f6c1a024360ea2e6e21eb869', 132);
INSERT INTO ACCOUNT VALUES ('101752945820', 1362726, 'e323ea02281994e23733b686f3814967376f3aa7f69718a782b13b9f04f150dc', 8);
INSERT INTO ACCOUNT VALUES ('101263416078', 1186105, '728e8d165666cd493522f039451bbc2dce4521f54195fe0e48dde711f15aec86', 99);
INSERT INTO ACCOUNT VALUES ('003164934976', 717995, 'c78b7cc23370a2dd87ab0e3cfa82674640dd62f226b55302d039b0a83a58aaf3', 196);
INSERT INTO ACCOUNT VALUES ('003509484705', 115433, '5742e0fc5f607b083f768d0bdc7ce1fa38d71236fc1577472b60bdfc0402832e', 125);
INSERT INTO ACCOUNT VALUES ('003497357304', 2007721, 'a6f94e3da16f57531853d7b30780afaeba2a7f668152d3b85fc9cba6dac60a45', 111);
INSERT INTO ACCOUNT VALUES ('003278336504', 440288, '5010ec6351de37f61fc240d44996b31c5d51a8fdec677a9d44dbcc39e9e5e65b', 19);
INSERT INTO ACCOUNT VALUES ('101138994134', 2909601, '58d7ae0cefe46d19a14783ccc19bdd82b72e02056e9189ee2fd3e69f8540f975', 91);
INSERT INTO ACCOUNT VALUES ('003711468766', 640462, 'f3da367c532deaf9d33d4af16f7a763c833f54a39d5eb37c214b544d63c12b3b', 121);
INSERT INTO ACCOUNT VALUES ('057074827763', 1625503, '94efa307e32905e56779783f93b022356d2ae759483b7f91cbbac89422d51cad', 38);
INSERT INTO ACCOUNT VALUES ('003317306988', 753030, 'b0ce7e0d65e823ae29ed063f100f3b93e48a06249b87d321bf4bad6deac56af7', 32);
INSERT INTO ACCOUNT VALUES ('052926727133', 1713501, '0ad92e9e9d773583849722d11c95e7ef7ec01a19cea9208ea119a61a2588bfbb', 24);
INSERT INTO ACCOUNT VALUES ('101826759561', 1395685, 'b6d4434debbcab3d9651711a4ae92b92fbdf1e9516e93c56827b238e3d61955b', 157);
INSERT INTO ACCOUNT VALUES ('057907840045', 93153, '1cef71e97998207fd1c2964d953bc35937d1f7e73664c44b7a747e889bff01e5', 44);
INSERT INTO ACCOUNT VALUES ('057405791831', 504523, '8450d7f1b5ddf54e8f3688a2e38919174330ae99da65ec8685df0d0dcfd48577', 173);
INSERT INTO ACCOUNT VALUES ('011505448192', 1080979, 'a27c587b511d8402bed96b6dcf7dfd3dbcd49f366401c587f35fe8af97d93b12', 143);
INSERT INTO ACCOUNT VALUES ('057213642595', 96300, '2f796564c5ecbbe7e02efa9ec31ef79f928c707eb7fba17703f7fc908c603e95', 68);
INSERT INTO ACCOUNT VALUES ('003487782169', 52605, '17a42bd7659a4352dbee1de9b81c4fb0389f3da8650d4d0a876c632ff05ecdcf', 109);
INSERT INTO ACCOUNT VALUES ('003259993428', 555815, 'a9209f5fb58fded4cf7f3eb0b3fdc078190971063c1a2f6cc79747ae40a24249', 62);
INSERT INTO ACCOUNT VALUES ('011358007855', 1227694, 'f6c65eab2b87ddbaa8cad7585d77e0328d7384d40877c5ce8a072e560738fba0', 104);
INSERT INTO ACCOUNT VALUES ('052664482945', 1088690, '8ef74903cec7a7a7f3eba0ac8596027290c70e3cf091a270d3768eb9b981f94d', 66);
INSERT INTO ACCOUNT VALUES ('057319250399', 666960, '1ef5a4f3d2a33cc8e476dd6973509de4be789ffa8566a5525223c9d90145e7fd', 175);
INSERT INTO ACCOUNT VALUES ('003775667741', 185570, '22dba634f64ad61acae0aad403bf6525c44143263d2a82d98dfbbcad84b42e1e', 186);
INSERT INTO ACCOUNT VALUES ('003758093694', 1983279, '7e6d718f268004799d5a6b5d7fa3399936527d3d80c0c7741622ce3bdae6a043', 52);
INSERT INTO ACCOUNT VALUES ('011111704251', 952729, '8eda5a614c9e3ac4a00be2a862f5998c524c1ebaa8932e453ed2a13c3d86c1b9', 83);
INSERT INTO ACCOUNT VALUES ('101799833884', 1490536, '0784f5ddd85e939c62c6c689529fdae3a45ab7f8f0dac6412cdb3ce63db8220a', 9);
INSERT INTO ACCOUNT VALUES ('003130192246', 777880, 'c3cf96db0493b47303a38798998ee3fbd648f613888cdd54f1db659f3ea5074c', 134);
INSERT INTO ACCOUNT VALUES ('003750839063', 388635, 'bb085dbb5cf5df69739b3f3abe2c7f6110ec3eab03d102eb17b3890d9fe13d34', 72);
INSERT INTO ACCOUNT VALUES ('011454361977', 796178, '952b46deb9c3ea1ae3c68b0020ace7fc09884ed65b74d58ac8630b107cb2b0dd', 25);
INSERT INTO ACCOUNT VALUES ('101990468915', 444312, '80c2ebcd2664759526e9d27dc71145a3dc26c247b3145de2c29848514ca449dd', 147);
INSERT INTO ACCOUNT VALUES ('052498076466', 1069796, 'd4bf877ac274778064cf8932d6df1af165bbed693198425e23f1e6a05fab0f69', 48);
INSERT INTO ACCOUNT VALUES ('101118826403', 1815972, '490a554f005ca9aab0902d8d32d1da56f56086d6fb69745063910b5652ff7db5', 18);
INSERT INTO ACCOUNT VALUES ('011411316546', 1173253, '8b7b2f36db380f5f01f2365247950536268e12ed0aa5891e22da0835fe54883c', 87);
INSERT INTO ACCOUNT VALUES ('052551584345', 204667, '43f55816777fe8c5eee790b990dc6f51bbbde0763da5f6e6135f89c38b6d1849', 75);
INSERT INTO ACCOUNT VALUES ('011404409049', 1276532, '768e33603a9a71c5a174b63ef77aea868857556479c98264c776dabe34d9f11e', 76);
INSERT INTO ACCOUNT VALUES ('011568986365', 426613, 'f948929aa4fc5b4aecdcd0ba52b59a1fa599326a0d35b9f696a89884888451c3', 197);
INSERT INTO ACCOUNT VALUES ('003895130788', 1036748, '1058d01353d44f8fab1106ecbd80cc5887bea683c677f875dacd5c12b144620a', 188);
INSERT INTO ACCOUNT VALUES ('052228551390', 930520, '6a60e810b2fbba2e8b0048063e9c94fc3de84ca3a5b734c6f170484a2cd5753a', 146);
INSERT INTO ACCOUNT VALUES ('052912284608', 706477, 'f74e0da51b809741912dd72d03d9f356c31df537201438f6834fb91967a3c282', 129);
INSERT INTO ACCOUNT VALUES ('003901078505', 706801, '0f22071a6c8ff2b84de190e047c77928fedab3c4f76b35786fb94991f4dc76ff', 50);
INSERT INTO ACCOUNT VALUES ('003612343703', 75788, '24193cbd14a5c76aef53cf795460ec7311550bb42c169005610bf99297ec3ecf', 40);
INSERT INTO ACCOUNT VALUES ('101004053838', 970615, '952fe95c86ab027e48e984a1cd174feef7a66a586c8a2ec5202e767aca99e581', 114);
INSERT INTO ACCOUNT VALUES ('057433540109', 1228022, '733bac2515aef7e99b310b46d2808ba501890f658a69d760a025d7cb17edd170', 35);
INSERT INTO ACCOUNT VALUES ('101871956477', 195761, 'c3a142c17bc45ed4b20e7ac99a228bcd02fd3fe837f4c632fa325537547f51de', 85);
INSERT INTO ACCOUNT VALUES ('057032305924', 1109251, '0c46d37d87ea92eadcc5325d117c64645c20f630782c09339c6a5e87387c2972', 151);
INSERT INTO ACCOUNT VALUES ('003806703077', 115264, 'dc21d2c50a1798ea583e993d76e50ac77a8c205c1b94303e1c56ed41c7c82bde', 176);
INSERT INTO ACCOUNT VALUES ('003031531152', 544158, '4c6a36b3a39901b17de4b0ca43458fa065967e4f65953c7c1536a9bee85be797', 94);
INSERT INTO ACCOUNT VALUES ('052012273451', 584107, '5559b3ff491c457a3bd787ded703f0638ecc40c9077fb9166dd72760610dc1a5', 14);
INSERT INTO ACCOUNT VALUES ('052368315515', 684729, '6fb7970cad89ded20a5e8105b634de133bd989c620de57b37f03562968d409b6', 103);
INSERT INTO ACCOUNT VALUES ('057707938425', 1191540, '7766742c3acdf969dff630e590423ba44e9925a110777763e829a8faa0425d86', 70);
INSERT INTO ACCOUNT VALUES ('052506036039', 1635527, '66770a98e7a2c186ae7a25a8ae15b0fff61130e481889831edb61047c07ccfd6', 49);
INSERT INTO ACCOUNT VALUES ('052491451728', 805865, '9084789882fa92d4773f58f898468e1cb0f34659d3f688d78f033c8f4080f184', 142);
INSERT INTO ACCOUNT VALUES ('057753165528', 951713, '7a8102da52b045ef0c7494c09c60610059c29c49f434c64268591daec39c227b', 2);
INSERT INTO ACCOUNT VALUES ('052235387753', 1711760, 'd968263fb8d210c53b47b5cca452c53c6b313971bcf904dd9ad78d32dab05785', 171);
INSERT INTO ACCOUNT VALUES ('003622315453', 1079014, '179894db50ebeca0f26ca513dad7dfe2c1f5dc7ad3b715c2374d8a1d4351a167', 55);
INSERT INTO ACCOUNT VALUES ('057148071636', 581669, 'e94a29ddba7a131f79321af97519916907d93ee0065ed655b9926e24cfbd32c1', 123);
INSERT INTO ACCOUNT VALUES ('101196676777', 175851, '24e4e486f77cc201431858bfdb7c307eab63adb48c81d69ff6af850a7fa6c431', 115);
INSERT INTO ACCOUNT VALUES ('057039711411', 84046, '7cf7455a48c111ee2721fa15b6f7601fb7fddeacad118c643e9be5ca34e6f9cc', 180);
INSERT INTO ACCOUNT VALUES ('011644944135', 1468413, 'eaec0ba59cd065ff836033d4daa62185f6ee3fef3e79d897632c51e0b2cebc99', 136);
INSERT INTO ACCOUNT VALUES ('101261054980', 1317497, '042cb35373db37ab0226ce95e1413aa7504c14ff8df463fc08ef75c458934dd2', 41);
INSERT INTO ACCOUNT VALUES ('057432989791', 227340, 'cae57522d93ada97ca58a57f728b68bffd2af1a085f38d88733fbd4f57b1a7c6', 164);
INSERT INTO ACCOUNT VALUES ('057432797823', 1670778, '4a807696347e4cd885727c879530024b8f77f0ae4e9f811dd5db2b597674309f', 39);
INSERT INTO ACCOUNT VALUES ('057583798642', 608196, '4ca3204141dd059b867dee103793ed8313972ac0d270944ed21f32570a90d768', 133);
INSERT INTO ACCOUNT VALUES ('003533143867', 994207, '39880c0d405be6e9bd7cdd93658d094e87a975360386b2b5662396a179c20024', 107);
INSERT INTO ACCOUNT VALUES ('003775864330', 331424, '4fb32064a4654d5873d630d05b4099963c98d56a29e25f188b9c1a29ad9f8d68', 10);
INSERT INTO ACCOUNT VALUES ('057149752973', 1376217, '3a4f382ba97de79998616b32a04ad9393bd8c356f0cb6e9a27d0d7b5b87a049a', 58);
INSERT INTO ACCOUNT VALUES ('003584409661', 335471, '6e86ef9161e6d77e81c284de54f45387c8373aa6e096673c6c2ab40677ae8755', 79);
INSERT INTO ACCOUNT VALUES ('052087482502', 1817095, '5faa1794a85c825fc4bd01cff152d0a24870f385d28b728a82881149cd9f0e15', 21);
INSERT INTO ACCOUNT VALUES ('101773948496', 698216, '2a01be0b48e0d8159b4a67d8dfeffb7a0867d4f56a1c520cffdadd4d82017bc5', 23);
INSERT INTO ACCOUNT VALUES ('052652551530', 404743, '69adcd60d71f98ad511fcf393e4d0e3b19f316a23b30f7e8cc75c38d21c20eab', 185);
INSERT INTO ACCOUNT VALUES ('003285144112', 39738, 'f74d7cdc8549038835ea7cf97978b11397e018362f5df4cd75eab3e2c8768c44', 73);
INSERT INTO ACCOUNT VALUES ('052180879234', 489419, '226b629ab663b53267f33634559913a4e7ad78ebfd058d5aaf3e6fc6a1cb83c7', 105);
INSERT INTO ACCOUNT VALUES ('011861391330', 1542468, 'edd6d70cb51c3d3923d939160de1995c08e6a38553624d90903b00dcf74bc007', 182);
INSERT INTO ACCOUNT VALUES ('003313119959', 1358855, 'b3916815bbcce7f9740c1430413d1477f52d81f0f5b5f3a31a5b629ef11cb17f', 165);
INSERT INTO ACCOUNT VALUES ('011952364922', 714146, '295a372c71d6e98ff3b8459735d5326c257dc81687dc815e2fa16be6d3b82948', 5);
INSERT INTO ACCOUNT VALUES ('011102451715', 1565133, '75434c2d85c429cbf3758d69da40459655f6e0758eae36dfdf7900abf89b0a2b', 192);
INSERT INTO ACCOUNT VALUES ('057579776016', 1233915, '2aa9e1e5fa9ef1d82bb7c6ddafddb01dcef16b36718d7f1f2c46c6a5ce5cd9a4', 177);
INSERT INTO ACCOUNT VALUES ('052808593823', 779830, 'fde5de760aaa15c3639b9213acdd231a1bdc19b8c8ee8f8fedd5577b5c0b0634', 98);
INSERT INTO ACCOUNT VALUES ('011542261016', 276421, '43be9899cb70cf82210aca4c15d92e9960335179db0082c36a7580e08d6efc0b', 36);
INSERT INTO ACCOUNT VALUES ('057806694975', 573634, '674747fae98f13e80f8998eb05b3c338f1ccdff0c0b294f6c81b32a8e82776b8', 80);
INSERT INTO ACCOUNT VALUES ('052503713563', 928436, 'c559fd6acae3d1d8d26c359a7ea27ec4881199ddeacf366c97cac95bee3aabb7', 102);
INSERT INTO ACCOUNT VALUES ('011283061798', 746835, '05fc0eb8032e514eed8accabde90231fbcff314bc2589c01d51087fcf7bcc4b1', 67);
INSERT INTO ACCOUNT VALUES ('003126803450', 607907, '040207cf5b1a3fefef3d31c2832075c9452fd778938d0c45e3da6003eb69a059', 47);
INSERT INTO ACCOUNT VALUES ('011614894570', 30292, 'd437050ea7cd823dfd74999f8a355c6398d2f32d3bd7f299cfa1dc05d4b22619', 189);
INSERT INTO ACCOUNT VALUES ('003169157183', 21912, '10d818477c782b777eaf4c2dcf11daf69d9c6c12a1f552af53a06cb9457e3c20', 74);
INSERT INTO ACCOUNT VALUES ('011799622281', 775187, '55951835b84ccc5a5ebc34fd2168ed78819d2d4a3301ac73894f2369ecc07c98', 191);
INSERT INTO ACCOUNT VALUES ('101749015013', 2153399, '9c2c33bb74d78b0ffa28961434bde89942bc4d189bc90a176e4f79429915c0ee', 154);
INSERT INTO ACCOUNT VALUES ('011341847461', 282062, 'e62c18460fa666e28096845d7df3540cecb8da58d015e01cab8ecf4b38effd0a', 110);
INSERT INTO ACCOUNT VALUES ('052488740494', 1265612, '8f7f7b60a22eb59ec6a50da76b5793c8492900f9a4c50c8968ee5f8021dd7ad9', 181);
INSERT INTO ACCOUNT VALUES ('101590346811', 663021, 'f85a35f0a44629d31498801ec75d0f3e4b08253dad1c305c74d75193f54ef035', 187);
INSERT INTO ACCOUNT VALUES ('052199848337', 1834365, 'b9c62b549ab2ad333020aa12ee9a9bc4e8ec61adcddcb800700ce53336366c54', 37);
INSERT INTO ACCOUNT VALUES ('052442805646', 2416747, '390cad6cc605c4a3a58c3ab369e2a9fdd49bf8db525214f149be08e7d314e983', 11);
INSERT INTO ACCOUNT VALUES ('003912903911', 778864, '971fe6adb8bc873c45c80ff6992e37491b38e6a22a67b1ea223448ef58e1efee', 124);
INSERT INTO ACCOUNT VALUES ('057640205129', 1251938, 'f3c337f4d58cd71f2545983fa9393dbfc49f96a7b495b33290166d444fed37bf', 4);
INSERT INTO ACCOUNT VALUES ('052626677309', 1019966, '848140f09987d940d0e2f249ad3c879490f492832134229837bf19dc524d36c3', 145);
INSERT INTO ACCOUNT VALUES ('101432177729', 1323553, '02cea54b6cadbd4142e422a6832f7e7c92208f168b4be6f4f528798efd83b99e', 190);
INSERT INTO ACCOUNT VALUES ('052220618123', 1148381, 'c60cea98bdcbb3495e8a5db33d82d1bd83b14d762f4ae2d726007637acf9a24e', 30);
INSERT INTO ACCOUNT VALUES ('052870039441', 359668, 'd5e67417992ca06ee36f25454eee45be4cea748fd1b06bba3e9b3640e236a0a8', 135);
INSERT INTO ACCOUNT VALUES ('101692229133', 65361, '0b57aaf55f5b459fa89f3b097fc3362c0a5022dab39d3d357e168d5b68ce9af2', 148);
INSERT INTO ACCOUNT VALUES ('003824056296', 1431833, '5a34800468a85eb14b8a36495d051d2ff24993fee847bf82a27deb9d6b9d7618', 130);
INSERT INTO ACCOUNT VALUES ('011978237264', 330105, 'd0b6328da893b424d9d48887d910e4c45709df69c4ca44b6f4c321f4c0f94438', 159);
INSERT INTO ACCOUNT VALUES ('011274716253', 41133, 'f813d09e63721c54b49e90aa782af736d82f5271b060a973d67741a2643f1f3d', 184);
INSERT INTO ACCOUNT VALUES ('003469792567', 736239, 'c52ceed8b034775e561cf44e789991fc5b987000fd8cf19fd40f5d23c1ee663e', 140);
INSERT INTO ACCOUNT VALUES ('057996172395', 75864, 'ffa4cdbf05cc6ec516ec6fe3c6108cae0d61a8aa08820ac907cd6a140718bfcf', 108);
INSERT INTO ACCOUNT VALUES ('011572977922', 1725389, '6d4b6e4507d585422a84a6851f32b7d76b42ff38d5f0d8ab6d01a05eeeab6153', 172);
INSERT INTO ACCOUNT VALUES ('101830225893', 727358, '66bc63cdf2b43d7ba020ac7cb0ade1200099693dfe0005f6a5da29c2bfd46544', 156);
INSERT INTO ACCOUNT VALUES ('052968575081', 885250, '20cfd63fb0de0cf3d78f8321b9f728880becef176c6e139cb8fc5bea564fff1c', 139);
INSERT INTO ACCOUNT VALUES ('057247007446', 759145, '2523beb0dc02fac4ed72cc6b60cd601c9be9543ce5278b0f6ba74b405bf1a685', 117);
INSERT INTO ACCOUNT VALUES ('057228918726', 277307, '0208120df3053e3e70d4c40bb7b6bcfc25445bf2e438d4589ba49d8c9ced27da', 95);
INSERT INTO ACCOUNT VALUES ('011085025129', 1038857, '71e1a2a9733b394649a62f8bf34a3c8e8561715274afe693d7105c357dd0b43a', 28);
INSERT INTO ACCOUNT VALUES ('101947644632', 380113, 'fe2ea4c8499f9a462e37c5f47d9152e4a191137f7ad68fba068422bd292507f8', 29);
INSERT INTO ACCOUNT VALUES ('011291618359', 923331, 'e3f5d61e5e95e14d2a9881f57eb573f23910d2e4f5dcc333fa9885513ec20bd9', 90);
INSERT INTO ACCOUNT VALUES ('052448863623', 216638, '4031a8f9b12c1e595f4d322ef147c261c0641fcc9920d1d67eaca05a9a667fe8', 179);
INSERT INTO ACCOUNT VALUES ('057565299107', 919724, '8fdf27e3af829459c2d18e0dc359b30803d7d667aac1736bae3fa4433482f2d7', 81);
INSERT INTO ACCOUNT VALUES ('057381748325', 524898, '752e2c86555b5db6e2be4b604cd126df98588c51e594f65dbb446c3a57de7983', 54);
INSERT INTO ACCOUNT VALUES ('101268520826', 1729841, 'a5781daf8236487571e32597449625b3e7b001b3157b4b6ec3bf602798feeaac', 59);
INSERT INTO ACCOUNT VALUES ('052983935331', 2033732, '5f36cf0f4d82d06535bb3a3ca09c1eeb6e69f101e7bc128842e8039c81c69cbe', 163);
INSERT INTO ACCOUNT VALUES ('101207007113', 20077, 'f5fe3cf54d95921fb8c9b04ebc38ffa6a798a83aa871589843b93ad5f65122a7', 169);
INSERT INTO ACCOUNT VALUES ('003219903700', 730863, '331dd922119ac2f71857094d5fe2af1c1c39ab81c2f88205ca710094510fa017', 166);
INSERT INTO ACCOUNT VALUES ('011768088308', 1105104, '5cbb1af46cae076e511dbaabf54f046b5ea276ea288a908d4c4674c5841019c2', 64);
INSERT INTO ACCOUNT VALUES ('003737643536', 1368867, '7ab698c727159cc3213f715c728a9581bfdb596d8a681f0297dfb1abd61c668d', 167);
INSERT INTO ACCOUNT VALUES ('057087559720', 216227, '041681a7361ae01d71e972bf3c6e22ca0175f91ce4a123c9aaf24e10ab14139f', 167);
INSERT INTO ACCOUNT VALUES ('052475175637', 743774, '953f8b44266dc4d1d59e89c019290335802f234fa0d47837b721bf69c0a51b9a', 100);
INSERT INTO ACCOUNT VALUES ('101683364529', 718408, '3c6f0c8b129a827514bc6852d6e7ce64f07f7e2b7f06b58425b7a4db3270dda7', 100);
INSERT INTO ACCOUNT VALUES ('003444369699', 1208382, 'f642ff99d8127c9ca81027fb1e7b2d1ef78d592a6b6b3b9b8661b61ccd9e1a5c', 149);
INSERT INTO ACCOUNT VALUES ('011171330777', 235163, '9d19151c88a0a3b43bdb683f4c13e577af2fcda3740ae2734f21b1cfe3d068b9', 149);
INSERT INTO ACCOUNT VALUES ('052545467320', 3036, '5922105c4627cd3724ea3015b03c8b3925c7f61f90e05a04cf67492975933b78', 112);
INSERT INTO ACCOUNT VALUES ('101883321929', 292155, 'ea86ca595821e73ec85af8131d635af9c12e38126edc7ac6d31707f79d06aa06', 112);
INSERT INTO ACCOUNT VALUES ('052373235666', 338482, '477b87da150e1573434e7c1ab0d50e750de6430aa3ef32e2681c97a4326f0f92', 162);
INSERT INTO ACCOUNT VALUES ('003102297340', 629416, '336dd158ce5b12e5a2ea4237191cec1e3bf818064287074611bd7fa0911ec222', 162);
INSERT INTO ACCOUNT VALUES ('101925746361', 152478, '2c4140e7430fe0dc0ecccbe4bf379a3aafbcb6e80f99419aea24949b3e0bfd7a', 153);
INSERT INTO ACCOUNT VALUES ('101722774049', 546646, '9df80a5c36c4497399f227dc15f23f3e80a86db8e46d8909e9ae58f5f6f8dcb2', 153);
INSERT INTO ACCOUNT VALUES ('003806873554', 565409, 'ce978a8113eef12eb98cb577d2fe01a6b1afa46b5f45b43cb7777c8fd233b8eb', 113);
INSERT INTO ACCOUNT VALUES ('003574847941', 1481674, 'c1cb014c6b9c2739d0ebb18fceda2c202960362eb6bb0f68dbe02e7b1437c90d', 113);
INSERT INTO ACCOUNT VALUES ('057165973772', 52605, '98b1b851f9bd13142e0df982a554ef34baf07dd11e525009f3c85b21affe0589', 155);
INSERT INTO ACCOUNT VALUES ('011305218638', 978461, '93234dea32297fcbfc2e266f9334bb3eab385d28801c28392d954dc07be4a262', 155);
INSERT INTO ACCOUNT VALUES ('052477266681', 952098, '603c434caf32a44310cf29d4d9c195564f29d6ed8db94237274b928f4db86a16', 16);
INSERT INTO ACCOUNT VALUES ('003062135894', 472399, '0dedd8d892938c45f22434f77c3bd3cdd9aa354b354893288e140f2a94eabea1', 16);
INSERT INTO ACCOUNT VALUES ('052087618783', 2038253, '29d987365bef834718e294e74327dbf03bef16d9f52acedfd0701ade53716205', 178);
INSERT INTO ACCOUNT VALUES ('101854214363', 1357797, '2d42262ce70e44579d87146c9a18b2912f01b3a80a7d8bce295ffb643aa74520', 178);
INSERT INTO ACCOUNT VALUES ('003531288396', 1530140, 'c12b401cbfff11f059dc54bfecac2934b1ca0a8fe0c62cc5687617f0bed076c2', 160);
INSERT INTO ACCOUNT VALUES ('101549923332', 90490, 'c1f61704519d9d61c0652ab9590ff0ccd5487dd11ee0d8220d412cfe890b1d9a', 160);
INSERT INTO ACCOUNT VALUES ('011367524047', 2155963, 'ab60bc2d301959e61561e61cda917cd517566b39121465999c904e12ce4f0a8e', 160);
INSERT INTO ACCOUNT VALUES ('011418853772', 1657759, 'ea4a36d402cd104e6beb7ae882ad553725708662296aba32a1da006b6645cf39', 160);
INSERT INTO ACCOUNT VALUES ('011564085158', 1471251, 'fe771e0a88748686e29d5fad3d1c02e8d0bd1136907559005c6b0452188d2a09', 160);
INSERT INTO ACCOUNT VALUES ('052028810013', 897702, '755f8276b7197509ffdb412bff9498d9c4ec49a3e31034d82293f5507f8c36c0', 17);
INSERT INTO ACCOUNT VALUES ('101177421381', 1003378, 'e579acd79086ba5140500c56a9156d226ef3435c5d552f13dbeaefd4d913e94c', 17);
INSERT INTO ACCOUNT VALUES ('003721229848', 369483, 'c0d2e4271fec0639609eb2b72f9852c7a2fa3a79c67342257d7690b32282df0a', 17);
INSERT INTO ACCOUNT VALUES ('052603110928', 1095873, '79ed9610e82259ab490b588175eeefe4b8964a01bd64bd993267babdaa0f1671', 17);
INSERT INTO ACCOUNT VALUES ('052657997028', 88109, '61fa2bf5124bf870ac32e8f5d96cf3e9906bfb10d6281ac7d7913d40c80c3ba6', 17);
INSERT INTO ACCOUNT VALUES ('052260829613', 127397, '69cf7edfc3d5d6d70e3463a21c301ee61a811eac01bcc93b90d82d4d2eefc0df', 60);
INSERT INTO ACCOUNT VALUES ('057575604483', 1020719, 'a255da8f0fe04c1a484f244d70cacafbda24226fe083206dd2904465100f2a73', 60);
INSERT INTO ACCOUNT VALUES ('052634318191', 412379, '4ee8ce67ebceb8d7d3d535e101548cbd41601277037278bbfb4512cfc08ae203', 60);
INSERT INTO ACCOUNT VALUES ('057598664917', 1041043, 'e76b54f595e368e3cd30c6e63c54139dd16b945bf736a14161e0af03bc01b613', 60);
INSERT INTO ACCOUNT VALUES ('011435315150', 84338, '0fd47bea7f01b655d397bf2ff8877bc0ce354b49962434d3477ed8129a910b40', 60);
INSERT INTO ACCOUNT VALUES ('101600950017', 1708421, '4abb9316a3d34cf61475f48231efa65ce011645b2a358b87f0257b74716735b2', 60);
INSERT INTO ACCOUNT VALUES ('101557951401', 583314, 'feb7941b3aaa7e85d0432a27f2add819f4f2a7343feb83e8cbfbd50986e0edd9', 60);
INSERT INTO ACCOUNT VALUES ('011384106173', 808184, '6dc7236591211cdea8e426d3b64479e4deadd071c7a51bc9a8d08e8fe5cb0d0e', 60);
INSERT INTO ACCOUNT VALUES ('101553466694', 241534, '15f5e9f69620b5dd7eceddbe384cc7a47e29873eeef7139ee1b96c49a14a6c38', 60);
INSERT INTO ACCOUNT VALUES ('101562241915', 459496, '4ba54562118820dbed12c5f24e6d0070502add675163a55cbf32808c6b070361', 43);
INSERT INTO ACCOUNT VALUES ('011193424949', 250253, 'b4d0ac017422d618b46ba5a39656a6d6edf6c5f01a10a5d2f0f3dfbd45df062d', 43);
INSERT INTO ACCOUNT VALUES ('003795350230', 859597, 'b42a28a83965cad906bc5ebf9bb04391f39739823cf2cfb715a483002413a251', 43);
INSERT INTO ACCOUNT VALUES ('057541974437', 226286, 'e6d925e821af2f8631029f4c4b47e42e95f94d4bc5b9b7859e45715963968d79', 43);
INSERT INTO ACCOUNT VALUES ('101980161270', 691019, 'ba9d119115aebdeb5f0bf51f7a2672c788444e22f5c85b61d12497e0bd45411f', 43);
INSERT INTO ACCOUNT VALUES ('057011153167', 622988, '8ec122e9d6fa745df4241506e1aad3525f12f2b4cb718645c6a07fda88dad2cd', 43);
INSERT INTO ACCOUNT VALUES ('011975860295', 1323057, 'cd15c2b0fd91216ac8c580fff82ceaf2e80b932e0e07177a3cf36c5335e0ae6a', 43);
INSERT INTO ACCOUNT VALUES ('057881364125', 119029, 'b26685dbe48f35466e7596d7fd9b5efe8a211b5d4cf1af609679bd8caaa36581', 43);
INSERT INTO ACCOUNT VALUES ('052146093168', 248835, '98f90b05b0cc4a137af94ad9050e6857f308d90625dce223eb447c9f040f7176', 43);
INSERT INTO ACCOUNT VALUES ('101714083574', 671850, 'b90fe1162288081bbe5459931d421742628876d0c3856501ebdb0f64b9040559', 43);
INSERT INTO ACCOUNT VALUES ('052632662332', 1660004, '7fef3f90a0f2fcb4084c6e422c138a8f06d8533ffcedc7b3e2601adcaddb5d7b', 60);
INSERT INTO ACCOUNT VALUES ('052500407524', 2222437, '7022fb7306ccc3f8d10b32064e619d21b14c18c39c03c17cc3dba3b37e71443e', 60);
INSERT INTO ACCOUNT VALUES ('101890381033', 444523, '5de2253b3bb6c6de31c1f4244bb66e36b12a02e6d191be181632e11a3dfb41d5', 60);
INSERT INTO ACCOUNT VALUES ('057140428225', 1009161, 'a14d1f7d51adb30246b523854c22d84c8af76d68257cc7969630e1afb68c5906', 60);
INSERT INTO ACCOUNT VALUES ('101284618467', 708278, '88710adb53955775612734edfb1648eb827a3a05e7e080505577192a206004e0', 60);
INSERT INTO ACCOUNT VALUES ('003569043145', 1558640, '75ee9d7493b341f5a0602c71ceb2ac2d001a48b6aef0a06974118915267a06f3', 60);
INSERT INTO ACCOUNT VALUES ('003357211782', 1312082, '30ce895530ba1cc0ef58f3c8b95fe323812ba8eda10caab2450e2f9018ab0101', 60);
INSERT INTO ACCOUNT VALUES ('003727453674', 513764, '808dea97392f4bb5be880422eaf42806068052662f3c4dd2761fa757cb7175fb', 60);
INSERT INTO ACCOUNT VALUES ('011741867747', 594283, 'b7de679e6e7cf2c83fc7637cae90e0ffc9803e217b9be6353e7f65cebffbb752', 60);
INSERT INTO ACCOUNT VALUES ('101444513481', 461576, 'f6a7c0ea00cac7d7877851acd11f53e1f6c006f5834132ae3d1c715d882b701b', 60);
Commit;
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Afghanistan','AFG',45,10);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Albania','ALB',59,6);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Algeria','ALG',41,6);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Andorra','AND',68,20);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Angola','ANG',36,15);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Argentina','ARG',45,22);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Armenia','ARM',59,3);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Australia','AUS',86,14);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Austria','AUT',86,9);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Azerbaijan','AZE',68,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Bahamas','BAH',59,8);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Bahrain','BHR',54,12);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Bangladesh','BGD',54,17);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Barbados','BRB',54,2);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Belarus','BLR',86,9);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Belgium','BEL',86,2);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Belize','BLZ',45,25);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Benin','BEN',59,2);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Bhutan','BTN',54,25);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Bolivia','BOL',54,17);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Bosnia','BIH',59,1);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Botswana','BWA',86,25);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Brazil','BRA',45,19);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Brunei','BRN',86,1);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Bulgaria','BGR',81,20);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Burkina Faso','BFA',50,19);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Burundi','BDI',32,5);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Cambodia','KHM',54,5);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Cameroon','CMR',50,5);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Canada','CAN',86,18);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Central Africa','CAF',41,10);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Chad','TCD',36,19);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Chile','CHL',81,6);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('China','CHN',68,16);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Colombia','COL',59,12);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Comoros','COM',50,16);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Congo','COD',41,15);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Costa Rica','CRI',59,24);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Croatia','HRV',68,21);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Cuba','CUB',14,4);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Cyprus','CYP',68,5);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Czech Republic','CZE',90,6);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Denmark','DNK',100,22);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Djibouti','DJI',50,15);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Dominica','DMA',59,2);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Dominican Republic','DOM',59,7);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Ecuador','ECU',59,11);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Egypt','EGY',45,4);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('El Salvador','SLV',50,6);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Equatorial Guinea','GNQ',41,22);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Eritrea','ERI',23,1);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Estonia','EST',100,3);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Eswatini','SWZ',45,17);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Ethiopia','ETH',45,5);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Fiji','FJI',86,20);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Finland','FIN',86,12);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('France','FRA',63,21);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Gabon','GAB',45,19);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Gambia','GMB',41,21);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Georgia','GEO',86,2);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Germany','DEU',95,9);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Ghana','GHA',54,21);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Greece','GRC',36,18);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Grenada','GRD',54,19);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Guatemala','GTM',63,25);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Guinea','GIN',45,2);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Guinea-Bissau','GNB',41,3);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Guyana','GUY',59,21);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Haiti','HTI',23,25);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Honduras','HND',54,16);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Hungary','HUN',86,6);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Iceland','ISL',95,9);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('India','IND',54,9);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Indonesia','IDN',68,6);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Iran','IRN',45,16);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Iraq','IRQ',41,9);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Ireland','IRL',100,6);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Israel','ISR',81,22);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Italy','ITA',50,19);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Jamaica','JAM',54,22);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Japan','JPN',54,23);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Jordan','JOR',50,5);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Kazakhstan','KAZ',77,16);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Kenya','KEN',50,22);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Kiribati','KIR',63,0);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Kuwait','KWT',86,10);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Kyrgyzstan','KGZ',54,19);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Laos','LAO',50,12);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Latvia','LVA',86,9);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Lebanon','LBN',5,17);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Lesotho','LSO',41,3);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Liberia','LBR',36,6);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Libya','LBY',45,2);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Liechtenstein','LIE',100,9);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Lithuania','LTU',86,0);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Luxembourg','LUX',100,17);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Madagascar','MDG',50,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Malawi','MWI',36,16);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Malaysia','MYS',81,24);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Maldives','MDV',50,4);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Mali','MLI',45,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Malta','MLT',90,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Mauritania','MRT',41,9);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Mauritius','MUS',68,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Mexico','MEX',63,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Micronesia','FSM',59,5);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Moldova','MDA',63,23);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Mongolia','MNG',50,12);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Montenegro','MNE',54,6);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Morocco','MAR',54,24);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Mozambique','MOZ',41,20);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Myanmar','MMR',54,6);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Namibia','NAM',50,24);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Nauru','NRU',0,12);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Nepal','NPL',54,8);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Netherlands','NLD',100,14);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('New Zealand','NZL',95,11);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Nicaragua','NIC',50,3);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Niger','NER',45,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Nigeria','NGA',41,10);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('North Korea','PRK',0,23);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('North Macedonia','MKD',59,11);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Norway','NOR',100,1);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Oman','OMN',68,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Pakistan','PAK',41,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Palau','PLW',0,23);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Palestine State','PSE',68,14);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Panama','PAN',68,21);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Papua New Guinea','PNG',54,0);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Paraguay','PRY',68,2);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Peru','PER',86,22);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Philippines','PHL',63,23);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Poland','POL',81,7);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Portugal','PRT',63,14);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Qatar','QAT',86,10);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Romania','ROU',86,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Russia','RUS',5,15);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Rwanda','RWA',59,25);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Samoa','WSM',63,21);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('San Marino','SMR',86,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Saudi Arabia','SAU',81,12);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Senegal','SEN',50,2);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Serbia','SRB',63,17);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Seychelles','SYC',68,8);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Singapore','SGP',86,7);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Slovakia','SVK',77,20);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Slovenia','SVN',81,0);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Somalia','SOM',12,5);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('South Africa','ZAF',45,12);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('South Korea','KOR',86,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('South Sudan','SSD',9,11);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Spain','ESP',59,1);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Sri Lanka','LKA',54,5);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Sudan','SDN',5,6);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Suriname','SUR',16,5);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Sweden','SWE',100,4);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Switzerland','CHE',100,22);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Syria','SYR',0,23);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Tajikistan','TJK',50,11);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Tanzania','TZA',59,7);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Thailand','THA',86,4);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Togo','TGO',45,14);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Tonga','TON',86,7);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Tunisia','TUN',24,12);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Turkey','TUR',59,16);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Turkmenistan','TKM',59,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Tuvalu','TUV',0,24);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('UK','GBR',77,11);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('USA','USA',63,13);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Uganda','UGA',50,19);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Ukraine','UKR',12,5);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('United Arab Emirates','ARE',90,5);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Uruguay','URY',68,25);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Uzbekistan','UZB',59,3);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Vanuatu','VUT',59,7);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Venezuela','VEN',5,18);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Vietnam','VNM',68,23);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Yemen','YEM',9,24);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Zambia','ZMB',23,20);
Insert into COUNTRY_CREDIT (NAME,COUNTRY_CODE,CREDIT,BANK_ID) values ('Zimbabwe','ZWE',50,18);
Commit;
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (1,'Vladimir Putin','The culprits of the war between Ukraine and Russia',8);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (2,'Kim Jong-un','The ruler of North Korea',8);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (3,'Kim Yeo Jung','Kim Jong-un''s younger sister',16);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (4,'Xi Jinping','The leader of China',13);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (5,'JOANNE DEBORAH CHESIMARD','Most Wanted Terrorists',19);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (6,'IBRAHIM SALIH MOHAMMED AL-YACOUB','Most Wanted Terrorists',17);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (7,'MOHAMMED ALI HAMADEI','Most Wanted Terrorists',12);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (8,'RADDULAN SAHIRON','Most Wanted Terrorists',6);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (9,'HASAN IZZ-AL-DIN','Most Wanted Terrorists',11);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (10,'ABDELKARIM HUSSEIN MOHAMED AL-NASSER','Most Wanted Terrorists',22);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (11,'AHLAM AHMAD Al-TAMIMI','Most Wanted Terrorists',18);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (12,'ALI ATWA','Most Wanted Terrorists',10);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (13,'ABDUL RAHMAN YASIN','Most Wanted Terrorists',13);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (14,'HUSAYN MUHAMMAD AL-UMARI','Most Wanted Terrorists',15);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (15,'ALI SAED BIN ALI EL-HOORIE','Most Wanted Terrorists',0);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (16,'ABD AL AZIZ AWDA','Most Wanted Terrorists',11);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (17,'JABER A. ELBANEH','Most Wanted Terrorists',1);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (18,'DANIEL ANDREAS SAN DIEGO','Most Wanted Terrorists',5);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (19,'MUHAMMAD AHMED AL-MUNAWAR','Most Wanted Terrorists',15);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (20,'MUHAMMAD ABDULLAH KHALIL HUSSAIN AR-RAHAYYAL','Most Wanted Terrorists',3);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (21,'WADOUD MUHAMMAD HAFIZ AL-TURKI','Most Wanted Terrorists',21);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (22,'JAMAL SAEED ABDUL RAHIM','Most Wanted Terrorists',18);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (23,'Nathaniel Holmes','Suspicion of possessing a fake deposit bank account',0);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (24,'Jonas Cooper','Suspicion of possessing a fake deposit bank account',18);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (25,'Diego Wilson','Suspicion of possessing a fake deposit bank account',9);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (26,'Deacon Woods','Suspicion of possessing a fake deposit bank account',9);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (27,'Kingsley Doyle','Suspicion of possessing a fake deposit bank account',4);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (28,'Kane Matthews','Holder of Stolen Account',1);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (29,'Bertie Collins','Holder of Stolen Account',12);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (30,'Lorenzo Thompson','Holder of Stolen Account',3);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (31,'Jessica Cooper','Holder of Stolen Account',14);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (32,'Katherine Baxter','Holder of Stolen Account',25);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (33,'Amiyah Ellis','Holder of Stolen Account',19);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (34,'Andrew Reynolds','A deliquent',1);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (35,'Martha Smith','A deliquent',5);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (36,'Katherine Harper','A deliquent',1);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (37,'Melody Bennett','A deliquent',15);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (38,'Anastasia Hopkins','A deliquent',4);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (39,'Aurora Cole','A deliquent',2);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (40,'Libby Bradley','A deliquent',20);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (41,'Gene Ellis','A person of Bad Credit',20);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (42,'Lynn Spencer','A person of Bad Credit',21);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (43,'Jaime Carter','A person of Bad Credit',17);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (44,'Avery Watts','A person of Bad Credit',4);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (45,'Eli Francis','A person of Bad Credit',17);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (46,'Hayden Anderson','A person of Bad Credit',1);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (47,'Skylar Armstrong','A person of Bad Credit',3);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (48,'Reed Moore','A person of Bad Credit',16);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (49,'Carol Fisher','A person of Bad Credit',9);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (50,'Alexis Hill','A person of Bad Credit',14);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (51,'Im Yun-Hee','Suspicion of possessing a fake deposit bank account',9);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (52,'Dan Sun-Hee','Suspicion of possessing a fake deposit bank account',7);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (53,'Hong Mi-Kyong','Suspicion of possessing a fake deposit bank account',5);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (54,'Gye Kyung-Hu','Suspicion of possessing a fake deposit bank account',15);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (55,'Bae Jung-Hee','Suspicion of possessing a fake deposit bank account',11);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (56,'Jeung Mee-Yon','Suspicion of possessing a fake deposit bank account',21);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (57,'Jegal Kyungsoon','Suspicion of possessing a fake deposit bank account',25);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (58,'Ban Youngsoo','Suspicion of possessing a fake deposit bank account',24);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (59,'Byeon Kyung-Sam','Suspicion of possessing a fake deposit bank account',15);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (60,'Geum Yun-Hee','Suspicion of possessing a fake deposit bank account',12);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (61,'Bu Changmin','A person of Bad Credit',5);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (62,'Gong Ho-Sook','A person of Bad Credit',25);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (63,'Park Man-Young','A person of Bad Credit',12);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (64,'Dokgo Hei-Ryung','A person of Bad Credit',25);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (65,'Ma Young-Mi','A person of Bad Credit',12);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (66,'Guk So-Young','A person of Bad Credit',13);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (67,'Yuk Seoyeon','A person of Bad Credit',7);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (68,'Gal Jung-Hee','A person of Bad Credit',22);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (69,'Bu Mi-Sun','A person of Bad Credit',12);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (70,'Sin Young-Il','A person of Bad Credit',5);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (71,'Ryeo Jung-Hee','Holder of Stolen Account',24);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (72,'Jeung Choon-Hee','Holder of Stolen Account',1);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (73,'Yang Dong-Yul','Holder of Stolen Account',10);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (74,'Seung Yun-Hee','Holder of Stolen Account',23);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (75,'Han Hei-Ryung','Holder of Stolen Account',11);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (76,'Go Seoyeon','Holder of Stolen Account',13);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (77,'San Jung-Hee','Holder of Stolen Account',17);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (78,'Son Beom-Seok','Holder of Stolen Account',15);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (79,'Tak Chanwook','Holder of Stolen Account',21);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (80,'Yang Myung-Ok','Holder of Stolen Account',22);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (81,'Yeom Dae-Ho','Suspicion of possessing a fake deposit bank account',25);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (82,'Cho Soo-Yun','Suspicion of possessing a fake deposit bank account',4);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (83,'Hyeon Hwa-Young','Suspicion of possessing a fake deposit bank account',23);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (84,'Yeo Jin-Sang','Suspicion of possessing a fake deposit bank account',16);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (85,'Yeong Chunghee','Suspicion of possessing a fake deposit bank account',9);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (86,'Cho Taeyang','Suspicion of possessing a fake deposit bank account',6);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (87,'Geum Beom-Seok','Suspicion of possessing a fake deposit bank account',19);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (88,'An Dae-Jung','Suspicion of possessing a fake deposit bank account',5);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (89,'Ryu Haru','Suspicion of possessing a fake deposit bank account',12);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (90,'Pyo Hei-Ran','Suspicion of possessing a fake deposit bank account',16);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (91,'Yuk Hwa-Young','A person of Bad Credit',20);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (92,'Park Eun-Hee','A person of Bad Credit',25);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (93,'Gang Myung-Suck','A person of Bad Credit',1);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (94,'Ju Chanwook','A person of Bad Credit',0);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (95,'Sim Kyu-Bong','A person of Bad Credit',19);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (96,'Heo Duck-Young','A person of Bad Credit',19);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (97,'Heo Mun-Hee','A person of Bad Credit',22);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (98,'Seol Dae-Jung','A person of Bad Credit',24);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (99,'Baek Sang-Ook','A person of Bad Credit',25);
Insert into DNG_PERS (DNG_ID,NAME,REASON,BANK_ID) values (100,'Jegal Hyun-Shik','A person of Bad Credit',22);
Commit;
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003114088385','Account number that appears to have been stolen',11);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003196301503','Account number that appears to have been stolen',0);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003100937419','Account number that appears to have been stolen',25);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003876022037','Account number that appears to have been stolen',5);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003403634154','Account number that appears to have been stolen',4);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003100386259','Account number that appears to have been stolen',4);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003105009173','Account number that appears to have been stolen',6);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003157964722','Account number that appears to have been stolen',7);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003435885763','Account number that appears to have been stolen',15);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003587135587','Account number that appears to have been stolen',7);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003582499304','Account number prohibited from being used after interest delinquency',10);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003811137980','Account number prohibited from being used after interest delinquency',22);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003812477803','Account number prohibited from being used after interest delinquency',11);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003264071457','Account number prohibited from being used after interest delinquency',12);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003386566230','Account number prohibited from being used after interest delinquency',21);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003263698599','Account number involved in financial crimes',23);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003756466892','Account number involved in financial crimes',5);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003850471298','Account number involved in financial crimes',22);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003262888593','Account number involved in financial crimes',10);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('003328353514','Account number involved in financial crimes',23);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011167757758','Account number prohibited from being used after interest delinquency',18);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011655005108','Account number prohibited from being used after interest delinquency',22);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011490791168','Account number prohibited from being used after interest delinquency',12);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011589935432','Account number prohibited from being used after interest delinquency',18);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011548394507','Account number prohibited from being used after interest delinquency',7);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011633417719','Account number that appears to have been stolen',1);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011373201109','Account number that appears to have been stolen',25);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011593202359','Account number that appears to have been stolen',22);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011536856088','Account number that appears to have been stolen',22);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011975021199','Account number that appears to have been stolen',21);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011287708756','Account number involved in financial crimes',11);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011352661122','Account number involved in financial crimes',6);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011904399184','Account number involved in financial crimes',0);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011287828966','Account number involved in financial crimes',2);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011622156148','Account number involved in financial crimes',3);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011803023048','Account number involved in financial crimes',10);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011342869675','Account number involved in financial crimes',5);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011224733126','Account number involved in financial crimes',14);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011127911827','Account number involved in financial crimes',10);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('011797839558','Account number involved in financial crimes',4);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052658163201','Account number prohibited from being used after interest delinquency',24);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052834635979','Account number prohibited from being used after interest delinquency',17);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052280916842','Account number prohibited from being used after interest delinquency',24);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052854440213','Account number prohibited from being used after interest delinquency',18);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052969246076','Account number prohibited from being used after interest delinquency',2);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052535713861','Account number that appears to have been stolen',13);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052329776238','Account number that appears to have been stolen',18);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052463471037','Account number that appears to have been stolen',13);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052102980295','Account number that appears to have been stolen',14);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052976607107','Account number that appears to have been stolen',13);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052577503977','Account number involved in financial crimes',1);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052624080329','Account number involved in financial crimes',15);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052236133977','Account number involved in financial crimes',4);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052855768375','Account number involved in financial crimes',0);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052669462272','Account number involved in financial crimes',4);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052389287602','Account number involved in financial crimes',0);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052898257056','Account number involved in financial crimes',20);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052791515211','Account number involved in financial crimes',4);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052825090519','Account number involved in financial crimes',21);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('052786287876','Account number involved in financial crimes',2);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057479467619','Account number prohibited from being used after interest delinquency',6);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057115300451','Account number prohibited from being used after interest delinquency',20);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057338467033','Account number prohibited from being used after interest delinquency',22);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057629388453','Account number prohibited from being used after interest delinquency',1);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057326148688','Account number prohibited from being used after interest delinquency',6);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057753601590','Account number that appears to have been stolen',18);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057452106892','Account number that appears to have been stolen',11);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057842121676','Account number that appears to have been stolen',10);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057528885367','Account number that appears to have been stolen',23);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057361061788','Account number that appears to have been stolen',18);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057793755688','Account number involved in financial crimes',4);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057688836028','Account number involved in financial crimes',17);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057146136520','Account number involved in financial crimes',16);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057948862441','Account number involved in financial crimes',15);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057951006109','Account number involved in financial crimes',7);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057436891383','Account number involved in financial crimes',9);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057493255082','Account number involved in financial crimes',17);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057927753840','Account number involved in financial crimes',17);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057374862333','Account number involved in financial crimes',17);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('057313643852','Account number involved in financial crimes',3);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101994780413','Account number that appears to be owned by the terrorist',18);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101463239181','Account number that appears to be owned by the terrorist',12);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101520516239','Account number that appears to be owned by the terrorist',20);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101573523126','Account number that appears to be owned by the terrorist',20);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101168272401','Account number that appears to be owned by the terrorist',6);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101240878123','Account number that appears to be owned by the terrorist',22);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101277464163','Account number that appears to be owned by the terrorist',18);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101449929917','Account number that appears to be owned by the terrorist',20);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101546124289','Account number that appears to be owned by the terrorist',8);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101393075118','Account number that appears to be owned by the terrorist',0);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101987546031','Account number that appears to have been stolen',2);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101860866682','Account number that appears to have been stolen',14);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101732361779','Account number that appears to have been stolen',4);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101622029096','Account number that appears to have been stolen',12);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101515161602','Account number that appears to have been stolen',21);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101613953165','Account number that appears to have been stolen',21);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101407042223','Account number that appears to have been stolen',22);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101327300111','Account number that appears to have been stolen',17);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101769567239','Account number that appears to have been stolen',24);
Insert into DNG_ACCT (ACCT_NO,REASON,BANK_ID) values ('101361349766','Account number that appears to have been stolen',18);
Commit;
/*TRANSACTION TABLE*/
INSERT INTO TRANSACTION VALUES (1 , TO_DATE('2019-03-05', 'yyyy-mm-dd') , 'mobile' , 0, 1049618, 'Manute Bol' , 'ANT' , '052969246076' , '011954352501');
INSERT INTO TRANSACTION VALUES (2 , TO_DATE('2019-03-15', 'yyyy-mm-dd') , 'teller' , 0, 23335, 'Adisa Piene' , 'AIA' , '052854440213' , '052803119033');
INSERT INTO TRANSACTION VALUES (3 , TO_DATE('2019-04-05', 'yyyy-mm-dd') , 'online' , 0, 77703, 'Godwell Nhamo' , 'AND' , '052834635979' , '057518800352');
INSERT INTO TRANSACTION VALUES (4 , TO_DATE('2019-05-30', 'yyyy-mm-dd') , 'mobile' , 1, 8840, 'Lionel Andres Messi' , 'ARG' , '052658163201' , '101407441009');
INSERT INTO TRANSACTION VALUES (5 , TO_DATE('2019-07-17', 'yyyy-mm-dd') , 'mobile' , 1, 88475, 'Kehinde Wiley' , 'ARM' , '052535713861' , '011149240176');
INSERT INTO TRANSACTION VALUES (6 , TO_DATE('2021-02-21', 'yyyy-mm-dd') , 'mobile' , 1, 1574, 'Neymar da Silva Santos Junior' , 'BRA' , '052463471037' , '003137006202');
INSERT INTO TRANSACTION VALUES (7 , TO_DATE('2021-03-03', 'yyyy-mm-dd') , 'teller' , 1, 26946, 'Alice Braga' , 'BRA' , '052329776238' , '057084098979');
INSERT INTO TRANSACTION VALUES (8 , TO_DATE('2021-03-04', 'yyyy-mm-dd') , 'teller' , 0, 50831, 'Andy Lau' , 'HKG' , '052280916842' , '057442301506');
INSERT INTO TRANSACTION VALUES (9 , TO_DATE('2021-03-05', 'yyyy-mm-dd') , 'teller' , 1, 44735, 'Teresa Teng' , 'HKG' , '052102980295' , '057261773990');
INSERT INTO TRANSACTION VALUES (10 , TO_DATE('2021-03-10', 'yyyy-mm-dd') , 'online' , 0, 35307, 'Jornadan Noonez' , 'HND' , '011975021199' , '101142061799');
INSERT INTO TRANSACTION VALUES (11 , TO_DATE('2021-03-27', 'yyyy-mm-dd') , 'online' , 1, 6391, 'Carlos Humberto Ruiz Gutierrez' , 'GTM' , '011904399184' , '057319873710');
INSERT INTO TRANSACTION VALUES (12 , TO_DATE('2021-04-07', 'yyyy-mm-dd') , 'mobile' , 1, 98485, 'Konstantinos Manolas' , 'GRC' , '011803023048' , '101117740739');
INSERT INTO TRANSACTION VALUES (13 , TO_DATE('2021-04-17', 'yyyy-mm-dd') , 'teller' , 1, 70467, 'Jimmy Cliff' , 'JAM' , '011797839558' , '057235750774');
INSERT INTO TRANSACTION VALUES (14 , TO_DATE('2021-04-19', 'yyyy-mm-dd') , 'teller' , 1, 35818, 'Hamad bin Khalifa Al Thani' , 'KWT' , '011655005108' , '003858892273');
INSERT INTO TRANSACTION VALUES (15 , TO_DATE('2021-04-20', 'yyyy-mm-dd') , 'online' , 1, 16686, 'Xi Jinping' , 'CHN' , '011633417719' , '101021791107');
INSERT INTO TRANSACTION VALUES (16 , TO_DATE('2021-04-23', 'yyyy-mm-dd') , 'mobile' , 0, 22420, 'Vladimir Putin' , 'RUS' , '011622156148' , '101693522641');
INSERT INTO TRANSACTION VALUES (17 , TO_DATE('2021-04-27', 'yyyy-mm-dd') , 'online' , 0, 57019, 'Ali Al Musrati' , 'LBY' , '011593202359' , '003569596128');
INSERT INTO TRANSACTION VALUES (18 , TO_DATE('2021-04-28', 'yyyy-mm-dd') , 'teller' , 0, 81921, 'Adowa Wiley' , 'KEN' , '011589935432' , '052997048486');
INSERT INTO TRANSACTION VALUES (19 , TO_DATE('2021-05-03', 'yyyy-mm-dd') , 'mobile' , 0, 12247, 'Jong-un Kim' , 'PRK' , '011548394507' , '011225810264');
INSERT INTO TRANSACTION VALUES (20 , TO_DATE('2021-05-06', 'yyyy-mm-dd') , 'teller' , 1, 27438, 'Shakya Sujan Ratna' , 'NPL' , '011536856088' , '101595234458');
INSERT INTO TRANSACTION VALUES (21 , TO_DATE('2021-05-06', 'yyyy-mm-dd') , 'online' , 1, 25239, 'Daniela Melchior' , 'PRT' , '011490791168' , '101335585762');
INSERT INTO TRANSACTION VALUES (22 , TO_DATE('2021-05-19', 'yyyy-mm-dd') , 'mobile' , 1, 24134, 'Maxence Danet-Fauvel' , 'FRA' , '011373201109' , '003943484500');
INSERT INTO TRANSACTION VALUES (23 , TO_DATE('2021-05-22', 'yyyy-mm-dd') , 'mobile' , 0, 52803, 'Vicent Cassel' , 'FRA' , '011352661122' , '003278624111');
INSERT INTO TRANSACTION VALUES (24 , TO_DATE('2021-05-25', 'yyyy-mm-dd') , 'online' , 1, 99060, 'Volodymyr Zelensky' , 'UKR' , '011342869675' , '057886228306');
INSERT INTO TRANSACTION VALUES (25 , TO_DATE('2021-06-09', 'yyyy-mm-dd') , 'online' , 1, 77193, 'Milla Kunis' , 'UKR' , '011287828966' , '101424863051');
INSERT INTO TRANSACTION VALUES (26 , TO_DATE('2021-06-09', 'yyyy-mm-dd') , 'teller' , 1, 41649, 'Adjoa Andoh' , 'SSD' , '011287708756' , '057225463149');
INSERT INTO TRANSACTION VALUES (27 , TO_DATE('2021-06-12', 'yyyy-mm-dd') , 'teller' , 1, 35557, 'Yun-Hee Im' , 'KOR' , '011224733126' , '057477132870');
INSERT INTO TRANSACTION VALUES (28 , TO_DATE('2021-06-14', 'yyyy-mm-dd') , 'teller' , 1, 86499, 'Ho-Sook Gong' , 'KOR' , '011167757758' , '057295435415');
INSERT INTO TRANSACTION VALUES (29 , TO_DATE('2021-06-26', 'yyyy-mm-dd') , 'teller' , 0, 20069, 'Miriam Stein' , 'CHE' , '011127911827' , '052582428379');
INSERT INTO TRANSACTION VALUES (30 , TO_DATE('2021-07-04', 'yyyy-mm-dd') , 'teller' , 0, 66018, 'Emily Amber' , 'FIN' , '003876022037' , '011909198382');
INSERT INTO TRANSACTION VALUES (31 , TO_DATE('2021-07-17', 'yyyy-mm-dd') , 'teller' , 0, 37200, 'Alain Delon' , 'FRA' , '003850471298' , '011580381107');
INSERT INTO TRANSACTION VALUES (32 , TO_DATE('2021-07-18', 'yyyy-mm-dd') , 'online' , 1, 2072, 'Keanu Reeves' , 'CAN' , '003812477803' , '052730201364');
INSERT INTO TRANSACTION VALUES (33 , TO_DATE('2022-03-20', 'yyyy-mm-dd') , 'online' , 0, 23728, 'Yeo Jung Kim' , 'PRK' , '003811137980' , '057910663379');
INSERT INTO TRANSACTION VALUES (34 , TO_DATE('2022-03-21', 'yyyy-mm-dd') , 'online' , 1, 51275, 'Rachel Anne McAdams' , 'CAN' , '003756466892' , '052531069330');
INSERT INTO TRANSACTION VALUES (35 , TO_DATE('2022-03-21', 'yyyy-mm-dd') , 'online' , 0, 51210, 'Elaine Thompson' , 'JAM' , '003587135587' , '003851388311');
INSERT INTO TRANSACTION VALUES (36 , TO_DATE('2022-03-30', 'yyyy-mm-dd') , 'mobile' , 0, 91056, 'Jae-in Moon' , 'KOR' , '003582499304' , '011933182651');
INSERT INTO TRANSACTION VALUES (37 , TO_DATE('2022-03-30', 'yyyy-mm-dd') , 'mobile' , 1, 85958, 'Su jin Jeong' , 'KOR' , '003435885763' , '003984724883');
INSERT INTO TRANSACTION VALUES (38 , TO_DATE('2022-04-06', 'yyyy-mm-dd') , 'mobile' , 1, 37227, 'Jonas Cooper' , 'USA' , '003403634154' , '011311287885');
INSERT INTO TRANSACTION VALUES (39 , TO_DATE('2022-05-06', 'yyyy-mm-dd') , 'mobile' , 1, 10728, 'Wang Jin Kai' , 'MAC' , '003386566230' , '057832164618');
INSERT INTO TRANSACTION VALUES (40 , TO_DATE('2022-05-09', 'yyyy-mm-dd') , 'mobile' , 1, 1092045, 'Wui Fan' , 'MAC' , '003328353514' , '057357816051');
INSERT INTO TRANSACTION VALUES (41 , TO_DATE('2022-05-12', 'yyyy-mm-dd') , 'mobile' , 1, 31750, 'Yejin Jeong' , 'KOR' , '003264071457' , '057480841627');
INSERT INTO TRANSACTION VALUES (42 , TO_DATE('2022-05-17', 'yyyy-mm-dd') , 'mobile' , 1, 54598, 'Miles Teller' , 'USA' , '003263698599' , '011555061659');
INSERT INTO TRANSACTION VALUES (43 , TO_DATE('2022-05-26', 'yyyy-mm-dd') , 'online' , 1, 23933, 'Tom Cruise' , 'USA' , '003262888593' , '052599785220');
INSERT INTO TRANSACTION VALUES (44 , TO_DATE('2022-06-06', 'yyyy-mm-dd') , 'online' , 0, 81799, 'Joy Rolens' , 'USA' , '003196301503' , '011443261999');
INSERT INTO TRANSACTION VALUES (45 , TO_DATE('2022-06-08', 'yyyy-mm-dd') , 'teller' , 0, 91039, 'Hailemariam Desalegn' , 'YEM' , '003157964722' , '003867477392');
INSERT INTO TRANSACTION VALUES (46 , TO_DATE('2022-06-20', 'yyyy-mm-dd') , 'teller' , 0, 64314, 'Charles Mark Olweny' , 'SOM' , '003114088385' , '011949065994');
INSERT INTO TRANSACTION VALUES (47 , TO_DATE('2022-07-03', 'yyyy-mm-dd') , 'teller' , 0, 52319, 'Justin Mark Marozzi' , 'SOM' , '003105009173' , '057650774252');
INSERT INTO TRANSACTION VALUES (48 , TO_DATE('2022-07-05', 'yyyy-mm-dd') , 'teller' , 1, 12458, 'Halimah Yacob' , 'SGP' , '003100937419' , '052294474267');
INSERT INTO TRANSACTION VALUES (49 , TO_DATE('2022-07-05', 'yyyy-mm-dd') , 'online' , 1, 17406, 'Dasha Taran' , 'RUS' , '003100386259' , '003953613760');
INSERT INTO TRANSACTION VALUES (50 , TO_DATE('2022-07-19', 'yyyy-mm-dd') , 'mobile' , 1, 88277, 'Kristina Andrejevna Ovcinnikova' , 'RUS' , '003447729173' , '101219379546');
INSERT INTO TRANSACTION VALUES (51 , TO_DATE('2022-07-20', 'yyyy-mm-dd') , 'mobile' , 0, 42008, 'Abd Al Aziz Awda' , 'PSE' , '011410043641' , '052971554289');
INSERT INTO TRANSACTION VALUES (52 , TO_DATE('2022-08-18', 'yyyy-mm-dd') , 'mobile' , 0, 18036, 'Carlol Fisher' , 'FRA' , '011404687643' , '057983606917');
INSERT INTO TRANSACTION VALUES (53 , TO_DATE('2022-09-18', 'yyyy-mm-dd') , 'teller' , 0, 96990, 'Alexis Hill' , 'FIN' , '011930536820' , '057565924564');
INSERT INTO TRANSACTION VALUES (54 , TO_DATE('2022-09-19', 'yyyy-mm-dd') , 'teller' , 1, 39387, 'Jessica Cooper' , 'USA' , '011597146519' , '011993250517');
INSERT INTO TRANSACTION VALUES (55 , TO_DATE('2022-09-20', 'yyyy-mm-dd') , 'teller' , 1, 81766, 'Lorenzo Thompson' , 'FRA' , '011794824060' , '003446112496');
INSERT INTO TRANSACTION VALUES (56 , TO_DATE('2022-09-21', 'yyyy-mm-dd') , 'online' , 1, 43796, 'Kane Matthews' , 'USA' , '011569762260' , '052724495892');
INSERT INTO TRANSACTION VALUES (57 , TO_DATE('2022-09-22', 'yyyy-mm-dd') , 'online' , 0, 37918, 'Kingsley Doyle' , 'UKR' , '011409631641' , '101699375837');
INSERT INTO TRANSACTION VALUES (58 , TO_DATE('2022-09-23', 'yyyy-mm-dd') , 'online' , 1, 28955, 'Deacon Woods' , 'UKR' , '011340305795' , '052571837993');
INSERT INTO TRANSACTION VALUES (59 , TO_DATE('2022-09-24', 'yyyy-mm-dd') , 'mobile' , 1, 81219, 'Diego Wilson' , 'BRA' , '011113925595' , '057132673282');
INSERT INTO TRANSACTION VALUES (60 , TO_DATE('2022-09-25', 'yyyy-mm-dd') , 'mobile' , 1, 71098, 'Jamel Saeed Abdul Rahim' , 'PSE' , '052696493423' , '052775358563');
INSERT INTO TRANSACTION VALUES (61 , TO_DATE('2022-09-26', 'yyyy-mm-dd') , 'teller' , 0, 77246, 'Bertie Collins' , 'GBR' , '052287514877' , '011522995891');
INSERT INTO TRANSACTION VALUES (62 , TO_DATE('2022-10-17', 'yyyy-mm-dd') , 'teller' , 0, 23205, 'Mohammed Ali Hamadei' , 'PSE' , '052201297036' , '052771093716');
INSERT INTO TRANSACTION VALUES (63 , TO_DATE('2022-10-18', 'yyyy-mm-dd') , 'online' , 1, 61665, 'Joanne Deborah Chesimard' , 'PSE' , '052340031128' , '101245269417');
INSERT INTO TRANSACTION VALUES (64 , TO_DATE('2022-10-19', 'yyyy-mm-dd') , 'online' , 1, 9119, 'Nathaniel Holmes' , 'GBR' , '052311355937' , '052256693637');
INSERT INTO TRANSACTION VALUES (65 , TO_DATE('2022-10-20', 'yyyy-mm-dd') , 'mobile' , 0, 35729, 'Aurora Cole' , 'USA' , '052501617481' , '052905438795');
INSERT INTO TRANSACTION VALUES (66 , TO_DATE('2022-10-21', 'yyyy-mm-dd') , 'teller' , 1, 39171, 'Gene Ellis' , 'GBR' , '052767467268' , '052259444746');
INSERT INTO TRANSACTION VALUES (67 , TO_DATE('2022-10-22', 'yyyy-mm-dd') , 'online' , 0, 34021, 'Dae-Jung Seol' , 'KOR' , '052762797936' , '101752945820');
INSERT INTO TRANSACTION VALUES (68 , TO_DATE('2022-10-23', 'yyyy-mm-dd') , 'online' , 0, 91812, 'Hyun-Shik Jegal' , 'KOR' , '052640763573' , '101263416078');
INSERT INTO TRANSACTION VALUES (69 , TO_DATE('2022-10-24', 'yyyy-mm-dd') , 'teller' , 0, 27004, 'Kyu-Bong Sim' , 'KOR' , '052537351603' , '003164934976');
INSERT INTO TRANSACTION VALUES (70 , TO_DATE('2022-10-25', 'yyyy-mm-dd') , 'mobile' , 0, 58382, 'Tae gyu Kim' , 'KOR' , '052838715781' , '003509484705');
Commit;
/*DNG_TXN TABLE*/
INSERT INTO DNG_TXN VALUES (1 , 500, 'transfer too much money.' , '0');
INSERT INTO DNG_TXN VALUES (15 , 800, 'Suspicious person.' , '3');
INSERT INTO DNG_TXN VALUES (16 , 801, 'Suspicious person.' , '3');
INSERT INTO DNG_TXN VALUES (19 , 900, 'Suspicious person.' , '3');
INSERT INTO DNG_TXN VALUES (22 , 860, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES (23 , 271, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES (24 , 649, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES (25 , 322, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES (26 , 613, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES (27 , 929, 'Suspicious person & account.' , '3');
INSERT INTO DNG_TXN VALUES (28 , 936, 'Suspicious person & account.' , '1');
INSERT INTO DNG_TXN VALUES (29 , 568, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES (30 , 327, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES (31 , 840, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES (32 , 624, 'Suspicious account.' , '3');
INSERT INTO DNG_TXN VALUES (33 , 453, 'Suspicious account.' , '3');
INSERT INTO DNG_TXN VALUES (34 , 199, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES (35 , 779, 'Suspicious account.' , '3');
INSERT INTO DNG_TXN VALUES (36 , 756, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES (37 , 811, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES (38 , 460, 'Suspicious person & account.' , '2');
INSERT INTO DNG_TXN VALUES (39 , 791, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES (40 , 550, 'Suspicious account & transfer too much money.' , '1');
INSERT INTO DNG_TXN VALUES (41 , 440, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES (42 , 591, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES (43 , 898, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES (44 , 256, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES (45 , 761, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES (46 , 370, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES (47 , 720, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES (48 , 806, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES (49 , 493, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES (50 , 272, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES (51 , 271, 'Suspicious person.' , '0');
INSERT INTO DNG_TXN VALUES (52 , 670, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES (53 , 340, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES (54 , 478, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES (55 , 984, 'Suspicious person & account.' , '2');
INSERT INTO DNG_TXN VALUES (56 , 806, 'Suspicious person & account.' , '3');
INSERT INTO DNG_TXN VALUES (57 , 807, 'Suspicious person & account.' , '2');