-
Notifications
You must be signed in to change notification settings - Fork 0
/
queries.sql
1818 lines (1818 loc) · 153 KB
/
queries.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
INSERT INTO patient VALUES
("PT793304", "Aubrey", "Young", "Lot. 54, Jalan Abdul Rahim Kajai 29/30, Kuala Terengganu, Terengganu", "0184752609", "1973-1-10", "female", "Widowed", "2020-7-6"),
("PT092961", "Elijah", "Stewart", "No. 15, Jalan Ledang 5/22, Kapit, Sarawak", "01133808908", "1995-3-5", "male", "Widowed", "2019-8-18"),
("PT781238", "Hazel", "Nguyen", "23, Jalan Eaton 21/19, Gua Musang, Kelantan", "01758743586", "1944-1-28", "female", "Married", "2019-11-10"),
("PT671712", "Ava", "Turner", "76, Jalan Loke Yew 10/31, Bagan Serai, Perak", "01452328125", "2000-7-12", "female", "Single", "2019-3-28"),
("PT142001", "Gianna", "Gomez", "62, Jalan Ritchie 39/21, Yong Peng, Johor", "0179237878", "1957-3-1", "female", "Divorced", "2018-5-12"),
("PT898684", "Elijah", "Taylor", "Lot. 7, Jalan Genting Klang 33/20, Kuala Selangor, Selangor", "0133697785", "2001-3-25", "male", "Single", "2019-3-10"),
("PT725408", "Luke", "Lavoie", "28, Jalan Mahkamah Tinggi 25/39, Labuan", "0141665611", "1993-10-28", "male", "Single", "2019-10-25"),
("PT310604", "Paisley", "Sanders", "Lot. 20, Jalan Thambusamy 42/3, Teluk Bahang, Penang", "01883913482", "2000-5-25", "female", "Single", "2019-2-12"),
("PT419770", "Elizabeth", "Morgan", "79, Jalan Tuanku Abdul Halim 48/44, Teluk Intan, Perak", "0189274850", "1996-3-15", "female", "Single", "2018-6-29"),
("PT223103", "Liam", "Torres", "36, Jalan Sin Chee 9/38, Labuan", "01391606488", "2011-2-14", "male", "Single", "2018-10-2"),
("PT187381", "Madelyn", "Watson", "No. 77, Jalan Wisma Putra 48/26, Taiping, Perak", "01353001204", "2009-11-19", "female", "Single", "2019-6-29"),
("PT426888", "Anthony", "Cruz", "Lot. 13, Jalan Bangsar 4/9, Simpang Empat, Perak", "0191633967", "1956-6-7", "male", "Widowed", "2018-2-24"),
("PT964730", "John", "Collins", "Lot. 45, Jalan Walter Grenier 18/31, Sibu, Sarawak", "0133673564", "1994-1-22", "male", "Divorced", "2019-12-6"),
("PT482729", "Penelope", "Phillips", "Lot. 33, Jalan Dewan Bahasa 37/27, Kuang, Selangor", "0130329928", "1999-1-20", "female", "Single", "2018-8-11"),
("PT190388", "Ethan", "Edwards", "No. 60, Jalan Dewan Sultan Sulaiman 41/44, Pulau Sebang, Malacca", "01899147676", "1951-10-14", "male", "Widowed", "2018-10-19"),
("PT853394", "Amelia", "Morales", "Lot. 71, Jalan Galloway 25/28, Kuala Lumpur", "01780922736", "1971-2-25", "female", "Widowed", "2020-11-21"),
("PT303977", "Paisley", "Edwards", "Lot. 71, Jalan Tan Cheng Lock 6/14, Pantai Remis, Perak", "0164610046", "1947-8-24", "female", "Divorced", "2019-4-26"),
("PT592778", "Elijah", "Butler", "No. 68, Jalan Sentul 3/18, Mengkarak, Pahang", "0167366189", "1946-11-17", "male", "Single", "2019-7-2"),
("PT649464", "Joseph", "Cruz", "Lot. 43, Jalan Thambusamy 35/32, Jertih, Terengganu", "0129369965", "1979-2-2", "male", "Single", "2018-3-13"),
("PT415951", "Lily", "Allen", "37, Jalan Abdul Razak Hussin 20/49, Labuan", "01785734330", "1966-9-24", "female", "Widowed", "2018-4-27"),
("PT946163", "Hailey", "Moore", "Lot. 69, Jalan Ampang 44/24, Kinarut, Sabah", "0113726092", "1959-2-26", "female", "Widowed", "2018-5-4"),
("PT045199", "Grayson", "Richardson", "No. 65, Jalan Mahkamah Persekutuan 36/20, Bahau, Negeri Sembilan", "01161507151", "1966-5-27", "male", "Single", "2020-8-27"),
("PT394377", "Luke", "Roberts", "Lot. 7, Jalan Kebun Bunga 22/30, Nenasi, Pahang", "01429638492", "2009-11-12", "male", "Single", "2019-4-5"),
("PT756421", "Aiden", "Walker", "No. 64, Jalan Yaacob Latif 35/48, Keningau, Sabah", "0133260183", "1977-12-7", "male", "Married", "2018-1-30"),
("PT341831", "Isabella", "Carter", "No. 37, Jalan Cenderawasih 2/21, Kuala Terengganu, Terengganu", "0188039613", "1983-10-28", "female", "Widowed", "2020-11-29"),
("PT083401", "Madelyn", "Perez", "39, Jalan Yaacob Latif 25/25, Kinarut, Sabah", "01484232821", "1984-9-26", "female", "Single", "2018-12-24"),
("PT626471", "Lillian", "Roy", "No. 11, Jalan Kia Peng 26/19, Sibu, Sarawak", "0157779790", "1949-1-16", "female", "Married", "2018-9-25"),
("PT563653", "Alexander", "Stewart", "Lot. 15, Jalan Pahang 37/31, Sibu, Sarawak", "01880218494", "1946-7-27", "male", "Widowed", "2018-7-28"),
("PT997491", "Mason", "Clark", "Lot. 55, Jalan Petaling 4/43, Tanjung Kling, Malacca", "01688666836", "1942-7-26", "male", "Widowed", "2018-1-2"),
("PT341587", "Daniel", "Gonzalez", "Lot. 75, Jalan Robertson 36/20, Batu Arang, Selangor", "01902455856", "2004-9-9", "male", "Single", "2019-1-17"),
("PT825606", "Grayson", "Brooks", "Lot. 78, Jalan Tun Sambanthan 1/25, Kuala Lumpur", null, "2020-3-11", "male", "Single", "2020-12-7"),
("PT770659", "Isla", "Gonzalez", "No. 28, Jalan Genting Klang 43/14, Putrajaya", "01533410207", "1985-12-13", "female", "Widowed", "2020-2-17"),
("PT094544", "Ariana", "Gagné", "37, Jalan Hang Lekiu 32/34, Bukit Tambun, Penang", "01513701154", "1978-8-19", "female", "Married", "2019-8-1"),
("PT061062", "Natalie", "Sullivan", "Lot. 73, Jalan Robson 50/7, Kangar, Perlis", "0119706234", "2006-11-14", "female", "Single", "2018-5-29"),
("PT658536", "Ethan", "Foster", "Lot. 12, Jalan Mahkamah Tinggi 22/29, Ranau, Sabah", "01101803366", "1984-12-9", "male", "Widowed", "2018-11-7"),
("PT982061", "Isla", "Roy", "31, Jalan Kinabalu (part of) 16/9, Pulai Chondong, Kelantan", "01984891059", "1968-7-28", "female", "Divorced", "2020-5-21"),
("PT213206", "Isabella", "Smith", "No. 56, Jalan Petaling 16/30, Kertih, Terengganu", "0126976511", "1992-2-9", "female", "Single", "2020-11-4"),
("PT455041", "Ellie", "Scott", "35, Jalan Yap Tai Chi 20/23, Kinarut, Sabah", null, "2015-5-14", "female", "Single", "2019-5-9"),
("PT307417", "Emma", "Morales", "43, Jalan Bukit Tunku 48/29, Serendah, Selangor", "01219437215", "1999-1-17", "female", "Divorced", "2020-1-6"),
("PT680493", "Henry", "Cooper", "Lot. 75, Jalan Chan Sow Lin 44/50, Kota Kinabalu, Sabah", "01447095008", "1963-9-27", "male", "Single", "2019-10-8"),
("PT522021", "Sebastian", "Nelson", "Lot. 50, Jalan Raja Muda Musa 5/6, Putrajaya", "01743559710", "1990-3-20", "male", "Single", "2019-8-7"),
("PT521293", "Anna", "Sullivan", "63, Jalan Madge 34/5, Beranang, Selangor", "01937174743", "1999-10-23", "female", "Widowed", "2018-8-8"),
("PT949001", "James", "Brooks", "No. 16, Jalan Maybank 5/11, Bidor, Perak", "01181643125", "2007-12-25", "male", "Single", "2020-7-17"),
("PT797020", "Henry", "Walker", "Lot. 12, Jalan Yap Ah Shak 12/47, Labuan", "01560075284", "1941-12-29", "male", "Married", "2019-3-6"),
("PT298650", "Nova", "Nelson", "No. 65, Jalan Belfield 4/28, Putrajaya", "0185286036", "1948-7-26", "female", "Divorced", "2019-5-28"),
("PT697827", "Logan", "Wilson", "Lot. 26, Jalan Sultan Ismail 19/48, Cukai, Terengganu", "01491738129", "2001-10-3", "male", "Single", "2018-2-19"),
("PT510957", "Elena", "Richardson", "Lot. 60, Jalan Rosli Buang 34/3, Kuala Kedah, Kedah", "0111852221", "1971-8-18", "female", "Divorced", "2019-10-26"),
("PT237936", "Zoey", "Diaz", "No. 43, Jalan Galloway 23/29, Labuan", null, "2015-5-2", "female", "Single", "2019-9-18"),
("PT157063", "Aubrey", "Robinson", "68, Jalan Tun Tan Siew Sin 31/49, Pasir Gudang Baru, Johor", "01335423269", "1988-7-5", "female", "Widowed", "2019-2-11"),
("PT622291", "Kennedy", "Nelson", "70, Jalan Walter Grenier 34/23, Miri, Sarawak", "0122648193", "1953-11-7", "female", "Divorced", "2018-6-20"),
("PT308815", "Ava", "Hill", "Lot. 31, Jalan Doraisamy 16/45, Arau, Perlis", null, "2016-6-15", "female", "Single", "2019-7-2"),
("PT140145", "Lillian", "Rivera", "No. 19, Jalan Raja Laut 48/45, Sandakan, Sabah", "0183985249", "1968-2-17", "female", "Widowed", "2020-6-4"),
("PT736378", "Logan", "Nguyen", "Lot. 24, Jalan Raja Bot 49/32, Pantai Remis, Perak", "0196171638", "1963-12-13", "male", "Widowed", "2019-5-1"),
("PT030684", "Ruby", "Fisher", "Lot. 11, Jalan Tun Razak 32/38, Labuan", null, "2014-9-8", "female", "Single", "2018-2-26"),
("PT595537", "Mateo", "Gonzalez", "74, Jalan Sungai Besi 3/27, Teluk Bahang, Penang", "0197529730", "1951-1-13", "male", "Widowed", "2019-8-24"),
("PT582398", "Layla", "Foster", "68, Jalan Wisma Putra 37/38, Seremban 3, Negeri Sembilan", null, "2014-11-16", "female", "Single", "2019-9-11"),
("PT212310", "Gabriella", "Wood", "Lot. 46, Jalan Langgak Golf 1/16, Kuala Lumpur", "0179411837", "1954-4-27", "female", "Single", "2020-3-3"),
("PT532371", "Lucas", "Watson", "15, Jalan Samarahan 30/24, Selayang, Selangor", "0179307605", "1981-5-15", "male", "Single", "2020-10-13"),
("PT391607", "Alexander", "Martin", "No. 14, Jalan Maybank 40/30, Labuan", null, "2012-11-10", "male", "Single", "2019-2-9"),
("PT101811", "Noah", "Richardson", "79, Jalan Robertson 5/49, Kuala Perlis, Perlis", "0176788286", "1974-8-13", "male", "Single", "2019-5-10"),
("PT339093", "Leo", "Phillips", "29, Jalan Rosli Buang 45/27, Sungai Udang, Malacca", "01199072844", "1992-3-23", "male", "Widowed", "2019-10-20"),
("PT941129", "Gabriel", "Gutierrez", "No. 1, Jalan Kinabalu 19/33, Labuan", "01026593234", "1983-5-20", "male", "Divorced", "2019-1-27"),
("PT759287", "Avery", "Nelson", "62, Jalan Hang Tuah 14/23, Kuala Kedah, Kedah", "0181722247", "1973-5-8", "female", "Divorced", "2018-2-8"),
("PT184331", "Avery", "Mitchell", "Lot. 6, Jalan Cenderawasih 44/38, Kampung Lemal, Kelantan", "0153307754", "1992-9-9", "female", "Single", "2019-1-11"),
("PT516320", "Oliver", "Smith", "No. 7, Jalan Kampung Attap 3/18, Kota Belud, Sabah", "0142189907", "2009-4-16", "male", "Single", "2019-8-21"),
("PT316853", "Benjamin", "Phillips", "Lot. 54, Jalan Raja Chulan 46/38, Sungai Petan, Kedah", "0156488587", "1956-3-29", "male", "Single", "2020-7-3"),
("PT972132", "Isaac", "Rivera", "15, Jalan Thavers 44/49, Putrajaya", "01768060202", "1967-10-29", "male", "Widowed", "2019-6-28"),
("PT753771", "Grayson", "Garcia", "47, Jalan Bukit Tunku 23/45, Labis, Johor", "01276933835", "1944-7-15", "male", "Widowed", "2019-6-5"),
("PT172657", "Matthew", "Côté", "Lot. 16, Jalan Datuk Sulaiman 7/33, Kuala Lumpur", "01136884289", "1990-4-1", "male", "Married", "2019-11-16"),
("PT718043", "Sophia", "Carter", "Lot. 49, Jalan Hang Kasturi 16/28, Sungai Petan, Kedah", "01194282712", "1997-12-8", "female", "Widowed", "2019-1-18"),
("PT822677", "Gianna", "Thomas", "57, Jalan Chan Sow Lin 22/6, Jertih, Terengganu", "01211425227", "1976-5-29", "female", "Widowed", "2019-3-28"),
("PT829829", "John", "Parker", "5, Jalan Kia Peng 44/43, Yong Peng, Johor", "01360745127", "1977-7-8", "male", "Widowed", "2018-3-26"),
("PT254477", "Emma", "Jackson", "Lot. 66, Jalan Raja 27/38, Kuala Lumpur", "01728573674", "1997-1-8", "female", "Divorced", "2019-7-11"),
("PT784510", "John", "Hall", "Lot. 52, Jalan Kia Peng 26/7, Bukit Mertajam, Penang", "01368387676", "1967-4-17", "male", "Widowed", "2018-12-5"),
("PT094612", "Naomi", "Bouchard", "17, Jalan Ampang 44/8, Labuan", "0166694347", "1993-11-22", "female", "Married", "2019-6-13"),
("PT197830", "Noah", "Taylor", "No. 49, Jalan Maharajalela 14/8, Labuan", "0162756816", "1963-12-28", "male", "Married", "2018-5-8"),
("PT876164", "Daniel", "Roberts", "Lot. 11, Jalan Raja Chulan 29/32, Sri Aman, Sarawak", "0184473045", "2000-5-17", "male", "Single", "2019-5-7"),
("PT910601", "Aubrey", "Adams", "Lot. 8, Jalan Stonor 2/4, Jertih, Terengganu", null, "2015-11-3", "female", "Single", "2020-8-22"),
("PT638473", "Michael", "Wood", "Lot. 70, Jalan U-Thant 11/26, Jerantut, Pahang", "0106847360", "2001-11-27", "male", "Single", "2019-11-19"),
("PT965500", "Elizabeth", "Sullivan", "Lot. 72, Jalan Sin Chew Kee 28/44, Kertih, Terengganu", "01798713282", "1962-3-9", "female", "Single", "2020-10-27"),
("PT220818", "Valentina", "Green", "Lot. 67, Jalan Tangsi 16/9, Kuala Sawah, Negeri Sembilan", "01671871135", "1979-11-17", "female", "Single", "2020-9-12"),
("PT001717", "Abigail", "Williams", "1, Jalan Langgak Golf 36/32, Semenyih, Selangor", "0147199193", "1994-5-7", "female", "Married", "2018-4-6"),
("PT372292", "Gianna", "Hill", "No. 66, Jalan Hang Kasturi 42/33, Kota Tinggi, Johor", "0141401075", "1974-7-4", "female", "Widowed", "2018-6-13"),
("PT668266", "Benjamin", "Cook", "No. 53, Jalan Eaton 5/23, Pokok Sena, Kedah", "0198346775", "1993-5-20", "male", "Married", "2018-4-3"),
("PT272742", "Gabriel", "Morin", "Lot. 29, Jalan Balai Polis 27/37, Nenasi, Pahang", "0179422266", "1971-2-12", "male", "Single", "2019-5-21"),
("PT341632", "Joseph", "Rodriguez", "No. 14, Jalan Yaacob Latif 9/1, Kuala Sungai Baru, Malacca", "01886922324", "1969-10-30", "male", "Single", "2018-4-25"),
("PT961975", "Alexander", "Sullivan", "Lot. 64, Jalan Cochrane 50/7, Pulai Chondong, Kelantan", "0113844589", "1994-6-18", "male", "Married", "2020-8-23"),
("PT793619", "Samuel", "Morin", "54, Jalan Tun Mohd Fuad 28/1, Bukit Tinggi, Pahang", "01279953879", "1964-11-11", "male", "Married", "2018-7-4"),
("PT968114", "Allison", "Cook", "Lot. 50, Jalan Imbi 20/43, Muar, Johor", "0150440211", "2004-10-30", "female", "Single", "2018-3-29"),
("PT690481", "Logan", "Williams", "Lot. 16, Jalan Sri Amar 46/50, Butterworth, Penang", "0198942730", "2006-4-5", "male", "Single", "2020-9-28"),
("PT191719", "Leah", "Côté", "No. 12, Jalan Robertson 6/41, Kuala Lumpur", "0108516670", "1999-5-18", "female", "Single", "2020-11-2"),
("PT681292", "William", "Phillips", "Lot. 78, Jalan Pasar Besar 21/24, Arau, Perlis", "0148410598", "1983-5-21", "male", "Married", "2020-5-18"),
("PT362725", "Hailey", "Brooks", "No. 69, Jalan Stonor 11/26, Mambau, Negeri Sembilan", "0163459697", "1953-1-28", "female", "Widowed", "2019-7-26"),
("PT720879", "Sebastian", "Smith", "47, Jalan Wan Kadir 42/6, Labuan", "0198821232", "1992-5-26", "male", "Married", "2020-9-25"),
("PT287289", "Aubrey", "Nelson", "Lot. 23, Jalan Tuanku Abdul Halim 48/6, Machap Baru, Malacca", "01686983691", "2007-12-19", "female", "Single", "2018-4-25"),
("PT709995", "Emilia", "Gutierrez", "Lot. 35, Jalan Tun Sambanthan 33/25, Genting Sempah, Pahang", "01786940380", "1974-3-15", "female", "Married", "2018-3-11"),
("PT217719", "Daniel", "Hernandez", "Lot. 70, Jalan Wan Kadir 42/14, Jertih, Terengganu", "0168568279", "1947-10-17", "male", "Single", "2020-2-14"),
("PT851571", "Matthew", "Rodriguez", "Lot. 1, Jalan Yap Kwan Seng 36/45, Semenyih, Selangor", "01020092227", "1957-10-22", "male", "Divorced", "2020-7-11"),
("PT800759", "Liam", "Sullivan", "62, Jalan U-Thant 37/36, Kuala Lumpur", null, "2018-9-14", "male", "Single", "2018-8-14"),
("PT625389", "Hazel", "Gagné", "39, Jalan Punchak 34/22, Kuala Kangsar, Perak", "0158151140", "1963-11-22", "female", "Divorced", "2019-5-24");
INSERT INTO pt_ntk VALUES
("PT793304", "0", "Liam", "Young", "Father", "No. 16, Jalan Bukit Ceylon 28/7, Sungai Besar, Selangor", "0102353010"),
("PT793304", "1", "Olivia", "Ortiz", "Mother", "No. 2, Jalan Thambi Dollah 22/39, Teluk Kumbar, Penang", "01367980194"),
("PT793304", "2", "Avery", "Young", "Sister", "33, Jalan Loke Yew 5/1, Kuala Lumpur", "01834630104"),
("PT793304", "3", "Luke", "Young", "Brother", "Lot. 54, Jalan Abdul Rahim Kajai 29/30, Kuala Terengganu, Terengganu", "0124087357"),
("PT092961", "4", "Sebastian", "Stewart", "Father", "No. 10, Jalan Thambi Dollah 45/14, Arau, Perlis", "01535469361"),
("PT092961", "5", "Cora", "Stewart", "Sister", "No. 39, Jalan Genting Klang 47/20, Serendah, Selangor", "01746700208"),
("PT781238", "6", "William", "Nguyen", "Father", "23, Jalan Eaton 21/19, Gua Musang, Kelantan", "01369646109"),
("PT781238", "7", "Eliana", "Wright", "Mother", "No. 31, Jalan Talalla 23/26, Kuala Lumpur", "01097661368"),
("PT671712", "8", "Theodore", "Turner", "Father", "76, Jalan Loke Yew 10/31, Bagan Serai, Perak", "01689767266"),
("PT671712", "9", "Ariana", "Turner", "Sister", "76, Jalan Loke Yew 10/31, Bagan Serai, Perak", "01240618958"),
("PT671712", "10", "Anthony", "Turner", "Brother", "76, Jalan Loke Yew 10/31, Bagan Serai, Perak", "01417346701"),
("PT142001", "11", "Scarlett", "Martinez", "Mother", "No. 37, Jalan Pudu 22/36, Labuan", "0153741571"),
("PT142001", "12", "Gabriel", "Gomez", "Brother", "62, Jalan Ritchie 39/21, Yong Peng, Johor", "01206400839"),
("PT898684", "13", "Penelope", "Taylor", "Sister", "72, Jalan Madge 37/33, Subang Jaya, Selangor", "0138251028"),
("PT898684", "14", "Noah", "Taylor", "Brother", "Lot. 5, Jalan Tun Mohd Fuad 50/3, Parit Buntar, Perak", "01716281381"),
("PT725408", "15", "Isaac", "Lavoie", "Father", "28, Jalan Mahkamah Tinggi 25/39, Labuan", "01052524327"),
("PT725408", "16", "Mila", "Sanders", "Mother", "28, Jalan Mahkamah Tinggi 25/39, Labuan", "0127335232"),
("PT310604", "17", "John", "Sanders", "Father", "No. 71, Jalan Gallagher 21/50, Kapit, Sarawak", "0132156062"),
("PT310604", "18", "Sofia", "Sanders", "Sister", "Lot. 20, Jalan Thambusamy 42/3, Teluk Bahang, Penang", "01264649319"),
("PT419770", "19", "Noah", "Morgan", "Father", "No. 36, Jalan Saimun Tarikat 22/48, Belimbing, Pahang", "01857527835"),
("PT419770", "20", "David", "Morgan", "Brother", "40, Jalan Tun Sambanthan 4/39, Bandar Labuan, Sabah", "0132117091"),
("PT223103", "21", "Ivy", "Torres", "Sister", "36, Jalan Sin Chee 9/38, Labuan", "01085476620"),
("PT223103", "22", "Elijah", "Torres", "Brother", "Lot. 54, Jalan Chan Wing 22/44, Kuala Kedah, Kedah", "0186853043"),
("PT187381", "23", "Elijah", "Watson", "Father", "Lot. 5, Jalan Chow Kit 4/37, Kuah, Kedah", "01832861305"),
("PT187381", "24", "Henry", "Watson", "Brother", "No. 43, Jalan Ampang 10/13, Putrajaya", "01561216297"),
("PT426888", "25", "Grayson", "Cruz", "Father", "Lot. 13, Jalan Bangsar 4/9, Simpang Empat, Perak", "01856514567"),
("PT426888", "26", "Savannah", "Scott", "Mother", "54, Jalan Haji Yahya Sheikh Ahmad 12/40, Kuang, Selangor", "0133895822"),
("PT426888", "27", "Caroline", "Cruz", "Sister", "No. 15, Jalan Ampang Hilir 41/41, Bukit Tambun, Penang", "01657016793"),
("PT426888", "28", "James", "Cruz", "Brother", "No. 44, Jalan Zaaba 26/26, Gurun, Kedah", "0102206995"),
("PT964730", "29", "James", "Collins", "Father", "Lot. 45, Jalan Walter Grenier 18/31, Sibu, Sarawak", "01613759970"),
("PT482729", "30", "Alexander", "Phillips", "Father", "31, Jalan Kia Peng 47/20, Sungai Gadut, Negeri Sembilan", "01882165241"),
("PT482729", "31", "Zoe", "Long", "Mother", "Lot. 33, Jalan Dewan Bahasa 37/27, Kuang, Selangor", "0179141952"),
("PT190388", "32", "Dylan", "Edwards", "Father", "No. 16, Jalan Mahkamah Tinggi 10/33, Bedong, Kedah", "01054768539"),
("PT853394", "33", "Ethan", "Morales", "Father", "Lot. 71, Jalan Galloway 25/28, Kuala Lumpur", "01087070306"),
("PT853394", "34", "Daniel", "Morales", "Brother", "Lot. 25, Jalan Kinabalu 34/7, Ramuan China, Malacca", "01640174206"),
("PT303977", "35", "John", "Edwards", "Father", "11, Jalan Hang Lekiu 15/41, Pasir Panjang, Negeri Sembilan, Negeri Sembilan", "0136741825"),
("PT303977", "36", "Harper", "Jackson", "Mother", "No. 55, Jalan Berhala 3/44, Labuan", "01697769493"),
("PT303977", "37", "Mila", "Edwards", "Sister", "Lot. 48, Jalan Doraisamy 19/5, Bagan Serai, Perak", "0142734847"),
("PT592778", "38", "Carter", "Butler", "Father", "58, Jalan Tun Mohd Fuad 26/18, Puchong, Selangor", "0132204657"),
("PT592778", "39", "Mia", "Howard", "Mother", "No. 68, Jalan Sentul 3/18, Mengkarak, Pahang", "01567587947"),
("PT592778", "40", "Bella", "Butler", "Sister", "Lot. 18, Jalan Tun Razak 21/23, Kuah, Kedah", "0123550653"),
("PT649464", "41", "Camila", "Parker", "Mother", "Lot. 28, Jalan Doktor Latif 49/50, Melaka Pindah, Malacca", "01142264295"),
("PT649464", "42", "Gabriel", "Cruz", "Brother", "No. 41, Jalan Stonor 34/25, Sarikei, Sarawak", "0143104076"),
("PT415951", "43", "Julian", "Allen", "Father", "37, Jalan Abdul Razak Hussin 20/49, Labuan", "01895630202"),
("PT946163", "44", "Charlotte", "Cruz", "Mother", "Lot. 69, Jalan Ampang 44/24, Kinarut, Sabah", "01850492753"),
("PT946163", "45", "Mia", "Moore", "Sister", "No. 3, Jalan Raja Chulan 37/35, Sibu, Sarawak", "0197926640"),
("PT946163", "46", "Mason", "Moore", "Brother", "Lot. 68, Jalan Doraisamy 6/19, Tapah Road, Perak", "0187315272"),
("PT045199", "47", "Ethan", "Richardson", "Father", "No. 75, Jalan Datuk Sulaiman 3/14, Kampong Pangkal Kalong, Kelantan", "01779583424"),
("PT394377", "48", "Allison", "Young", "Mother", "Lot. 7, Jalan Kebun Bunga 22/30, Nenasi, Pahang", "0178685253"),
("PT756421", "49", "Daniel", "Walker", "Father", "No. 64, Jalan Yaacob Latif 35/48, Keningau, Sabah", "01578276572"),
("PT756421", "50", "Sophia", "King", "Mother", "58, Jalan Vivekananda 49/18, Bedong, Kedah", "0147690030"),
("PT756421", "51", "John", "Walker", "Brother", "No. 64, Jalan Yaacob Latif 35/48, Keningau, Sabah", "01498963770"),
("PT756421", "52", "Brooklyn", "Roy", "Spouse", "No. 64, Jalan Yaacob Latif 35/48, Keningau, Sabah", "0150908870"),
("PT341831", "53", "Lucas", "Carter", "Father", "4, Jalan Sin Chew Kee 15/13, Kuala Lumpur", "0109832394"),
("PT341831", "54", "John", "Carter", "Brother", "No. 11, Jalan Belfield 46/30, Gurun, Kedah", "01768106501"),
("PT083401", "55", "Luke", "Perez", "Father", "39, Jalan Yaacob Latif 25/25, Kinarut, Sabah", "01433599249"),
("PT083401", "56", "Mason", "Perez", "Brother", "No. 16, Jalan Hang Jebat 33/19, Ketari, Pahang", "01118350447"),
("PT563653", "57", "Anna", "Taylor", "Mother", "Lot. 15, Jalan Pahang 37/31, Sibu, Sarawak", "01788259127"),
("PT997491", "58", "Henry", "Clark", "Father", "Lot. 55, Jalan Petaling 4/43, Tanjung Kling, Malacca", "01260171522"),
("PT341587", "59", "Michael", "Gonzalez", "Father", "Lot. 75, Jalan Robertson 36/20, Batu Arang, Selangor", "0135883268"),
("PT341587", "60", "Mila", "Gonzalez", "Sister", "No. 65, Jalan Leong Yew Koh 29/14, Putrajaya", "01417069416"),
("PT341587", "61", "Samuel", "Gonzalez", "Brother", "Lot. 75, Jalan Robertson 36/20, Batu Arang, Selangor", "0169388436"),
("PT770659", "62", "William", "Gonzalez", "Father", "Lot. 1, Jalan Pasar Besar 2/28, Siliau, Negeri Sembilan", "0109129209"),
("PT770659", "63", "Elijah", "Gonzalez", "Brother", "No. 37, Jalan Kinabalu (part of) 20/38, Sungai Petan, Kedah", "01902651697"),
("PT094544", "64", "Willow", "Tremblay", "Mother", "37, Jalan Hang Lekiu 32/34, Bukit Tambun, Penang", "0188898182"),
("PT094544", "65", "Ethan", "Gagné", "Brother", "Lot. 78, Jalan Carutthers 4/7, Labuan", "01296599571"),
("PT094544", "66", "Julian", "Brown", "Spouse", "Lot. 19, Jalan Carutthers 47/3, Tangkak, Johor", "0183805464"),
("PT061062", "67", "Violet", "Stewart", "Mother", "Lot. 73, Jalan Robson 50/7, Kangar, Perlis", "0194080037"),
("PT061062", "68", "Ella", "Sullivan", "Sister", "Lot. 73, Jalan Robson 50/7, Kangar, Perlis", "01460532169"),
("PT061062", "69", "Logan", "Sullivan", "Brother", "No. 58, Jalan Tun Razak 12/6, Kuala Perlis, Perlis", "0139270938"),
("PT658536", "70", "Jayden", "Foster", "Father", "63, Jalan Hang Jebat 26/36, Kampong Kadok, Kelantan", "01935778858"),
("PT658536", "71", "Cora", "Powell", "Mother", "Lot. 12, Jalan Mahkamah Tinggi 22/29, Ranau, Sabah", "01404678433"),
("PT658536", "72", "Leah", "Foster", "Sister", "Lot. 12, Jalan Mahkamah Tinggi 22/29, Ranau, Sabah", "01144861026"),
("PT982061", "73", "John", "Roy", "Father", "No. 20, Jalan Kampung Attap 2/42, Kudat, Sabah", "01289733226"),
("PT982061", "74", "Nova", "Tremblay", "Mother", "31, Jalan Kinabalu (part of) 16/9, Pulai Chondong, Kelantan", "01053788868"),
("PT982061", "75", "Michael", "Roy", "Brother", "52, Jalan Lenggu ak China 19/44, Ulu Tiram, Johor", "0121449888"),
("PT213206", "76", "Liam", "Smith", "Father", "Lot. 1, Jalan Bangsar 10/6, Putrajaya", "01266279885"),
("PT455041", "77", "Daniel", "Scott", "Father", "No. 19, Jalan Damansara 13/2, Bukit Katil, Malacca", "0149201264"),
("PT455041", "78", "Elizabeth", "Wood", "Mother", "No. 2, Jalan Tuanku Jaafar 46/16, Kuala Dungun, Terengganu", "0175079163"),
("PT455041", "79", "Grace", "Scott", "Sister", "No. 28, Jalan Pasar 28/1, Labis, Johor", "0110739489"),
("PT455041", "80", "Matthew", "Scott", "Brother", "42, Jalan Cenderawasih 43/49, Labuan", "01645963091"),
("PT307417", "81", "Gabriel", "Morales", "Father", "43, Jalan Bukit Tunku 48/29, Serendah, Selangor", "0141597520"),
("PT307417", "82", "Natalie", "Brown", "Mother", "43, Jalan Bukit Tunku 48/29, Serendah, Selangor", "01248764284"),
("PT307417", "83", "Allison", "Morales", "Sister", "Lot. 49, Jalan Dato' Onn 34/42, Putrajaya", "01077494900"),
("PT680493", "84", "Ava", "Cooper", "Sister", "No. 7, Jalan Hang Jebat 28/12, Kuala Lumpur", "0104010469"),
("PT680493", "85", "Luke", "Cooper", "Brother", "Lot. 40, Jalan U-Thant 26/45, Kangar, Perlis", "01963842621"),
("PT522021", "86", "Eliana", "Bennett", "Mother", "63, Jalan Tugu 13/1, Pulai Chondong, Kelantan", "01885504969"),
("PT522021", "87", "Owen", "Nelson", "Brother", "Lot. 50, Jalan Raja Muda Musa 5/6, Putrajaya", "01087029507"),
("PT521293", "88", "Mateo", "Sullivan", "Father", "63, Jalan Madge 34/5, Beranang, Selangor", "01667076194"),
("PT521293", "89", "Mila", "Foster", "Mother", "No. 19, Jalan Kinabalu (part of) 24/19, Labuan", "0162771694"),
("PT521293", "90", "Serenity", "Sullivan", "Sister", "No. 8, Jalan Alor 12/19, Kuala Lumpur", "01860131209"),
("PT521293", "91", "David", "Sullivan", "Brother", "31, Jalan Raja Alang 3/46, Batang Berjuntai, Selangor", "01672448979"),
("PT949001", "92", "Maya", "Brooks", "Sister", "No. 16, Jalan Maybank 5/11, Bidor, Perak", "01540869326"),
("PT797020", "93", "Matthew", "Walker", "Father", "No. 66, Jalan Tuanku Jaafar 48/41, Kuah, Kedah", "0170073903"),
("PT797020", "94", "Savannah", "Cox", "Spouse", "Lot. 27, Jalan Kuching 8/12, Peringat, Kelantan", "01073588814"),
("PT697827", "95", "Sebastian", "Wilson", "Father", "Lot. 26, Jalan Sultan Ismail 19/48, Cukai, Terengganu", "01006231921"),
("PT697827", "96", "Mila", "Wilson", "Sister", "No. 67, Jalan Mahkamah Persekutuan 43/22, Jertih, Terengganu", "01848738690"),
("PT510957", "97", "Ella", "Nguyen", "Mother", "Lot. 72, Jalan Ampang Hilir 21/40, Kuching, Sarawak", "0159748699"),
("PT510957", "98", "Hailey", "Richardson", "Sister", "70, Jalan Kampung Bandar Dalam 44/33, Ketereh, Kelantan", "0103121052"),
("PT510957", "99", "Owen", "Richardson", "Brother", "No. 67, Jalan Dang Wangi 49/48, Labuan", "01086444499"),
("PT237936", "100", "Lucas", "Diaz", "Father", "Lot. 41, Jalan Parlimen 11/43, Semenyih, Selangor", "0107511320"),
("PT237936", "101", "Gabriella", "Diaz", "Sister", "No. 43, Jalan Galloway 23/29, Labuan", "01201218448"),
("PT237936", "102", "Carter", "Diaz", "Brother", "Lot. 54, Jalan U-Thant 24/10, Pokok Sena, Kedah", "0141590532"),
("PT157063", "103", "Mateo", "Robinson", "Father", "48, Jalan Choo Cheeng Kay 10/39, Simpang Pertang, Negeri Sembilan", "0129918280"),
("PT157063", "104", "Alice", "Robinson", "Sister", "68, Jalan Tun Tan Siew Sin 31/49, Pasir Gudang Baru, Johor", "0180478368"),
("PT622291", "105", "Leo", "Nelson", "Father", "70, Jalan Walter Grenier 34/23, Miri, Sarawak", "0185068506"),
("PT622291", "106", "Amelia", "Price", "Mother", "Lot. 19, Jalan Gereja 3/39, Bedong, Kedah", "0155923996"),
("PT622291", "107", "Ethan", "Nelson", "Brother", "No. 43, Jalan Peel 29/12, Ketereh, Kelantan", "01392170205"),
("PT308815", "108", "Jack", "Hill", "Brother", "No. 25, Jalan Haji Yahya Sheikh Ahmad 1/1, Bintulu, Sarawak", "0124058466"),
("PT140145", "109", "Jackson", "Rivera", "Father", "42, Jalan Yaacob Latif 28/49, Pokok Sena, Kedah", "0166948249"),
("PT140145", "110", "Eleanor", "Turner", "Mother", "No. 19, Jalan Raja Laut 48/45, Sandakan, Sabah", "01196217374"),
("PT140145", "111", "Aaliyah", "Rivera", "Sister", "No. 19, Jalan Raja Laut 48/45, Sandakan, Sabah", "0158988072"),
("PT736378", "112", "Isaac", "Nguyen", "Father", "Lot. 80, Jalan Syed Putra 4/17, Bangi, Selangor", "0157701566"),
("PT736378", "113", "Kennedy", "Wood", "Mother", "Lot. 24, Jalan Raja Bot 49/32, Pantai Remis, Perak", "01071010913"),
("PT736378", "114", "Mason", "Nguyen", "Brother", "Lot. 33, Jalan Pantai Baharu 40/45, Naning, Malacca", "01518867834"),
("PT030684", "115", "Mateo", "Fisher", "Brother", "66, Jalan Chow Kit 10/8, Kapit, Sarawak", "0157078986"),
("PT595537", "116", "Isaac", "Gonzalez", "Father", "No. 21, Jalan Raja Chulan 36/46, Pasir Gudang Baru, Johor", "01966196261"),
("PT595537", "117", "Emilia", "Bell", "Mother", "56, Jalan Raja Muda Musa 24/37, Keningau, Sabah", "01857512606"),
("PT595537", "118", "Madison", "Gonzalez", "Sister", "74, Jalan Sungai Besi 3/27, Teluk Bahang, Penang", "0136979556"),
("PT595537", "119", "Owen", "Gonzalez", "Brother", "74, Jalan Sungai Besi 3/27, Teluk Bahang, Penang", "01881116710"),
("PT582398", "120", "Jack", "Foster", "Father", "No. 31, Jalan Galloway 24/50, Gurun, Kedah", "01868952935"),
("PT582398", "121", "Maya", "Moore", "Mother", "68, Jalan Wisma Putra 37/38, Seremban 3, Negeri Sembilan", "01558558058"),
("PT212310", "122", "John", "Wood", "Father", "Lot. 46, Jalan Langgak Golf 1/16, Kuala Lumpur", "01321212868"),
("PT212310", "123", "Alice", "Walker", "Mother", "Lot. 2, Jalan Tuanku Abdul Rahman 11/45, Kuala Lumpur", "01740824941"),
("PT212310", "124", "Grayson", "Wood", "Brother", "Lot. 46, Jalan Langgak Golf 1/16, Kuala Lumpur", "0143450795"),
("PT532371", "125", "Logan", "Watson", "Father", "51, Jalan Burhanuddin Helmi 19/6, Putatan, Sabah", "01024689680"),
("PT532371", "126", "Ivy", "Myers", "Mother", "Lot. 59, Jalan Yew 37/20, Putrajaya", "01201882426"),
("PT391607", "127", "Oliver", "Martin", "Brother", "No. 14, Jalan Maybank 40/30, Labuan", "0108907316"),
("PT101811", "128", "Hailey", "Richardson", "Sister", "79, Jalan Robertson 5/49, Kuala Perlis, Perlis", "01133214178"),
("PT101811", "129", "Mateo", "Richardson", "Brother", "79, Jalan Robertson 5/49, Kuala Perlis, Perlis", "01793858051"),
("PT339093", "130", "Daniel", "Phillips", "Father", "29, Jalan Rosli Buang 45/27, Sungai Udang, Malacca", "0184247513"),
("PT339093", "131", "Aurora", "Phillips", "Sister", "No. 42, Jalan Samarahan 33/40, Bandar Seri Jempol, Negeri Sembilan", "01968504452"),
("PT941129", "132", "Elijah", "Gutierrez", "Father", "No. 1, Jalan Kinabalu 19/33, Labuan", "01955683797"),
("PT941129", "133", "Mia", "Edwards", "Mother", "Lot. 37, Jalan Samarahan 1/30, Ketereh, Kelantan", "01423856661"),
("PT759287", "134", "Aubrey", "Scott", "Mother", "62, Jalan Hang Tuah 14/23, Kuala Kedah, Kedah", "01489855456"),
("PT759287", "135", "Naomi", "Nelson", "Sister", "62, Jalan Hang Tuah 14/23, Kuala Kedah, Kedah", "01637374925"),
("PT184331", "136", "Dylan", "Mitchell", "Father", "Lot. 6, Jalan Cenderawasih 44/38, Kampung Lemal, Kelantan", "0150718715"),
("PT184331", "137", "Sarah", "Mitchell", "Sister", "Lot. 29, Jalan Semarang 42/31, Gurun, Kedah", "01318321278"),
("PT516320", "138", "Hannah", "Gray", "Mother", "Lot. 46, Jalan Maharajalela 36/28, Alor Setar, Kedah", "01569960958"),
("PT516320", "139", "Samantha", "Smith", "Sister", "Lot. 69, Jalan Tugu 11/29, Gemas, Negeri Sembilan", "01544180710"),
("PT316853", "140", "Oliver", "Phillips", "Father", "No. 29, Jalan Raja Abdullah 26/14, Tumpat, Kelantan", "0125910097"),
("PT316853", "141", "Violet", "Miller", "Mother", "Lot. 34, Jalan Madge 1/20, Gertak Sanggul, Penang", "0160598779"),
("PT316853", "142", "Ivy", "Phillips", "Sister", "No. 61, Jalan Kinabalu (part of) 39/16, Tawau, Sabah", "01681333628"),
("PT316853", "143", "Anthony", "Phillips", "Brother", "61, Jalan Pasar Besar 25/5, Sungai Gadut, Negeri Sembilan", "01235914232"),
("PT972132", "144", "Jacob", "Rivera", "Father", "15, Jalan Thavers 44/49, Putrajaya", "0137074293"),
("PT972132", "145", "Paisley", "Foster", "Mother", "8, Jalan Istana 24/5, Putrajaya", "01900677793"),
("PT972132", "146", "Bella", "Rivera", "Sister", "15, Jalan Thavers 44/49, Putrajaya", "0159275552"),
("PT972132", "147", "Oliver", "Rivera", "Brother", "Lot. 80, Jalan Haji Yahya Sheikh Ahmad 33/16, Bangi, Selangor", "01799806318"),
("PT753771", "148", "Elizabeth", "Foster", "Mother", "No. 64, Jalan Tun Ismail 37/21, Mersing, Johor", "01924766392"),
("PT753771", "149", "Ivy", "Garcia", "Sister", "Lot. 10, Jalan Shelley 12/11, Kuala Terengganu, Terengganu", "0165748391"),
("PT753771", "150", "Dylan", "Garcia", "Brother", "No. 57, Jalan Kuda 12/45, Kuala Lumpur", "0163991592"),
("PT172657", "151", "Matthew", "Côté", "Father", "26, Jalan Berhala 24/36, Labuan", "01170130529"),
("PT172657", "152", "Amelia", "Cooper", "Mother", "Lot. 16, Jalan Datuk Sulaiman 7/33, Kuala Lumpur", "0117640587"),
("PT172657", "153", "Addison", "Gagnon", "Spouse", "No. 8, Jalan Bukit Tunku 14/14, Putrajaya", "01941912681"),
("PT718043", "154", "Levi", "Carter", "Father", "Lot. 49, Jalan Hang Kasturi 16/28, Sungai Petan, Kedah", "01138469733"),
("PT718043", "155", "Violet", "Perez", "Mother", "69, Jalan Punchak 18/3, Putrajaya", "0162299879"),
("PT822677", "156", "Leo", "Thomas", "Father", "22, Jalan Kuda 8/37, Batang Melaka, Malacca", "01587253749"),
("PT822677", "157", "Aria", "Lee", "Mother", "57, Jalan Chan Sow Lin 22/6, Jertih, Terengganu", "0116775503"),
("PT822677", "158", "Bella", "Thomas", "Sister", "57, Jalan Chan Sow Lin 22/6, Jertih, Terengganu", "0127206628"),
("PT822677", "159", "Jack", "Thomas", "Brother", "48, Jalan Hang Tuah 37/43, Labuan", "0189182751"),
("PT829829", "160", "Paisley", "Butler", "Mother", "5, Jalan Kia Peng 44/43, Yong Peng, Johor", "01936191096"),
("PT829829", "161", "Caroline", "Parker", "Sister", "5, Jalan Kia Peng 44/43, Yong Peng, Johor", "01995638275"),
("PT829829", "162", "Alexander", "Parker", "Brother", "No. 46, Jalan Raja Muda Musa 20/38, Arau, Perlis", "0170878315"),
("PT254477", "163", "Grayson", "Jackson", "Father", "Lot. 52, Jalan Talalla 8/10, Bukit Tambun, Penang", "01387737883"),
("PT254477", "164", "Allison", "Phillips", "Mother", "Lot. 26, Jalan Maybank 44/17, Taman Senai, Johor", "01529544909"),
("PT254477", "165", "Julian", "Jackson", "Brother", "Lot. 66, Jalan Raja 27/38, Kuala Lumpur", "0119664791"),
("PT784510", "166", "Hazel", "Evans", "Mother", "Lot. 52, Jalan Kia Peng 26/7, Bukit Mertajam, Penang", "0117991576"),
("PT784510", "167", "Luke", "Hall", "Brother", "Lot. 52, Jalan Kia Peng 26/7, Bukit Mertajam, Penang", "01648975588"),
("PT094612", "168", "David", "Bouchard", "Brother", "Lot. 76, Jalan Munshi Abdullah 3/43, Sungai Udang, Malacca", "0159681354"),
("PT197830", "169", "Charlotte", "Taylor", "Sister", "80, Jalan Yaacob Latif 22/43, Sandakan, Sabah", "01970148346"),
("PT197830", "170", "Nova", "Myers", "Spouse", "24, Jalan Maharajalela 15/43, Kluang, Johor", "0101824095"),
("PT876164", "171", "Chloe", "Roberts", "Sister", "No. 69, Jalan Pantai Baharu 49/19, Butterworth, Penang", "0177232223"),
("PT910601", "172", "Benjamin", "Adams", "Father", "4, Jalan Changkat Stadium 27/50, Labuan", "0112388288"),
("PT910601", "173", "Sophia", "Mitchell", "Mother", "Lot. 8, Jalan Stonor 2/4, Jertih, Terengganu", "0197039509"),
("PT638473", "174", "Nora", "Cruz", "Mother", "Lot. 70, Jalan U-Thant 11/26, Jerantut, Pahang", "01650252828"),
("PT965500", "175", "Elizabeth", "Sullivan", "Sister", "80, Jalan Robson 48/25, Jitra, Kedah", "0192291913"),
("PT965500", "176", "Mason", "Sullivan", "Brother", "No. 17, Jalan Esfahan 45/26, Pinang Tunggal, Penang", "0190947016"),
("PT220818", "177", "Jacob", "Green", "Father", "14, Jalan Kampung Bandar Dalam 24/39, Arau, Perlis", "0167822341"),
("PT220818", "178", "Ellie", "Reyes", "Mother", "Lot. 67, Jalan Tangsi 16/9, Kuala Sawah, Negeri Sembilan", "01763399539"),
("PT220818", "179", "Chloe", "Green", "Sister", "No. 30, Jalan Cenderasari 19/44, Kuala Dungun, Terengganu", "01332447129"),
("PT220818", "180", "Joseph", "Green", "Brother", "Lot. 67, Jalan Tangsi 16/9, Kuala Sawah, Negeri Sembilan", "01406489217"),
("PT001717", "181", "Charlotte", "Diaz", "Mother", "No. 16, Jalan Yap Ah Shak 12/24, Kampung Lemal, Kelantan", "0146193169"),
("PT001717", "182", "Serenity", "Williams", "Sister", "1, Jalan Langgak Golf 36/32, Semenyih, Selangor", "0136463457"),
("PT001717", "183", "Isaac", "Thompson", "Spouse", "1, Jalan Langgak Golf 36/32, Semenyih, Selangor", "0106228117"),
("PT372292", "184", "Ethan", "Hill", "Father", "Lot. 36, Jalan Thambipillay 11/6, Kuala Dungun, Terengganu", "0154689752"),
("PT372292", "185", "Gabriella", "Hill", "Sister", "No. 66, Jalan Hang Kasturi 42/33, Kota Tinggi, Johor", "0144950255"),
("PT372292", "186", "Carter", "Hill", "Brother", "35, Jalan Sin Chee 26/4, Batu Kawan, Penang", "01211845483"),
("PT668266", "187", "Elizabeth", "Jackson", "Spouse", "No. 53, Jalan Eaton 5/23, Pokok Sena, Kedah", "01387718846"),
("PT272742", "188", "Chloe", "Morin", "Sister", "Lot. 57, Jalan Abdul Rahim Kajai 34/25, Lumut, Perak", "0196797522"),
("PT272742", "189", "John", "Morin", "Brother", "22, Jalan Abdul Rahim Kajai 13/41, Keningau, Sabah", "01124426596"),
("PT341632", "190", "Ariana", "Rodriguez", "Sister", "Lot. 6, Jalan Bukit Aman 35/36, Kuala Lumpur", "0153194146"),
("PT961975", "191", "Anna", "Bell", "Mother", "Lot. 64, Jalan Cochrane 50/7, Pulai Chondong, Kelantan", "0115576307"),
("PT961975", "192", "Violet", "Sullivan", "Sister", "38, Jalan Sin Chee 15/5, Marang, Terengganu", "01758801030"),
("PT961975", "193", "Jacob", "Sullivan", "Brother", "Lot. 64, Jalan Cochrane 50/7, Pulai Chondong, Kelantan", "0117533402"),
("PT793619", "194", "Maya", "Harris", "Mother", "Lot. 48, Jalan Raja Muda Abdul Aziz 13/28, Marang, Terengganu", "0130910214"),
("PT793619", "195", "Leo", "Morin", "Brother", "54, Jalan Tun Mohd Fuad 28/1, Bukit Tinggi, Pahang", "0112363769"),
("PT793619", "196", "Audrey", "Reyes", "Spouse", "63, Jalan Cenderasari 2/48, Kuala Lumpur", "0167678067"),
("PT968114", "197", "Hannah", "Cook", "Sister", "Lot. 50, Jalan Imbi 20/43, Muar, Johor", "01184592784"),
("PT968114", "198", "Theodore", "Cook", "Brother", "Lot. 50, Jalan Imbi 20/43, Muar, Johor", "01641241965"),
("PT690481", "199", "Mateo", "Williams", "Father", "Lot. 79, Jalan Kia Peng 10/43, Sungai Udang, Malacca", "01192780203"),
("PT690481", "200", "Stella", "Anderson", "Mother", "No. 42, Jalan Datuk Sulaiman 9/7, Simpang Ampat, Malacca", "0178102335"),
("PT690481", "201", "Madelyn", "Williams", "Sister", "Lot. 16, Jalan Sri Amar 46/50, Butterworth, Penang", "0165042982"),
("PT690481", "202", "Alexander", "Williams", "Brother", "66, Jalan Loke Yew 25/48, Tanjung Kling, Malacca", "0115185433"),
("PT191719", "203", "Samantha", "Hernandez", "Mother", "No. 12, Jalan Robertson 6/41, Kuala Lumpur", "0123695835"),
("PT191719", "204", "Aurora", "Côté", "Sister", "No. 56, Jalan Berhala 34/22, Kota Tinggi, Johor", "0173538828"),
("PT681292", "205", "Avery", "Phillips", "Sister", "No. 50, Jalan Raja Chulan 42/45, Yong Peng, Johor", "0150880388"),
("PT681292", "206", "John", "Phillips", "Brother", "Lot. 21, Jalan Bangsar 24/26, Labuan", "01584278616"),
("PT362725", "207", "Samuel", "Brooks", "Father", "Lot. 63, Jalan Talalla 25/21, Kuala Lumpur", "0165415770"),
("PT362725", "208", "Cora", "Johnson", "Mother", "28, Jalan Thambi Dollah 22/10, Marang, Terengganu", "0174239597"),
("PT362725", "209", "Ethan", "Brooks", "Brother", "No. 69, Jalan Stonor 11/26, Mambau, Negeri Sembilan", "0122232319"),
("PT720879", "210", "Logan", "Smith", "Father", "No. 49, Jalan Tun H S Lee 2/44, Kuala Selangor, Selangor", "01080755911"),
("PT720879", "211", "Cora", "Smith", "Sister", "Lot. 26, Jalan Kinabalu (part of) 13/15, Putrajaya", "0144497215"),
("PT720879", "212", "Jacob", "Smith", "Brother", "47, Jalan Wan Kadir 42/6, Labuan", "01342205170"),
("PT287289", "213", "Lucas", "Nelson", "Father", "Lot. 23, Jalan Tuanku Abdul Halim 48/6, Machap Baru, Malacca", "0196938471"),
("PT287289", "214", "Gabriel", "Nelson", "Brother", "Lot. 23, Jalan Tuanku Abdul Halim 48/6, Machap Baru, Malacca", "0169222093"),
("PT709995", "215", "Lily", "Cruz", "Mother", "Lot. 35, Jalan Tun Sambanthan 33/25, Genting Sempah, Pahang", "01793974991"),
("PT709995", "216", "Dylan", "Gutierrez", "Brother", "No. 66, Jalan Leong Yew Koh 22/23, Port Dickson (town), Negeri Sembilan", "0136633460"),
("PT709995", "217", "Dylan", "Cox", "Spouse", "No. 72, Jalan Maharajalela 19/40, Selayang, Selangor", "0146703750"),
("PT217719", "218", "Harper", "Côté", "Mother", "Lot. 70, Jalan Wan Kadir 42/14, Jertih, Terengganu", "01753915222"),
("PT851571", "219", "Lucy", "Morin", "Mother", "Lot. 1, Jalan Yap Kwan Seng 36/45, Semenyih, Selangor", "01755527358"),
("PT851571", "220", "Lillian", "Rodriguez", "Sister", "No. 53, Jalan Pudu Lama 26/21, Kuala Lumpur", "0186429675"),
("PT800759", "221", "Gabriel", "Sullivan", "Father", "62, Jalan U-Thant 37/36, Kuala Lumpur", "01703385484"),
("PT625389", "222", "Hazel", "Gagné", "Sister", "39, Jalan Punchak 34/22, Kuala Kangsar, Perak", "01822837319");
INSERT INTO staff VALUES
("SF719580", "Samuel", "Wood", "50, Jalan Aminuddin Baki 41/33, Kertih, Terengganu", "0187380375", "1957-9-5", "male", "00520627", "Personnel Officer", "7673.12", "SI", null),
("SF690668", "Anna", "Lee", "33, Jalan Burhanuddin Helmi 5/34, Batu Kawan, Penang", "0182675448", "1972-9-30", "female", "75480465", "Personnel Officer", "6303.90", "SI", null),
("SF373568", "Claire", "Green", "57, Jalan Serian 18/42, Kuala Lumpur", "01451299894", "1962-7-29", "female", "48547084", "Personnel Officer", "7590.44", "SI", null),
("SF944426", "Grayson", "King", "2, Jalan Abdul Rahim Kajai 27/19, Labuan", "0118057838", "1953-1-21", "male", "39772294", "Personnel Officer", "7371.94", "SI", null),
("SF080271", "Jackson", "Nguyen", "65, Jalan Berhala 40/34, Putrajaya", "0109205543", "1962-1-25", "male", "03246219", "Personnel Officer", "5187.13", "SI", null),
("SF506355", "Hannah", "Edwards", "71, Jalan Pasar Besar 23/3, Kuala Lumpur", "0192310619", "1955-6-4", "female", "69693994", "Personnel Officer", "8748.92", "SI", null),
("SF117623", "Lucy", "Ortiz", "5, Jalan Raja Chulan 45/49, Merlimau, Malacca", "0123607836", "1955-4-2", "female", "17022691", "Personnel Officer", "5878.52", "SI", null),
("SF261890", "Joseph", "Cruz", "74, Jalan Masjid India 4/33, Donggongon, Sabah", "01851671847", "1962-5-19", "male", "83851041", "Personnel Officer", "8084.06", "SI", null),
("SF945605", "Ariana", "Robinson", "Lot. 61, Jalan Imbi 6/8, Parit Buntar, Perak", "01645725792", "1962-1-9", "female", "17470207", "Personnel Officer", "6283.01", "SI", null),
("SF754913", "Anthony", "Jackson", "Lot. 46, Jalan Gereja 49/47, Kuala Lumpur", "0111176323", "1963-5-13", "male", "61856246", "Personnel Officer", "5447.48", "SI", null),
("SF496399", "Emma", "Rodriguez", "Lot. 9, Jalan Syed Putra 15/38, Sungai Muntoh, Negeri Sembilan", "0134486268", "1956-11-10", "female", "72995383", "Personnel Officer", "8867.97", "SI", null),
("SF870969", "Levi", "Martinez", "7, Jalan Thambi Dollah 26/27, Bandar Labuan, Sabah", "01307569741", "1975-3-3", "male", "28723688", "Personnel Officer", "7327.46", "SI", null),
("SF056845", "Autumn", "Flores", "Lot. 45, Jalan Hang Kasturi 31/40, Putrajaya", "01197583370", "1946-2-25", "female", "09847579", "Personnel Officer", "5875.95", "SI", null),
("SF344737", "Jack", "Sullivan", "Lot. 28, Jalan Raja Muda Abdul Aziz 7/39, Tanjung Karang, Selangor", "0164074226", "1962-8-16", "male", "49832379", "Personnel Officer", "5972.59", "SI", null),
("SF442157", "Wyatt", "Garcia", "No. 39, Jalan Sungai Besi 46/17, Jasin, Malacca", "01856756297", "1965-2-11", "male", "64049288", "Personnel Officer", "5023.38", "SI", null),
("SF656734", "Scarlett", "Sullivan", "No. 43, Jalan Doktor Latif 34/31, Kertih, Terengganu", "0117437981", "1946-11-16", "female", "73965339", "Personnel Officer", "6052.48", "SI", null),
("SF695999", "Brooklyn", "Myers", "No. 42, Jalan Tun Perak 4/15, Kota Belud, Sabah", "01632852616", "1952-3-8", "female", "49466892", "Personnel Officer", "5441.15", "SI", null),
("SF411235", "Gabriel", "Richardson", "Lot. 68, Jalan Belfield 36/30, Ringlet, Pahang", "0135008101", "1950-8-11", "male", "73253916", "Personnel Officer", "7799.39", "SI", null);
INSERT INTO staff VALUES
("SF627758", "Dylan", "Parker", "No. 71, Jalan Dewan Bahasa 49/12, Mambau, Negeri Sembilan", "0156081279", "1944-9-1", "male", "16465651", "Doctor of Obstetrics and gynecology", "5868.80", "SI", "SF261890"),
("SF857746", "Mateo", "Richardson", "Lot. 6, Jalan Punchak 12/33, Kangar, Perlis", "0197474148", "1980-7-16", "male", "46489119", "Doctor of Psychiatry", "8333.92", "SI", "SF261890"),
("SF755291", "Dylan", "Thompson", "No. 77, Jalan Munshi Abdullah 5/15, Putrajaya", "01076016836", "1971-1-19", "male", "85515450", "Doctor of Radiation oncology", "7025.77", "SI", "SF056845"),
("SF337578", "Levi", "Robinson", "No. 27, Jalan Walter Grenier 46/19, Teluk Air Tawar, Penang", "0138494650", "1942-4-28", "male", "70032895", "Doctor of Neurology", "5073.53", "SI", "SF944426"),
("SF120109", "Elijah", "Reed", "Lot. 66, Jalan Galloway 29/41, Alor Gajah, Malacca", "0178402986", "1940-6-10", "male", "12410953", "Senior Nurse", "5587.68", "SI", "SF506355"),
("SF515337", "Amelia", "Nguyen", "No. 20, Jalan Athinahapan 43/4, Kuala Perlis, Perlis", "01343852365", "1954-4-9", "female", "25864952", "Senior Nurse", "8848.54", "SI", "SF870969"),
("SF331054", "Harper", "Evans", "No. 5, Jalan Kinabalu (part of) 21/9, Val d'Or, Penang, Penang", "01348651996", "1980-6-8", "female", "40563521", "Medical Director", "8157.18", "SI", "SF656734"),
("SF023492", "Anna", "Russell", "No. 77, Jalan Mahkamah Persekutuan 45/26, Labuan", "0164504256", "1943-2-25", "female", "65937374", "Junior Nurse", "3208.32", "SL", "SF690668"),
("SF676888", "Jayden", "Cox", "Lot. 14, Jalan Robson 42/13, Durian Tunggal, Malacca", "0105149338", "1960-4-14", "male", "02155417", "Doctor of Pediatrics", "7778.81", "SI", "SF411235"),
("SF855007", "Bella", "Roberts", "Lot. 10, Jalan Tun Ismail 14/3, Machap Baru, Malacca", "01679813413", "1960-5-17", "female", "05699449", "Medical Director", "5049.19", "SI", "SF870969"),
("SF383676", "Jack", "Myers", "11, Jalan Dewan Bahasa 28/30, Tanjung Karang, Selangor", "0150654154", "1975-3-30", "male", "82863686", "Senior Nurse", "8892.52", "SI", "SF442157"),
("SF193356", "Aiden", "Peterson", "78, Jalan Tun Razak 40/30, Simpang Empat, Perak", "01067053934", "1952-6-3", "male", "99968663", "Doctor of Psychiatry", "8633.60", "SI", "SF945605"),
("SF630902", "Madison", "Walker", "No. 77, Jalan Dewan Bahasa 5/14, Beserah, Pahang", "01483913366", "1944-11-19", "female", "57499892", "Senior Nurse", "5996.89", "SI", "SF690668"),
("SF546749", "Madison", "Rodriguez", "12, Jalan Thavers 11/37, Nibong Tebal, Penang", "01610556955", "1958-8-23", "female", "44408475", "Senior Nurse", "8667.10", "SI", "SF411235"),
("SF547640", "Jacob", "Diaz", "34, Jalan Bukit Ceylon 37/7, Kuala Selangor, Selangor", "0137777918", "1978-8-3", "male", "78458859", "Medical Director", "6685.68", "SI", "SF411235"),
("SF487606", "Brooklyn", "Perry", "No. 40, Jalan Hang Lekiu 27/20, Ulu Tiram, Johor", "01802546365", "1945-10-25", "female", "15956951", "Senior Nurse", "7474.11", "SI", "SF056845"),
("SF401383", "Joseph", "Moore", "Lot. 47, Jalan Bukit Bintang 13/42, Kangar, Perlis", "01179561160", "1945-3-2", "male", "24936007", "Junior Nurse", "4178.98", "SL", "SF344737"),
("SF762927", "Elijah", "Thompson", "Lot. 57, Jalan Stadium 27/2, Kulim, Kedah", "01154947598", "1952-7-28", "male", "71181926", "Doctor of Obstetrics and gynecology", "6273.82", "SI", "SF719580"),
("SF783448", "Caroline", "Perez", "No. 32, Jalan Maharajalela 34/33, Tumpat, Kelantan", "01578401014", "1975-2-21", "female", "34439021", "Doctor of Radiation oncology", "7375.80", "SI", "SF870969"),
("SF659008", "Alexander", "Wright", "Lot. 48, Jalan Chow Kit 18/37, Taman Senai, Johor", "0161113774", "1974-10-19", "male", "38712195", "Junior Nurse", "3768.01", "SL", "SF056845"),
("SF981284", "Samuel", "Adams", "No. 4, Jalan Loke Yew 47/42, Kuala Terengganu, Terengganu", "01491955727", "1952-2-9", "male", "53438543", "Senior Nurse", "6345.25", "SI", "SF944426"),
("SF569446", "Hailey", "Lopez", "1, Jalan Raja Alang 21/29, Serendah, Selangor", "01085850959", "1945-2-24", "female", "42288023", "Doctor of Ophthalmology", "8823.43", "SI", "SF411235"),
("SF695361", "Isaac", "Hall", "No. 28, Jalan Pasar Besar 24/43, Miri, Sarawak", "01094727714", "1971-4-14", "male", "46544995", "Junior Nurse", "3964.23", "SL", "SF944426"),
("SF939987", "Jayden", "Wilson", "79, Jalan Athinahapan 30/6, Labuan", "0132935455", "1978-11-13", "male", "02118323", "Senior Nurse", "5360.89", "SI", "SF117623"),
("SF678145", "Sarah", "Long", "Lot. 10, Jalan Raja Chulan 16/15, Ketereh, Kelantan", "01759078906", "1969-12-28", "female", "13096386", "Doctor of Radiation oncology", "6348.09", "SI", "SF373568"),
("SF597429", "Daniel", "Diaz", "76, Jalan Masjid India 5/50, Labuan", "01876471840", "1973-3-21", "male", "53819617", "Medical Director", "8841.07", "SI", "SF754913"),
("SF638678", "Lucas", "Perez", "42, Jalan Kuda 2/16, Kota Bharu, Kelantan", "0103970077", "1942-12-23", "male", "40339733", "Junior Nurse", "4825.45", "SL", "SF056845"),
("SF143989", "Alexander", "Côté", "Lot. 64, Jalan Doktor Latif 21/10, Bakri, Johor", "01816686705", "1949-5-19", "male", "12622773", "Doctor of Neurology", "8874.06", "SI", "SF117623"),
("SF316487", "Grayson", "Bouchard", "43, Jalan Thambipillay 16/34, Beaufort, Sabah", "0173277366", "1978-3-5", "male", "95115612", "Senior Nurse", "5716.43", "SI", "SF373568"),
("SF271612", "Isaac", "Jackson", "Lot. 34, Jalan Raja Chulan 30/37, Sri Aman, Sarawak", "0156662793", "1978-1-15", "male", "34951717", "Doctor of Obstetrics and gynecology", "7844.41", "SI", "SF506355"),
("SF216324", "Owen", "Sanders", "13, Jalan Burhanuddin Helmi 40/47, Bandar Muadzam Shah, Pahang", "0107381802", "1949-1-15", "male", "94572682", "Senior Nurse", "6226.76", "SI", "SF411235"),
("SF103585", "James", "Ward", "Lot. 49, Jalan Ampang 21/42, Kampar, Perak", "0180792729", "1942-11-14", "male", "58070744", "Junior Nurse", "3816.93", "SL", "SF080271"),
("SF072000", "Eleanor", "Roy", "No. 67, Jalan Sin Chew Kee 10/38, Kuala Dungun, Terengganu", "0172429307", "1945-11-6", "female", "05710670", "Junior Nurse", "3798.36", "SL", "SF080271"),
("SF776060", "Amelia", "Perez", "Lot. 57, Jalan Eaton 19/36, Batang Benar, Negeri Sembilan", "0195983046", "1967-12-13", "female", "31464752", "Doctor of Ophthalmology", "5914.08", "SI", "SF695999"),
("SF213172", "Isaac", "Long", "Lot. 26, Jalan Robertson 15/42, Belimbing, Pahang", "01122972598", "1966-8-30", "male", "47035362", "Doctor of Dermatology", "6807.95", "SI", "SF080271"),
("SF528378", "Leo", "Flores", "Lot. 15, Jalan Kebun Bunga 49/15, Naning, Malacca", "01392609518", "1978-10-16", "male", "68411763", "Doctor of Internal medicine", "8374.78", "SI", "SF080271"),
("SF628748", "Lucas", "Murphy", "Lot. 1, Jalan Dewan Bahasa 16/29, Arau, Perlis", "01895881885", "1976-10-6", "male", "10172213", "Doctor of Psychiatry", "7812.08", "SI", "SF117623"),
("SF457445", "Matthew", "Martinez", "58, Jalan Pahang 42/3, Putrajaya", "0195101902", "1964-3-13", "male", "54218835", "Senior Nurse", "7929.34", "SI", "SF944426"),
("SF131941", "Ruby", "Cook", "Lot. 69, Jalan Eaton 33/50, Teluk Kumbar, Penang", "0108310936", "1973-8-22", "female", "58507474", "Senior Nurse", "7639.32", "SI", "SF870969"),
("SF284751", "Alexander", "Edwards", "No. 41, Jalan Syed Putra 7/46, Miri, Sarawak", "0117290514", "1965-3-3", "male", "61747048", "Senior Nurse", "7181.55", "SI", "SF690668"),
("SF067549", "Harper", "Phillips", "No. 61, Jalan Pantai Baharu 6/27, Putrajaya", "0183268382", "1970-8-11", "female", "23999622", "Medical Director", "5994.31", "SI", "SF690668"),
("SF446458", "Violet", "King", "Lot. 45, Jalan Dewan Bahasa 26/9, Kluang, Johor", "01769553075", "1944-7-16", "female", "59316807", "Medical Director", "6655.72", "SI", "SF344737"),
("SF048623", "Abigail", "Reyes", "Lot. 22, Jalan Kuching 39/28, Penanti, Penang", "01764894981", "1947-6-25", "female", "70354874", "Doctor of Neurology", "7137.91", "SI", "SF944426"),
("SF675228", "Ethan", "Johnson", "23, Jalan Yaacob Latif 1/41, Pokok Sena, Kedah", "0165085480", "1952-12-24", "male", "58719255", "Doctor of Radiation oncology", "7499.99", "SI", "SF117623"),
("SF828986", "Oliver", "Carter", "32, Jalan Ampang 50/8, Tanah Merah, Kelantan", "0105168481", "1961-4-8", "male", "53667761", "Doctor of Radiation oncology", "6740.90", "SI", "SF506355"),
("SF898310", "Camila", "Adams", "70, Jalan Tun Tan Siew Sin 38/28, Kuala Lumpur", "01937826349", "1945-4-15", "female", "87801169", "Doctor of Neurology", "5286.28", "SI", "SF754913"),
("SF002786", "Jack", "Reed", "No. 11, Jalan Haji Yahya Sheikh Ahmad 38/12, Labuan", "0193551132", "1975-3-7", "male", "77407467", "Doctor of Radiation oncology", "8709.37", "SI", "SF411235"),
("SF366323", "Jack", "Bell", "No. 26, Jalan Burhanuddin Helmi 3/34, Batu Kikir, Negeri Sembilan", "0156941336", "1942-8-4", "male", "14879001", "Doctor of Psychiatry", "8405.15", "SI", "SF496399"),
("SF229821", "Genesis", "Scott", "52, Jalan Raja Chulan 12/27, Papar, Sabah", "01641413027", "1946-5-5", "female", "62336346", "Senior Nurse", "5296.34", "SI", "SF411235"),
("SF693364", "Scarlett", "Cruz", "No. 33, Jalan Yap Tai Chi 31/33, Simanggang, Sarawak", "0134023928", "1949-9-22", "female", "20018495", "Doctor of Radiation oncology", "5550.57", "SI", "SF754913"),
("SF464318", "Matthew", "Gagnon", "53, Jalan Pudu 5/28, Kulim, Kedah", "01840605606", "1977-12-15", "male", "54860768", "Doctor of Dermatology", "7122.20", "SI", "SF754913"),
("SF782869", "Mateo", "Peterson", "No. 32, Jalan Kinabalu (part of) 45/31, Sungai Gadut, Negeri Sembilan", "0176535712", "1973-12-29", "male", "41082769", "Senior Nurse", "7464.26", "SI", "SF411235"),
("SF054397", "Natalie", "Scott", "76, Jalan Pudu Lama 30/18, Sekudai, Johor", "0160393224", "1952-8-4", "female", "10205918", "Senior Nurse", "8633.96", "SI", "SF719580"),
("SF943500", "Elijah", "Sanchez", "Lot. 6, Jalan Faraday 24/3, Kuala Dungun, Terengganu", "01416689187", "1943-3-10", "male", "89310939", "Senior Nurse", "7448.47", "SI", "SF344737"),
("SF392042", "Zoe", "Mitchell", "Lot. 12, Jalan Balai Polis 20/44, Kampar, Perak", "01361651399", "1946-4-11", "female", "04149173", "Senior Nurse", "8387.68", "SI", "SF496399"),
("SF028649", "Aubrey", "Myers", "Lot. 45, Jalan MARA 32/26, Kangar, Perlis", "0177911556", "1944-2-7", "female", "62589441", "Doctor of Psychiatry", "5501.09", "SI", "SF945605"),
("SF530975", "Camila", "Long", "No. 41, Jalan Balai Polis 46/11, Kuala Lumpur", "0160219131", "1980-10-10", "female", "01684356", "Senior Nurse", "5752.47", "SI", "SF056845"),
("SF655037", "Wyatt", "Williams", "Lot. 40, Jalan Ceylon 49/20, Putrajaya", "0174465736", "1974-10-6", "male", "90680195", "Medical Director", "5547.92", "SI", "SF080271"),
("SF267361", "Victoria", "Parker", "26, Jalan Eaton 16/33, Parit Raja, Johor", "01759796924", "1972-11-16", "female", "10622575", "Junior Nurse", "3634.74", "SL", "SF373568"),
("SF153583", "Carter", "Fisher", "Lot. 5, Jalan Bukit Bintang 8/17, Putrajaya", "0157270426", "1968-7-18", "male", "35870864", "Doctor of Dermatology", "6359.19", "SI", "SF344737"),
("SF401559", "Julian", "Collins", "Lot. 3, Jalan Mahkamah Persekutuan 11/11, Arau, Perlis", "01930151335", "1972-4-21", "male", "06595355", "Doctor of Obstetrics and gynecology", "6678.20", "SI", "SF117623"),
("SF456611", "Addison", "Watson", "No. 17, Jalan Wesley 14/15, Kangar, Perlis", "01928058508", "1940-9-16", "female", "28194799", "Junior Nurse", "3910.99", "SL", "SF944426"),
("SF266671", "Ava", "Jackson", "43, Jalan Yew 36/18, Sri Aman, Sarawak", "01114019119", "1969-7-4", "female", "28347003", "Doctor of Pediatrics", "7762.01", "SI", "SF944426"),
("SF562345", "Mia", "Sullivan", "Lot. 34, Jalan Imbi 18/38, Miri, Sarawak", "01108597132", "1971-8-5", "female", "99033607", "Medical Director", "5676.37", "SI", "SF690668"),
("SF340758", "Jacob", "Rogers", "No. 30, Jalan Thambipillay 20/44, Petaling Jaya, Selangor", "0193315412", "1980-4-13", "male", "83400678", "Senior Nurse", "8367.24", "SI", "SF261890"),
("SF075711", "Isla", "Gomez", "No. 7, Jalan Perdana 5/41, Pokok Sena, Kedah", "0149338541", "1941-1-10", "female", "17380782", "Junior Nurse", "3629.71", "SL", "SF344737"),
("SF590220", "Aiden", "White", "Lot. 53, Jalan Chow Kit 47/39, Simpang Empat, Perak", "0190837187", "1970-8-17", "male", "79215921", "Doctor of Obstetrics and gynecology", "6898.00", "SI", "SF945605"),
("SF260230", "Carter", "Robinson", "64, Jalan Samarahan 47/33, Ketereh, Kelantan", "0197521373", "1964-2-24", "male", "85373107", "Doctor of Radiation oncology", "8818.52", "SI", "SF080271"),
("SF654621", "Sebastian", "Green", "Lot. 68, Jalan Tuanku Jaafar 34/31, Labuan", "0184860929", "1970-6-17", "male", "35517545", "Senior Nurse", "8179.84", "SI", "SF870969"),
("SF796164", "Lucy", "Lavoie", "Lot. 47, Jalan Pasar Besar 7/5, Jitra, Kedah", "01165964902", "1964-7-15", "female", "87947497", "Junior Nurse", "3599.89", "SL", "SF496399"),
("SF862092", "Samuel", "Thompson", "No. 64, Jalan Raja Chulan 2/32, Sarikei, Sarawak", "0148722362", "1940-8-8", "male", "99095654", "Doctor of Dermatology", "8515.78", "SI", "SF411235"),
("SF849370", "Aaliyah", "Sullivan", "66, Jalan Aminuddin Baki 28/23, Tanah Merah, Kelantan", "01870418055", "1949-1-2", "female", "52795775", "Senior Nurse", "8294.29", "SI", "SF870969"),
("SF376708", "Skylar", "Sullivan", "79, Jalan Davis 24/49, Kuah, Kedah", "0155157003", "1960-12-2", "female", "98831616", "Medical Director", "7753.41", "SI", "SF754913"),
("SF038312", "Madison", "Gutierrez", "No. 64, Jalan U-Thant 37/8, Buloh Kasap, Johor", "0122044239", "1955-9-29", "female", "55451434", "Senior Nurse", "7899.28", "SI", "SF117623"),
("SF333071", "Kinsley", "Roy", "Lot. 50, Jalan Sultan Ismail 44/13, Kuala Lumpur", "01068635147", "1961-10-7", "female", "19493184", "Senior Nurse", "6498.85", "SI", "SF656734"),
("SF006280", "John", "Green", "56, Jalan Aminuddin Baki 24/50, Parit Buntar, Perak", "0127826758", "1973-1-7", "male", "99353546", "Doctor of Radiation oncology", "7295.66", "SI", "SF056845"),
("SF831911", "Oliver", "Walker", "Lot. 23, Jalan Choo Cheeng Kay 39/23, Subang Jaya, Selangor", "0169334604", "1948-6-25", "male", "06417555", "Medical Director", "5301.42", "SI", "SF506355"),
("SF423758", "Grayson", "Powell", "Lot. 58, Jalan Zaaba 15/22, Bandar Seri Jempol, Negeri Sembilan", "0128443418", "1979-12-15", "male", "15707582", "Senior Nurse", "7026.28", "SI", "SF117623"),
("SF546599", "Skylar", "James", "No. 58, Jalan Hamid Ismail 28/38, Brinchang, Pahang", "01483597703", "1978-11-21", "female", "74414587", "Doctor of Pediatrics", "6106.05", "SI", "SF944426"),
("SF660429", "Lucas", "Roberts", "30, Jalan Berhala 21/45, Putrajaya", "01551470542", "1965-2-12", "male", "97893462", "Medical Director", "7496.12", "SI", "SF506355"),
("SF752059", "Allison", "Fisher", "No. 28, Jalan Bangsar 39/12, Naning, Malacca", "0117788287", "1952-10-18", "female", "32350098", "Doctor of Dermatology", "8957.89", "SI", "SF261890"),
("SF007459", "Natalie", "Allen", "19, Jalan Madge 26/23, Kangar, Perlis", "0139092941", "1952-10-28", "female", "53472383", "Junior Nurse", "3917.35", "SL", "SF056845");
INSERT INTO working_exp VALUES
("SF627758", "1999-3-10", "Kuala Lumpur Hospital", "Personnel Officer", "728364"),
("SF627758", "1991-2-11", "University Malaya Specialist Centre (UMSC)", "Junior Nurse", "726908"),
("SF857746", "2008-1-21", "Hospital Selayang", "Doctor of Pediatrics", "730912"),
("SF755291", "1997-10-22", "Hospital Jengka", "Medical Director", "727272"),
("SF755291", "2001-2-23", "Hospital Lahad Datu", "Junior Nurse", "730548"),
("SF337578", "1969-3-26", "Hospital Selayang", "Doctor of Dermatology", "718172"),
("SF337578", "1996-2-20", "Hospital Rembau", "Doctor of Internal medicine", "728000"),
("SF337578", "1970-1-7", "University Malaya Specialist Centre (UMSC)", "Doctor of Neurology", "726544"),
("SF120109", "1966-11-27", "Hospital Semporna", "Personnel Officer", "717080"),
("SF515337", "1986-10-22", "University Malaya Medical Centre", "Senior Nurse", "725452"),
("SF515337", "1991-10-20", "Hospital Sipitang", "Doctor of Psychiatry", "727636"),
("SF515337", "2003-8-25", "Hospital Jengka", "Doctor of Internal medicine", "730184"),
("SF331054", "2010-1-26", "Hospital Ranau", "Personnel Officer", "732368"),
("SF331054", "2008-4-4", "Hospital Angkatan Tentera Tuanku Mizan", "Doctor of Internal medicine", "732368"),
("SF023492", "1990-9-23", "Hospital Jengka", "Senior Nurse", "724360"),
("SF719580", "1990-1-19", "Hospital Ranau", "Personnel Officer", "725088"),
("SF676888", "1986-10-26", "Hospital Jelebu", "Junior Nurse", "723632"),
("SF855007", "1986-5-19", "Hospital Papar", "Doctor of Neurology", "722904"),
("SF855007", "1986-10-15", "Hospital Lahad Datu", "Medical Director", "723268"),
("SF690668", "1999-8-17", "Hospital Rehabilitasi Cheras", "Personnel Officer", "727636"),
("SF690668", "2000-7-8", "University Malaya Medical Centre", "Medical Director", "728000"),
("SF193356", "1982-11-24", "Hospital Port Dickson", "Doctor of Dermatology", "722176"),
("SF193356", "1992-11-4", "Hospital Kajang", "Doctor of Neurology", "725452"),
("SF630902", "1972-12-1", "Hospital Kuala Penyu", "Medical Director", "719264"),
("SF546749", "1997-4-7", "Hospital Ranau", "Doctor of Dermatology", "728364"),
("SF546749", "1990-10-19", "Hospital Lahad Datu", "Junior Nurse", "728364"),
("SF546749", "1995-1-6", "Hospital Jempol", "Junior Nurse", "728364"),
("SF547640", "2004-4-4", "Hospital Port Dickson", "Senior Nurse", "729456"),
("SF487606", "1984-11-5", "Hospital Tanjung Karang", "Personnel Officer", "722176"),
("SF487606", "1974-7-19", "Hospital Sungai Buloh", "Senior Nurse", "718536"),
("SF401383", "1975-9-1", "Hospital Jempol", "Senior Nurse", "718900"),
("SF373568", "1989-3-5", "Hospital Sungai Buloh", "Personnel Officer", "729092"),
("SF659008", "2000-11-28", "University Malaya Specialist Centre (UMSC)", "Senior Nurse", "728000"),
("SF981284", "1994-12-22", "Hospital Ranau", "Doctor of Psychiatry", "726180"),
("SF981284", "1987-12-28", "Hospital Jelebu", "Doctor of Obstetrics and gynecology", "723268"),
("SF981284", "1985-12-4", "Hospital Jelebu", "Doctor of Radiation oncology", "723996"),
("SF569446", "1979-9-19", "Hospital Kudat", "Junior Nurse", "720356"),
("SF569446", "1974-3-18", "Hospital Sungai Buloh", "Personnel Officer", "718536"),
("SF695361", "1999-6-12", "University Malaya Medical Centre", "Junior Nurse", "728364"),
("SF695361", "1996-7-14", "Hospital Tampin", "Personnel Officer", "729456"),
("SF944426", "1982-7-19", "Hospital Papar", "Doctor of Neurology", "721448"),
("SF939987", "2009-8-15", "Hospital Sungai Buloh", "Personnel Officer", "731640"),
("SF939987", "2009-2-25", "Hospital Rehabilitasi Cheras", "Medical Director", "732004"),
("SF939987", "2007-8-17", "Kuala Lumpur Hospital", "Senior Nurse", "731640"),
("SF678145", "1995-2-3", "Hospital Ranau", "Senior Nurse", "726180"),
("SF597429", "2003-1-20", "Hospital Kuala Kubu Baru", "Senior Nurse", "729456"),
("SF597429", "2004-6-6", "Hospital Kuala Kubu Baru", "Personnel Officer", "729456"),
("SF638678", "1970-1-19", "Hospital Papar", "Doctor of Obstetrics and gynecology", "717080"),
("SF638678", "1968-6-15", "Hospital Port Dickson", "Senior Nurse", "716716"),
("SF143989", "1992-12-29", "Hospital Selayang", "Doctor of Dermatology", "725816"),
("SF143989", "1982-11-28", "University Malaya Specialist Centre (UMSC)", "Senior Nurse", "722904"),
("SF316487", "2007-4-2", "Hospital Ranau", "Junior Nurse", "730548"),
("SF316487", "2008-2-10", "Hospital Lahad Datu", "Senior Nurse", "730912"),
("SF080271", "1989-12-19", "Universiti Kebangsaan Malaysia Medical Centre (PPUKM)", "Doctor of Dermatology", "723996"),
("SF080271", "1987-11-11", "Hospital Jengka", "Doctor of Radiation oncology", "723268"),
("SF506355", "1998-8-5", "Hospital Ranau", "Personnel Officer", "732004"),
("SF216324", "1984-3-22", "Hospital Cameron Highlands", "Junior Nurse", "722540"),
("SF103585", "1988-8-19", "Hospital Jempol", "Doctor of Dermatology", "726908"),
("SF117623", "1981-8-11", "Hospital Tanjung Karang", "Doctor of Internal medicine", "721812"),
("SF117623", "1984-9-6", "Hospital Semporna", "Doctor of Neurology", "722176"),
("SF117623", "1983-3-6", "Hospital Tampin", "Junior Nurse", "721812"),
("SF072000", "1973-1-15", "Hospital Cameron Highlands", "Doctor of Obstetrics and gynecology", "719992"),
("SF776060", "2009-7-15", "Hospital Kajang", "Senior Nurse", "731276"),
("SF213172", "1996-8-8", "Hospital Semporna", "Medical Director", "726908"),
("SF213172", "1992-7-9", "Hospital Jengka", "Personnel Officer", "725088"),
("SF528378", "2006-7-11", "University Malaya Specialist Centre (UMSC)", "Medical Director", "731640"),
("SF457445", "1990-10-22", "Hospital Rembau", "Senior Nurse", "724360"),
("SF457445", "1990-7-30", "Hospital Tampin", "Medical Director", "724724"),
("SF131941", "2001-4-3", "Hospital Kudat", "Doctor of Internal medicine", "732368"),
("SF131941", "2005-12-24", "Hospital Rembau", "Personnel Officer", "729820"),
("SF131941", "2010-7-19", "University Malaya Specialist Centre (UMSC)", "Doctor of Ophthalmology", "732368"),
("SF067549", "1996-2-23", "Kuala Lumpur Hospital", "Personnel Officer", "727272"),
("SF446458", "1984-9-9", "Hospital Muadzam Shah", "Senior Nurse", "722176"),
("SF048623", "1997-7-3", "Hospital Tampin", "Junior Nurse", "728364"),
("SF675228", "1979-1-2", "Hospital Kudat", "Junior Nurse", "720356"),
("SF675228", "1978-2-11", "Hospital Sultan Haji Ahmad Shah, Temerloh", "Doctor of Obstetrics and gynecology", "719992"),
("SF828986", "1999-6-3", "Kuala Lumpur Hospital", "Senior Nurse", "728000"),
("SF898310", "1974-2-27", "Hospital Ranau", "Senior Nurse", "723268"),
("SF898310", "1985-10-3", "Hospital Rembau", "Medical Director", "729820"),
("SF898310", "1993-4-15", "Hospital Kudat", "Junior Nurse", "728364"),
("SF261890", "1990-12-1", "Hospital Ranau", "Doctor of Psychiatry", "725088"),
("SF261890", "1988-4-27", "Hospital Sipitang", "Doctor of Pediatrics", "725452"),
("SF261890", "1992-2-1", "Kuala Lumpur Hospital", "Personnel Officer", "726180"),
("SF366323", "1971-4-11", "University Malaya Medical Centre", "Senior Nurse", "717444"),
("SF229821", "1971-1-2", "Hospital Port Dickson", "Junior Nurse", "718900"),
("SF229821", "1976-3-10", "Hospital Semporna", "Doctor of Radiation oncology", "720720"),
("SF693364", "1989-7-7", "Hospital Mesra Bukit Padang", "Medical Director", "724724"),
("SF693364", "1979-2-20", "Hospital Sipitang", "Doctor of Psychiatry", "723632"),
("SF464318", "2005-5-2", "University Malaya Medical Centre", "Personnel Officer", "730912"),
("SF464318", "2004-2-13", "Hospital Rehabilitasi Cheras", "Personnel Officer", "729456"),
("SF054397", "1983-8-7", "Hospital Kudat", "Medical Director", "722904"),
("SF943500", "1975-11-11", "Hospital Kajang", "Senior Nurse", "719628"),
("SF392042", "1978-12-13", "Hospital Port Dickson", "Senior Nurse", "719992"),
("SF392042", "1975-7-27", "Universiti Kebangsaan Malaysia Medical Centre (PPUKM)", "Doctor of Dermatology", "719264"),
("SF392042", "1972-10-3", "Hospital Kuala Kubu Baru", "Junior Nurse", "719264"),
("SF028649", "1984-4-15", "University Malaya Medical Centre", "Senior Nurse", "722176"),
("SF530975", "2005-2-9", "Hospital Sungai Buloh", "Medical Director", "729820"),
("SF267361", "1999-4-2", "Universiti Kebangsaan Malaysia Medical Centre (PPUKM)", "Senior Nurse", "727636"),
("SF945605", "1989-9-4", "Hospital Semporna", "Junior Nurse", "724360"),
("SF945605", "1988-4-5", "Hospital Ranau", "Personnel Officer", "723632"),
("SF401559", "2002-10-24", "Hospital Sultan Haji Ahmad Shah, Temerloh", "Medical Director", "730548"),
("SF456611", "1982-5-23", "Hospital Sipitang", "Personnel Officer", "725452"),
("SF456611", "2008-10-25", "Hospital Rehabilitasi Cheras", "Personnel Officer", "730912"),
("SF754913", "2001-7-19", "Hospital Tampin", "Senior Nurse", "729820"),
("SF562345", "2005-10-29", "Hospital Semporna", "Senior Nurse", "730548"),
("SF075711", "1967-5-9", "Kuala Lumpur Hospital", "Medical Director", "717080"),
("SF496399", "1981-10-29", "Hospital Kajang", "Senior Nurse", "722540"),
("SF496399", "1990-6-14", "University Malaya Specialist Centre (UMSC)", "Senior Nurse", "724360"),
("SF260230", "1993-11-15", "Universiti Kebangsaan Malaysia Medical Centre (PPUKM)", "Personnel Officer", "726908"),
("SF260230", "1994-3-16", "Hospital Muadzam Shah", "Senior Nurse", "727272"),
("SF870969", "2004-5-20", "Hospital Port Dickson", "Medical Director", "729820"),
("SF654621", "1997-6-3", "Hospital Rehabilitasi Cheras", "Personnel Officer", "727636"),
("SF654621", "1998-5-3", "Hospital Kuala Kubu Baru", "Senior Nurse", "727636"),
("SF796164", "2005-9-9", "Hospital Jelebu", "Medical Director", "730548"),
("SF796164", "2002-9-19", "Hospital Jelebu", "Senior Nurse", "729456"),
("SF862092", "1965-8-13", "University Malaya Medical Centre", "Doctor of Dermatology", "716352"),
("SF862092", "1970-4-8", "Hospital Papar", "Medical Director", "717080"),
("SF849370", "1980-8-19", "University Malaya Medical Centre", "Junior Nurse", "729820"),
("SF376708", "1993-6-28", "Hospital Kajang", "Doctor of Neurology", "725816"),
("SF056845", "1983-11-1", "Hospital Selayang", "Doctor of Pediatrics", "725088"),
("SF056845", "1977-1-20", "Hospital Tampin", "Junior Nurse", "723996"),
("SF344737", "1997-11-4", "University Malaya Specialist Centre (UMSC)", "Personnel Officer", "727272"),
("SF344737", "1998-1-23", "Hospital Ranau", "Doctor of Ophthalmology", "727272"),
("SF038312", "1991-4-24", "Hospital Kudat", "Personnel Officer", "728728"),
("SF038312", "1990-2-6", "Hospital Kajang", "Personnel Officer", "728000"),
("SF333071", "1986-8-6", "Hospital Tanjung Karang", "Personnel Officer", "723632"),
("SF333071", "1987-1-2", "Hospital Kudat", "Doctor of Dermatology", "723996"),
("SF333071", "1988-6-28", "Hospital Ranau", "Junior Nurse", "723632"),
("SF442157", "1994-6-30", "Hospital Kudat", "Doctor of Ophthalmology", "726544"),
("SF442157", "1993-12-20", "Hospital Semporna", "Medical Director", "726180"),
("SF442157", "1995-11-4", "Universiti Kebangsaan Malaysia Medical Centre (PPUKM)", "Senior Nurse", "726544"),
("SF656734", "1988-1-25", "Hospital Jengka", "Doctor of Obstetrics and gynecology", "725816"),
("SF656734", "1985-7-18", "Hospital Ranau", "Medical Director", "729092"),
("SF831911", "1973-6-2", "Hospital Cameron Highlands", "Personnel Officer", "719992"),
("SF695999", "1991-2-14", "Hospital Cameron Highlands", "Doctor of Pediatrics", "726908"),
("SF411235", "1979-8-10", "Hospital Sipitang", "Doctor of Dermatology", "722904"),
("SF411235", "1987-3-8", "Hospital Rembau", "Personnel Officer", "723268"),
("SF546599", "2005-6-23", "Hospital Mesra Bukit Padang", "Doctor of Internal medicine", "730184"),
("SF546599", "2003-4-22", "Hospital Serdang", "Doctor of Internal medicine", "729820"),
("SF546599", "2005-12-7", "University Malaya Specialist Centre (UMSC)", "Doctor of Obstetrics and gynecology", "730184"),
("SF660429", "1990-1-9", "Hospital Rehabilitasi Cheras", "Doctor of Ophthalmology", "724724"),
("SF660429", "1990-5-18", "Hospital Semporna", "Personnel Officer", "724724"),
("SF660429", "1991-8-10", "Hospital Rembau", "Doctor of Obstetrics and gynecology", "724724"),
("SF752059", "1985-12-2", "Hospital Jempol", "Senior Nurse", "722540"),
("SF752059", "1978-2-22", "Hospital Rembau", "Medical Director", "720720"),
("SF752059", "1979-10-28", "Hospital Serdang", "Medical Director", "722176"),
("SF007459", "1978-11-17", "Hospital Rehabilitasi Cheras", "Junior Nurse", "720356"),
("SF007459", "1983-1-5", "Hospital Papar", "Medical Director", "723632");
INSERT INTO staff_short_term VALUES
("SF857746", "2009-8-8", "62"),
("SF515337", "2007-1-15", "66"),
("SF331054", "2015-9-2", "52"),
("SF023492", "2006-10-7", "85"),
("SF719580", "1996-1-30", "84"),
("SF690668", "2001-9-1", "72"),
("SF193356", "1997-4-26", "35"),
("SF630902", "2010-10-5", "77"),
("SF547640", "2005-10-14", "99"),
("SF401383", "1977-2-10", "37"),
("SF373568", "2014-7-9", "37"),
("SF783448", "2000-3-22", "33"),
("SF981284", "1996-3-4", "58"),
("SF695361", "2011-12-12", "38"),
("SF944426", "1987-7-11", "68"),
("SF939987", "2013-2-10", "53"),
("SF597429", "2005-11-14", "80"),
("SF638678", "1971-7-2", "86"),
("SF143989", "2010-1-13", "75"),
("SF506355", "2015-5-26", "77"),
("SF271612", "2006-7-11", "61"),
("SF117623", "1985-9-22", "35"),
("SF776060", "2014-8-19", "80"),
("SF528378", "2011-7-1", "74"),
("SF284751", "1991-4-10", "99"),
("SF067549", "2001-6-12", "37"),
("SF048623", "2008-2-21", "87"),
("SF828986", "2005-11-18", "79"),
("SF898310", "2011-12-21", "72"),
("SF002786", "2013-4-5", "39"),
("SF366323", "1974-4-23", "100"),
("SF229821", "1985-12-18", "86"),
("SF693364", "2009-3-10", "71"),
("SF782869", "2002-2-26", "60"),
("SF054397", "1987-8-26", "69"),
("SF392042", "1979-7-20", "36"),
("SF028649", "1985-12-27", "84"),
("SF267361", "2001-8-4", "40"),
("SF153583", "2008-3-19", "63"),
("SF401559", "2010-3-27", "44"),
("SF754913", "2015-6-8", "62"),
("SF340758", "2005-4-28", "96"),
("SF075711", "1973-6-16", "81"),
("SF496399", "1991-8-18", "81"),
("SF260230", "2000-9-28", "95"),
("SF862092", "1971-10-25", "42"),
("SF344737", "1999-4-5", "62"),
("SF038312", "2004-9-10", "83"),
("SF333071", "1990-10-20", "32"),
("SF442157", "1997-6-19", "49"),
("SF831911", "1985-8-9", "96"),
("SF423758", "2005-1-27", "48"),
("SF411235", "1988-2-26", "83"),
("SF660429", "1992-5-22", "31"),
("SF007459", "1990-2-7", "47");
INSERT INTO staff_long_term VALUES
("SF627758", "2004-5-25"),
("SF755291", "2010-9-26"),
("SF337578", "2002-12-19"),
("SF120109", "1981-11-19"),
("SF676888", "1990-3-18"),
("SF855007", "1988-10-10"),
("SF383676", "2009-2-12"),
("SF546749", "2003-11-19"),
("SF487606", "1985-5-4"),
("SF762927", "1977-9-17"),
("SF659008", "2001-5-14"),
("SF569446", "1980-9-22"),
("SF678145", "1997-3-22"),
("SF316487", "2009-4-5"),
("SF080271", "1991-12-11"),
("SF216324", "1989-2-28"),
("SF103585", "1999-11-6"),
("SF072000", "2006-12-4"),
("SF213172", "1998-7-20"),
("SF628748", "2001-11-25"),
("SF457445", "1992-1-22"),
("SF131941", "2015-6-22"),
("SF446458", "1988-3-23"),
("SF675228", "1980-4-14"),
("SF261890", "2001-11-28"),
("SF464318", "2013-11-11"),
("SF943500", "1986-5-23"),
("SF530975", "2012-3-8"),
("SF655037", "2009-1-6"),
("SF945605", "1992-4-6"),
("SF456611", "2009-5-13"),
("SF266671", "1995-6-9"),
("SF562345", "2014-3-18"),
("SF590220", "1995-7-13"),
("SF870969", "2006-7-20"),
("SF654621", "2000-6-1"),
("SF796164", "2008-12-9"),
("SF849370", "2012-2-25"),
("SF376708", "1998-11-4"),
("SF056845", "1993-9-22"),
("SF006280", "2011-3-25"),
("SF656734", "2010-5-12"),
("SF695999", "2006-6-1"),
("SF546599", "2007-5-2"),
("SF752059", "1990-6-4");
INSERT INTO cert_staff VALUES
("SF627758", "1968-5-14", "Universiti Islam Antarabangsa Sultan Abdul Halim Mu’adzam Shah", "BsC of Medication"),
("SF857746", "2005-1-10", "Management and Science University (MSU)", "BsC of Psychiatry"),
("SF755291", "1995-4-17", "Putra Business School", "Master of Bio Chemistry"),
("SF337578", "1967-8-16", "Universiti Putra Malaysia (UPM)", "Master of Neurology"),
("SF120109", "1964-2-22", "Universiti Sains Malaysia (USM)", "BsC Hons of Nursing"),
("SF515337", "1978-7-20", "Universiti Tunku Abdul Rahman (UTAR)", "BsC of Nursing"),
("SF331054", "2004-3-9", "Management and Science University (MSU)", "Master of Hospital Management"),
("SF023492", "1967-6-28", "Al-Madinah International University (MEDIU)", "BsC Hons of Nursing"),
("SF719580", "1982-12-26", "Universiti Islam Antarabangsa Malaysia (UIAM)", "BsC Hons of Medication"),
("SF676888", "1984-1-21", "Universiti Teknologi MARA (UiTM)", "Master of Pediatrics"),
("SF855007", "1985-2-28", "City University", "BsC Hons of Medication Management"),
("SF690668", "1997-8-14", "Putra Business School", "BsC of Healthcare Management"),
("SF383676", "1999-2-2", "International University of Malaya-Wales", "Master of Nursing"),
("SF193356", "1977-6-16", "Open University Malaysia (OUM)", "BsC Hons of Bio Chemistry"),
("SF630902", "1969-10-2", "Universiti Pendidikan Sultan Idris (UPSI)", "Master of Nursing"),
("SF546749", "1982-6-25", "Binary University of Management and Entrepreneurship", "BsC Hons of Nursing"),
("SF547640", "2003-6-27", "Al-Madinah International University (MEDIU)", "BsC Hons of Hospital Management"),
("SF487606", "1969-10-11", "Universiti Malaysia Perlis (UniMAP)", "Master of Nursing"),
("SF401383", "1969-2-1", "Raffles University Iskandar (RUI)", "BsC of Nursing"),
("SF373568", "1986-2-19", "Universiti Pertahanan Nasional Malaysia, (UPNM)", "Master of Medication Management"),
("SF762927", "1977-7-25", "Universiti Tun Hussein Onn Malaysia (UTHM)", "Master of Bio Chemistry"),
("SF783448", "1999-1-29", "Sunway University", "Master of Medication"),
("SF659008", "1999-8-9", "Malaysia Institute of Supply Chain Innovation (MISI)", "Master of Nursing"),
("SF981284", "1977-4-2", "Asia e University (AeU)", "Master of Nursing"),
("SF569446", "1969-10-20", "International Centre for Education in Islamic Finance (INCEIF)", "BsC Hons of Bio Chemistry"),
("SF695361", "1995-7-7", "Meritus University", "Master of Nursing"),
("SF944426", "1977-9-18", "Taylor’s University", "Master of Healthcare Management"),
("SF939987", "2002-2-6", "Infrastructure University Kuala Lumpur (IUKL)", "BsC of Nursing"),
("SF678145", "1993-8-24", "Universiti Malaysia Perlis (UniMAP)", "Master of Radiation oncology"),
("SF597429", "1998-11-13", "Raffles University Iskandar (RUI)", "BsC of Medication Management"),
("SF638678", "1967-11-7", "DRB-HICOM University of Automotive Malaysia", "BsC Hons of Nursing"),
("SF143989", "1974-7-26", "Putra Business School", "BsC of Neurology"),
("SF316487", "2002-3-24", "International Centre for Education in Islamic Finance (INCEIF)", "BsC of Nursing"),
("SF080271", "1987-7-30", "Universiti Sains Malaysia (USM)", "BsC of Hospital Management"),
("SF506355", "1979-10-7", "Universiti Tun Hussein Onn Malaysia (UTHM)", "BsC of Medication"),
("SF271612", "2002-12-26", "Universiti Islam Antarabangsa Sultan Abdul Halim Mu’adzam Shah", "BsC Hons of Bio Chemistry"),
("SF216324", "1973-4-16", "Universiti Tenaga Nasional (UNITEN)", "Master of Nursing"),
("SF103585", "1966-10-28", "SEGi University", "Master of Nursing"),
("SF117623", "1979-3-6", "Universiti Teknikal Malaysia Melaka (UTeM)", "Master of Medication"),
("SF072000", "1969-11-28", "Universiti Teknologi Petronas (UTP)", "BsC of Nursing"),
("SF776060", "1992-1-10", "Asia School of Business", "Master of Ophthalmology"),
("SF213172", "1991-1-24", "Wawasan Open University", "BsC Hons of Medication"),
("SF528378", "2003-7-9", "Malaysia University of Science & Technology (MUST)", "BsC of Bio Chemistry"),
("SF628748", "2000-5-23", "Malaysia University of Science & Technology (MUST)", "BsC Hons of Bio Chemistry"),
("SF457445", "1989-11-6", "Universiti Teknikal Malaysia Melaka (UTeM)", "BsC of Nursing"),
("SF131941", "1998-10-30", "Universiti Pertahanan Nasional Malaysia, (UPNM)", "Master of Nursing"),
("SF284751", "1990-11-21", "Universiti Malaysia Sabah (UMS)", "BsC Hons of Nursing"),
("SF067549", "1994-3-6", "Universiti Malaysia Perlis (UniMAP)", "BsC of Medication Management"),
("SF446458", "1968-4-8", "Universiti Putra Malaysia (UPM)", "BsC of Hospital Management"),
("SF048623", "1971-11-8", "Universiti Putra Malaysia (UPM)", "Master of Bio Chemistry"),
("SF675228", "1976-6-28", "Malaysia University of Science & Technology (MUST)", "Master of Medication"),
("SF828986", "1985-2-26", "UCSI University", "Master of Medication"),
("SF898310", "1969-5-18", "Universiti Pertahanan Nasional Malaysia, (UPNM)", "Master of Neurology"),
("SF261890", "1986-5-4", "Management and Science University (MSU)", "BsC Hons of Medication"),
("SF002786", "1999-3-28", "Binary University of Management and Entrepreneurship", "Master of Bio Chemistry"),
("SF366323", "1966-6-8", "Universiti Islam Antarabangsa Sultan Abdul Halim Mu’adzam Shah", "Master of Medication"),
("SF229821", "1971-1-26", "Meritus University", "BsC Hons of Nursing"),
("SF693364", "1973-5-6", "Asia School of Business", "Master of Radiation oncology"),
("SF464318", "2002-12-1", "International Medical University (IMU)", "Master of Bio Chemistry"),
("SF782869", "1998-12-11", "Binary University of Management and Entrepreneurship", "BsC of Nursing"),
("SF054397", "1976-4-4", "Al-Madinah International University (MEDIU)", "Master of Nursing"),
("SF943500", "1968-1-27", "UNITAR International University", "Master of Nursing"),
("SF392042", "1971-5-13", "SEGi University", "BsC of Nursing"),
("SF028649", "1968-5-10", "Universiti Malaya (UM)", "Master of Bio Chemistry"),
("SF530975", "2004-8-13", "HELP University", "BsC Hons of Nursing"),
("SF655037", "1999-2-17", "Universiti Tun Hussein Onn Malaysia (UTHM)", "Master of Healthcare Management"),
("SF267361", "1996-4-9", "Universiti Islam Antarabangsa Malaysia (UIAM)", "BsC Hons of Nursing"),
("SF945605", "1987-4-8", "Universiti Tenaga Nasional (UNITEN)", "Master of Healthcare Management"),
("SF153583", "1992-2-12", "Binary University of Management and Entrepreneurship", "BsC of Dermatology"),
("SF401559", "1996-4-14", "Raffles University Iskandar (RUI)", "BsC of Medication"),
("SF456611", "1964-4-23", "Universiti Malaysia Sarawak (UNIMAS)", "BsC Hons of Nursing"),
("SF266671", "1993-10-12", "DRB-HICOM University of Automotive Malaysia", "Master of Medication"),
("SF754913", "1988-2-23", "Universiti Tun Hussein Onn Malaysia (UTHM)", "Master of Healthcare Management"),
("SF562345", "1996-9-17", "Raffles University Iskandar (RUI)", "BsC Hons of Medication"),
("SF340758", "2005-3-29", "Universiti Malaysia Pahang (UMP)", "BsC Hons of Nursing"),
("SF075711", "1966-11-5", "Manipal International University", "Master of Nursing"),
("SF590220", "1995-5-29", "Asia School of Business", "BsC of Bio Chemistry"),
("SF496399", "1980-4-1", "Albukhary International University", "BsC Hons of Healthcare Management"),
("SF260230", "1989-7-22", "Universiti Teknologi MARA (UiTM)", "BsC Hons of Bio Chemistry"),
("SF870969", "1999-2-26", "Universiti Kebangsaan Malaysia (UKM)", "BsC of Hospital Management"),
("SF654621", "1994-7-20", "Universiti Malaysia Terengganu (UMT)", "BsC Hons of Nursing"),
("SF796164", "1988-12-5", "City University", "BsC Hons of Nursing"),
("SF862092", "1965-2-24", "AIMST University", "Master of Bio Chemistry"),
("SF849370", "1973-7-13", "Universiti Tenaga Nasional (UNITEN)", "BsC Hons of Nursing"),
("SF376708", "1985-11-20", "Raffles University Iskandar (RUI)", "BsC Hons of Medication Management"),
("SF056845", "1970-11-12", "International University of Malaya-Wales", "BsC of Medication"),
("SF344737", "1987-10-5", "Putra Business School", "Master of Medication"),
("SF038312", "1980-2-26", "Infrastructure University Kuala Lumpur (IUKL)", "BsC Hons of Nursing"),
("SF333071", "1986-1-28", "Universiti Tun Abdul Razak (UniRAZAK)", "BsC of Nursing"),
("SF006280", "1997-3-14", "Asia School of Business", "BsC Hons of Medication"),
("SF442157", "1990-6-5", "Quest International University Perak", "BsC Hons of Medication"),
("SF656734", "1970-9-2", "Albukhary International University", "Master of Hospital Management"),
("SF831911", "1972-10-23", "Wawasan Open University", "Master of Healthcare Management"),
("SF423758", "2004-4-28", "Binary University of Management and Entrepreneurship", "BsC Hons of Nursing"),
("SF695999", "1976-11-22", "Manipal International University", "BsC Hons of Healthcare Management"),
("SF411235", "1974-6-18", "DRB-HICOM University of Automotive Malaysia", "BsC of Medication Management"),
("SF546599", "2002-1-19", "Limkokwing University of Creative Technology", "BsC of Bio Chemistry"),
("SF660429", "1990-8-26", "Universiti Sains Malaysia (USM)", "BsC Hons of Healthcare Management"),
("SF752059", "1976-5-27", "Universiti Malaya (UM)", "Master of Dermatology"),
("SF007459", "1976-6-29", "Albukhary International University", "BsC of Nursing");
INSERT INTO clinic VALUES
("CLN21797", "Dermatology"),
("CLN29419", "Internal medicine"),
("CLN06624", "Neurology"),
("CLN30091", "Obstetrics and gynecology"),
("CLN28874", "Ophthalmology"),
("CLN54717", "Pediatrics"),
("CLN85543", "Psychiatry"),
("CLN22247", "Radiation oncology");
INSERT INTO suppliers VALUES
("SYR19567", "FisherPharmacy SDN BHD", "17, Jalan Tuanku Abdul Rahman 19/35, Kangar, Perlis", "01847784420", "0336560105"),
("SYR54018", "TurnerPharmacy SDN BHD", "Lot. 63, Jalan Choo Cheeng Kay 7/17, Batu Berendam, Malacca", "0124336723", "0350357202"),
("SYR42171", "ThompsonMedication SDN BHD", "2, Jalan Hang Lekiu 45/14, Marang, Terengganu", "0142256267", "0371802228"),
("SYR69670", "AllenPharmacy SDN BHD", "65, Jalan Aminuddin Baki 19/31, Putrajaya", "01861763817", "0339474141"),
("SYR71421", "GomezMedicals SDN BHD", "33, Jalan Tuanku Jaafar 19/6, Kuala Perlis, Perlis", "01616510624", "0364419057"),
("SYR23858", "FosterMedical Supplies SDN BHD", "17, Jalan Binjai 13/37, Kota Kinabalu, Sabah", "0191501185", "0343349744"),
("SYR12057", "TremblayPharmacy SDN BHD", "25, Jalan Burhanuddin Helmi 32/27, Merlimau, Malacca", "01549490094", "0326871212"),
("SYR79639", "BrownPharmacy SDN BHD", "5, Jalan Tun Razak 3/46, Nyalas, Malacca", "0129793495", "0329411699"),
("SYR83177", "EdwardsMedical Supplies SDN BHD", "Lot. 51, Jalan Semarang 32/35, Ranau, Sabah", "01892924931", "0383176449"),
("SYR25271", "HallPharmacy SDN BHD", "Lot. 41, Jalan Tun Mohd Fuad 1/9, Simpang Ampat, Penang", "01787971300", "0395141977"),
("SYR74725", "JamesPharmacy SDN BHD", "Lot. 43, Jalan Kinabalu (part of) 46/45, Pengkalan Kempas, Negeri Sembilan", "0161445825", "0330008434"),
("SYR92567", "JohnsonMedication SDN BHD", "41, Jalan Hamid Ismail 9/39, Putatan, Sabah", "0107964118", "0368601649"),
("SYR31266", "PerezPharmacy SDN BHD", "78, Jalan Wisma Putra 22/37, Simpang Renggam, Johor", "0194000596", "0307678155"),
("SYR13649", "NelsonMedicals SDN BHD", "Lot. 74, Jalan Gallagher 7/34, Kuala Kedah, Kedah", "01775531576", "0303682239"),
("SYR27901", "PetersonMedication SDN BHD", "No. 77, Jalan Raja Abdullah 8/44, Limbang, Sarawak", "01639336523", "0394832043"),
("SYR32231", "BarnesMedical Supplies SDN BHD", "Lot. 42, Jalan Raja Alang 46/14, Kertih, Terengganu", "0143963379", "0352242498"),
("SYR12065", "GonzalezChemicals SDN BHD", "Lot. 12, Jalan Ceylon 43/1, Pantai Remis, Perak", "0195241831", "0312347019"),
("SYR06310", "BakerMedical Supplies SDN BHD", "No. 25, Jalan Kuching 18/1, Kampong Kadok, Kelantan", "0144279144", "0354328456"),
("SYR04673", "RussellLaboratories SDN BHD", "Lot. 57, Jalan Aminuddin Baki 49/9, Kuala Perlis, Perlis", "0130390446", "0301389515"),
("SYR49208", "CampbellChemicals SDN BHD", "57, Jalan Davis 50/44, Paka, Terengganu", "0184553465", "0321775733"),
("SYR19417", "NguyenMedication SDN BHD", "No. 5, Jalan Bellamy 24/24, Peringat, Kelantan", "0141123897", "0355150435"),
("SYR34238", "PriceLaboratories SDN BHD", "No. 16, Jalan Maharajalela 6/47, Miri, Sarawak", "01371222987", "0395334839"),
("SYR49605", "CôtéLaboratories SDN BHD", "76, Jalan Scott 11/41, Kampong Kadok, Kelantan", "01888772618", "0364119638"),
("SYR83081", "OrtizLaboratories SDN BHD", "16, Jalan Gallagher 18/43, Putrajaya", "0173140950", "0399041512"),
("SYR87768", "ButlerMedicals SDN BHD", "8, Jalan Binjai 27/17, Arau, Perlis", "01737686893", "0334377779"),
("SYR38038", "FloresPharmacy SDN BHD", "No. 55, Jalan Bellamy 37/47, Kuala Perlis, Perlis", "01284372510", "0378997926"),
("SYR72917", "RobertsMedication SDN BHD", "32, Jalan Cenderawasih 50/12, Durian Tunggal, Malacca", "01402779798", "0319661570"),
("SYR97065", "FortinMedical Supplies SDN BHD", "Lot. 46, Jalan Yap Kwan Seng 17/25, Arau, Perlis", "01451329404", "0336914765"),
("SYR87554", "WalkerMedicals SDN BHD", "No. 62, Jalan Istana 43/48, Bandar Labuan, Sabah", "01504624215", "0359006889"),
("SYR94205", "DiazLaboratories SDN BHD", "Lot. 58, Jalan Mohana Chandran 39/35, Kangar, Perlis", "01015792823", "0392466118"),
("SYR82216", "CampbellMedicals SDN BHD", "79, Jalan Abdul Rahim Kajai 21/12, Parit Buntar, Perak", "01799069624", "0311772185"),
("SYR52294", "SmithMedication SDN BHD", "56, Jalan Belfield 22/31, Tawau, Sabah", "0196757515", "0347709005"),
("SYR48066", "ScottMedical Supplies SDN BHD", "No. 37, Jalan Samarahan 2/4, Tumpat, Kelantan", "0118479153", "0350358142"),
("SYR33634", "ReyesChemicals SDN BHD", "No. 43, Jalan Travers 42/12, Batu Kawan, Penang", "01592102066", "0329378948"),
("SYR73344", "MooreLaboratories SDN BHD", "3, Jalan Kampung Bandar Dalam 31/42, Tringkap, Pahang", "0191413647", "0381068491"),
("SYR31790", "PerryMedicals SDN BHD", "Lot. 34, Jalan Kuching 40/29, Balik Pulau, Penang", "01621319461", "0303182022"),
("SYR65419", "CruzPharmacy SDN BHD", "9, Jalan Peel 6/47, Bedong, Kedah", "0152116554", "0309329566"),
("SYR70827", "CôtéMedicals SDN BHD", "5, Jalan Stonor 28/44, Kapit, Sarawak", "01103387565", "0390366948"),
("SYR90341", "FosterMedicals SDN BHD", "34, Jalan Petaling 30/46, Labuan", "0137900582", "0363157436"),
("SYR17625", "ClarkLaboratories SDN BHD", "No. 37, Jalan Tun Tan Siew Sin 36/18, Kuala Perlis, Perlis", "0102120907", "0353523409"),
("SYR00455", "GutierrezMedical Supplies SDN BHD", "11, Jalan Gallagher 32/32, Kuala Terengganu, Terengganu", "01339578131", "0318042334"),
("SYR71545", "GauthierChemicals SDN BHD", "Lot. 37, Jalan Bukit Ceylon 4/24, Cheng, Malacca", "0172721121", "0331502567"),
("SYR75911", "CôtéMedical Supplies SDN BHD", "4, Jalan Tuanku Abdul Halim 27/23, Kuala Pilah (town), Negeri Sembilan", "01941189065", "0365217125"),
("SYR06361", "RogersPharmacy SDN BHD", "No. 17, Jalan Raja Muda Musa 1/29, Kelapa Sawit, Johor", "01619701845", "0332892491"),
("SYR55313", "NelsonLaboratories SDN BHD", "No. 24, Jalan Serian 34/43, Gurun, Kedah", "01488405409", "0393787636"),
("SYR92438", "ReedChemicals SDN BHD", "1, Jalan Genting Klang 18/18, Labuan", "01785996762", "0341689570"),
("SYR96395", "JacksonMedicals SDN BHD", "46, Jalan Zaaba 11/1, Labuan", "01853988612", "0384668900"),
("SYR77005", "JenkinsLaboratories SDN BHD", "No. 6, Jalan Bellamy 50/27, Banting, Selangor", "0159811715", "0354624660"),
("SYR56223", "HughesMedical Supplies SDN BHD", "40, Jalan Travers 28/32, Sungai Pelek, Selangor", "0105118368", "0364330988"),
("SYR99923", "BennettLaboratories SDN BHD", "14, Jalan Dewan Sultan Sulaiman 4/35, Shah Alam, Selangor", "0146613468", "0362678008"),
("SYR82245", "SullivanMedicals SDN BHD", "Lot. 59, Jalan Chan Wing 9/23, Bagan Serai, Perak", "01271505218", "0338414254");
INSERT INTO supply VALUES
("INS00001", "Adhesive tape", 150, 300, "385.69", "SYR19567", "SF655037"),
("DRG00001","Atorvastatin",4422,1000,"178.79","SYR19567","SF660429"),
("INS00002", "Elastic wrap bandages", 469, 400, "359.79", "SYR54018", "SF376708"),
("DRG00002","Levothyroxine",3879,5000,"168.92","SYR54018","SF831911"),
("INS00003", "Bandage strips and 'butterfly' bandages in assorted sizes", 455, 200, "309.56", "SYR42171", "SF331054"),
("DRG00003","Lisinopril",2873,1000,"360.71","SYR42171","SF655037"),
("INS00004", "Super glue", 267, 400, "232.11", "SYR69670", "SF655037"),
("DRG00004","Metformin",2759,3000,"264.87","SYR69670","SF660429"),
("INS00005", "Rubber tourniquet or 16 French catheter", 455, 300, "290.50", "SYR71421", "SF660429"),
("DRG00005","Amlodipine",1810,1000,"216.88","SYR71421","SF446458"),
("INS00006", "Nonstick sterile bandages and roller gauze in assorted sizes", 312, 400, "264.01", "SYR23858", "SF446458"),
("DRG00006","Metoprolol",2084,3000,"390.08","SYR23858","SF660429"),
("INS00007", "Eye shield or pad", 263, 400, "224.76", "SYR12057", "SF855007"),
("DRG00007","Albuterol",4935,1000,"126.55","SYR12057","SF831911"),
("INS00008", "Large triangular bandage (may be used as a sling)", 427, 200, "354.91", "SYR79639", "SF855007"),
("DRG00008","Omeprazole",4390,2000,"317.03","SYR79639","SF067549"),
("INS00009", "Aluminum finger splint", 146, 100, "380.57", "SYR83177", "SF331054"),
("DRG00009","Losartan",4659,5000,"166.98","SYR83177","SF655037"),
("INS00010", "Instant cold packs", 152, 200, "367.61", "SYR25271", "SF597429"),
("DRG00010","Simvastatin",2398,1000,"216.06","SYR25271","SF655037"),
("INS00011", "Cotton balls and cotton-tipped swabs", 327, 500, "217.13", "SYR74725", "SF831911"),
("DRG00011","Gabapentin",3443,3000,"127.71","SYR74725","SF376708"),
("INS00012", "Disposable nonlatex examination gloves, several pairs", 335, 200, "122.15", "SYR92567", "SF562345"),
("DRG00012","Hydrochlorothiazide",3620,2000,"303.05","SYR92567","SF655037"),
("INS00013", "Duct tape", 183, 300, "269.06", "SYR31266", "SF655037"),
("DRG00013","Sertraline",2479,1000,"248.68","SYR31266","SF660429"),
("INS00014", "Petroleum jelly or other lubricant", 314, 500, "372.59", "SYR13649", "SF376708"),
("DRG00014","Montelukast",1078,2000,"193.65","SYR13649","SF660429"),
("INS00015", "Plastic bags, assorted sizes", 221, 500, "367.76", "SYR27901", "SF562345"),
("DRG00015","Fluticasone",4564,4000,"218.57","SYR27901","SF376708"),
("INS00016", "Safety pins in assorted sizes", 457, 500, "178.12", "SYR32231", "SF831911"),
("DRG00016","Amoxicillin",2317,4000,"371.95","SYR32231","SF597429"),
("INS00017", "Scissors and tweezers", 446, 100, "344.91", "SYR12065", "SF331054"),
("DRG00017","Furosemide",1049,3000,"265.16","SYR12065","SF660429"),
("INS00018", "Hand sanitizer", 124, 300, "238.81", "SYR06310", "SF831911"),
("DRG00018","Pantoprazole",1346,1000,"361.27","SYR06310","SF547640"),
("INS00019", "Antibiotic ointment", 145, 500, "387.76", "SYR04673", "SF376708"),
("DRG00019","Prednisone",3236,2000,"393.92","SYR04673","SF855007"),
("INS00020", "Antiseptic solution and towelettes", 199, 100, "346.96", "SYR49208", "SF547640"),
("DRG00020","Escitalopram",3488,4000,"278.62","SYR49208","SF547640"),
("INS00021", "Eyewash solution", 307, 200, "194.23", "SYR19417", "SF562345"),
("DRG00021","Fluoxetine",1668,5000,"234.54","SYR19417","SF660429"),
("INS00022", "Thermometer", 354, 200, "229.43", "SYR34238", "SF331054"),
("DRG00022","Dextroamphetamine",3962,5000,"308.31","SYR34238","SF655037"),
("INS00023", "Turkey baster or other bulb suction device for flushing wounds", 385, 200, "286.88", "SYR49605", "SF446458"),
("DRG00023","Insulin Glargine",3253,5000,"365.82","SYR49605","SF597429"),
("INS00024", "Sterile saline for irrigation, flushing", 485, 400, "247.15", "SYR83081", "SF376708"),
("DRG00024","Bupropion",3428,4000,"351.69","SYR83081","SF855007"),
("INS00025", "Breathing barrier (surgical mask)", 113, 300, "326.85", "SYR87768", "SF660429"),
("DRG00025","Ibuprofen",2646,5000,"335.38","SYR87768","SF067549"),
("INS00026", "Syringe, medicine cup or spoon", 414, 200, "248.56", "SYR38038", "SF446458"),
("DRG00026","Rosuvastatin",3324,3000,"148.96","SYR38038","SF547640"),
("INS00027", "First-aid manual", 257, 100, "111.75", "SYR72917", "SF831911"),
("DRG00027","Pravastatin Sodium",2339,2000,"143.69","SYR72917","SF655037"),
("INS00028", "Hydrogen peroxide to disinfect", 321, 100, "279.35", "SYR97065", "SF331054"),
("DRG00028","Trazodone",3405,1000,"208.27","SYR97065","SF597429"),
("INS00029", "Aloe vera gel", 417, 200, "310.62", "SYR87554", "SF597429"),
("DRG00029","Tamsulosin",4413,5000,"214.75","SYR87554","SF067549"),
("INS00030", "Calamine lotion", 201, 200, "164.36", "SYR94205", "SF067549"),
("DRG00030","Carvedilol",1577,3000,"123.63","SYR94205","SF376708"),
("INS00031", "Anti-diarrhea medication", 158, 200, "282.67", "SYR82216", "SF597429"),
("DRG00031","Meloxicam",4927,3000,"252.85","SYR82216","SF597429"),
("INS00032", "Laxative", 301, 200, "137.68", "SYR52294", "SF655037"),
("DRG00032","Citalopram",2474,3000,"174.21","SYR52294","SF660429"),
("INS00033", "Antacids", 302, 500, "352.38", "SYR48066", "SF655037"),
("DRG00033","Duloxetine",4639,4000,"267.42","SYR48066","SF067549"),
("INS00034", "Antihistamine, such as diphenhydramine", 473, 300, "206.48", "SYR33634", "SF597429"),
("DRG00034","Alprazolam",3732,1000,"223.22","SYR33634","SF562345"),
("INS00035", "Hydrocortisone cream", 281, 400, "150.85", "SYR73344", "SF562345"),
("DRG00035","Potassium",3967,3000,"192.80","SYR73344","SF597429"),
("INS00036", "Cough and cold medications", 182, 200, "177.27", "SYR31790", "SF067549"),
("DRG00036","Clopidogrel",1595,5000,"373.00","SYR31790","SF067549"),
("INS00037", "Personal medications that don't need refrigeration", 205, 400, "175.51", "SYR65419", "SF655037"),
("DRG00037","Atenolol",1853,3000,"198.58","SYR65419","SF376708"),
("INS00038", "Auto-injector of epinephrine, if prescribed by your doctor", 383, 200, "174.96", "SYR70827", "SF376708"),
("DRG00038","Cyclobenzaprine",1471,5000,"281.64","SYR70827","SF660429"),
("INS00039", "Pain relievers, such as acetaminophen (Tylenol, others), ibuprofen (Advil, Motrin IB, others)", 378, 400, "375.73", "SYR90341", "SF376708"),
("DRG00039","Allopurinol",4782,3000,"194.45","SYR90341","SF562345"),
("DRG00040","Venlafaxine",1641,2000,"130.97","SYR17625","SF597429"),
("DRG00041","Warfarin",1503,4000,"222.76","SYR00455","SF376708"),
("DRG00042","Propranolol",4941,5000,"356.19","SYR71545","SF376708"),
("DRG00043","Cetirizine",4699,1000,"371.85","SYR75911","SF655037"),
("DRG00044","Estradiol",1738,5000,"196.79","SYR06361","SF562345"),
("DRG00045","Lorazepam",2221,3000,"320.50","SYR55313","SF547640"),
("DRG00046","Quetiapine",1143,1000,"249.77","SYR92438","SF331054"),
("DRG00047","Zolpidem Tartrate",1090,4000,"222.54","SYR96395","SF831911"),
("DRG00048","Ergocalciferol",2646,1000,"193.73","SYR77005","SF655037"),
("DRG00049","Budesonide",2634,3000,"274.27","SYR56223","SF547640"),
("DRG00050","Ethinyl Estradiol/Norethindrone",1994,4000,"303.03","SYR99923","SF331054");
INSERT INTO supply_drug VALUES
("DRG00001", "Topical", "30"),
("DRG00002", "Topical", "35"),
("DRG00003", "Liquid Ingestion", "20"),
("DRG00004", "Liquid Injection", "34"),
("DRG00005", "Liquid Ingestion", "32"),
("DRG00006", "Liquid Ingestion", "35"),
("DRG00007", "Liquid Injection", "31"),
("DRG00008", "Tablet", "32"),
("DRG00009", "Liquid Injection", "23"),
("DRG00010", "Topical", "43"),
("DRG00011", "Liquid Ingestion", "23"),
("DRG00012", "Liquid Injection", "28"),
("DRG00013", "Topical", "15"),
("DRG00014", "Liquid Injection", "18"),
("DRG00015", "Liquid Ingestion", "38"),
("DRG00016", "Topical", "30"),
("DRG00017", "Liquid Ingestion", "35"),
("DRG00018", "Liquid Ingestion", "20"),
("DRG00019", "Tablet", "34"),
("DRG00020", "Topical", "32"),
("DRG00021", "Tablet", "35"),
("DRG00022", "Tablet", "31"),
("DRG00023", "Topical", "32"),
("DRG00024", "Topical", "23"),
("DRG00025", "Liquid Injection", "43"),
("DRG00026", "Liquid Injection", "30"),
("DRG00027", "Tablet", "35"),
("DRG00028", "Topical", "20"),
("DRG00029", "Topical", "34"),
("DRG00030", "Topical", "32"),
("DRG00031", "Tablet", "35"),
("DRG00032", "Liquid Injection", "31"),
("DRG00033", "Topical", "32"),
("DRG00034", "Tablet", "23"),
("DRG00035", "Liquid Ingestion", "43"),
("DRG00036", "Tablet", "30"),
("DRG00037", "Topical", "35"),
("DRG00038", "Liquid Injection", "20"),
("DRG00039", "Liquid Injection", "34"),
("DRG00040", "Tablet", "32"),
("DRG00041", "Tablet", "35"),
("DRG00042", "Tablet", "31"),
("DRG00043", "Topical", "32"),
("DRG00044", "Liquid Injection", "23"),
("DRG00045", "Topical", "43"),
("DRG00046", "Liquid Injection", "24"),
("DRG00047", "Liquid Ingestion", "43"),
("DRG00048", "Tablet", "52"),
("DRG00049", "Liquid Injection", "20"),
("DRG00050", "Tablet", "38");
INSERT INTO supply_equipment VALUES
("INS00001", "Small", "First-aid"),
("INS00002", "Small", "First-aid"),
("INS00003", "Small", "First-aid"),
("INS00004", "Small", "First-aid"),
("INS00005", "Small", "First-aid"),
("INS00006", "Small", "First-aid"),
("INS00007", "Small", "First-aid"),
("INS00008", "Small", "First-aid"),
("INS00009", "Small", "First-aid"),
("INS00010", "Small", "First-aid"),
("INS00011", "Small", "First-aid"),
("INS00012", "Small", "First-aid"),
("INS00013", "Small", "First-aid"),
("INS00014", "Small", "First-aid"),
("INS00015", "Small", "First-aid"),
("INS00016", "Small", "First-aid"),
("INS00017", "Small", "First-aid"),
("INS00018", "Small", "First-aid"),