-
Notifications
You must be signed in to change notification settings - Fork 0
/
dim_customer.sql
1496 lines (1496 loc) · 130 KB
/
dim_customer.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 public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11013,543,'Ian Jenkins','1988-08-06','M','M','2018-10-15',34,'Group 21 - 40'),
(11014,634,'Sydney Bennett','1988-05-09','S','F','2018-09-24',34,'Group 21 - 40'),
(11015,301,'Chloe Young','1999-02-27','S','F','2018-07-22',23,'Group 21 - 40'),
(11016,329,'Wyatt Hill','1999-04-28','M','M','2018-08-13',23,'Group 21 - 40'),
(11017,39,'Shannon Wang','1964-06-26','S','F','2016-07-15',58,'Group 41 - 60'),
(11018,32,'Clarence Rai','1964-10-09','S','M','2016-07-20',58,'Group 41 - 60'),
(11019,52,'Luke Lal','1998-03-07','S','M','2018-08-16',24,'Group 21 - 40'),
(11020,53,'Jordan King','1998-09-20','S','M','2018-07-02',24,'Group 21 - 40'),
(11021,536,'Destiny Wilson','1998-09-03','S','F','2018-07-27',24,'Group 21 - 40'),
(11022,609,'Ethan Zhang','1998-10-12','M','M','2018-07-24',24,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11023,298,'Seth Edwards','1998-10-11','M','M','2018-08-21',24,'Group 21 - 40'),
(11024,311,'Russell Xie','1998-09-17','M','M','2018-12-29',24,'Group 21 - 40'),
(11025,24,'Alejandro Beck','1965-12-23','M','M','2016-07-09',57,'Group 41 - 60'),
(11026,4,'Harold Sai','1966-04-03','S','M','2016-07-26',56,'Group 41 - 60'),
(11027,40,'Jessie Zhao','1966-12-07','M','M','2016-07-19',56,'Group 41 - 60'),
(11028,17,'Jill Jimenez','1966-04-11','M','F','2016-07-29',56,'Group 41 - 60'),
(11029,32,'Jimmy Moreno','1966-12-21','M','M','2016-07-22',56,'Group 41 - 60'),
(11030,28,'Bethany Yuan','1967-02-22','M','F','2016-08-08',55,'Group 41 - 60'),
(11031,8,'Theresa Ramos','1967-08-22','M','F','2016-08-04',55,'Group 41 - 60'),
(11032,35,'Denise Stone','1967-06-11','M','F','2016-08-21',55,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11033,9,'Jaime Nath','1967-09-23','M','M','2016-08-18',55,'Group 41 - 60'),
(11034,12,'Ebony Gonzalez','1967-06-19','M','F','2016-08-04',55,'Group 41 - 60'),
(11035,33,'Wendy Dominguez','1968-02-24','M','F','2016-08-09',54,'Group 41 - 60'),
(11036,343,'Jennifer Russell','1998-12-18','M','F','2018-07-26',24,'Group 21 - 40'),
(11037,49,'Chloe Garcia','1997-11-27','S','F','2018-07-24',25,'Group 21 - 40'),
(11038,6,'Diana Hernandez','1968-03-23','M','F','2016-08-10',54,'Group 41 - 60'),
(11039,19,'Marc Martin','1968-12-17','M','M','2016-08-10',54,'Group 41 - 60'),
(11040,642,'Jesse Murphy','1997-08-01','M','M','2018-10-05',25,'Group 21 - 40'),
(11041,325,'Amanda Carter','1997-10-16','M','F','2018-07-18',25,'Group 21 - 40'),
(11042,338,'Megan Sanchez','1997-06-13','M','F','2018-07-25',25,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11043,325,'Nathan Simmons','1996-02-24','M','M','2018-11-09',26,'Group 21 - 40'),
(11044,25,'Adam Flores','1969-05-24','M','M','2016-08-31',53,'Group 41 - 60'),
(11045,8,'Leonard Nara','1970-05-19','S','M','2018-10-12',52,'Group 41 - 60'),
(11046,6,'Christine Yuan','1970-03-22','M','F','2016-08-09',52,'Group 41 - 60'),
(11047,34,'Jaclyn Lu','1970-02-27','M','F','2016-08-06',52,'Group 41 - 60'),
(11048,39,'Jeremy Powell','1970-11-22','M','M','2016-08-13',52,'Group 41 - 60'),
(11049,307,'Carol Rai','2000-07-18','S','F','2018-09-10',22,'Group 21 - 40'),
(11050,31,'Alan Zheng','1971-09-07','M','M','2016-08-23',51,'Group 41 - 60'),
(11052,8,'Heidi Lopez','1971-08-07','S','F','2016-08-20',51,'Group 41 - 60'),
(11053,359,'Ana Price','2000-08-20','M','F','2018-07-21',22,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11054,34,'Deanna Munoz','1972-03-10','M','F','2016-08-06',50,'Group 41 - 60'),
(11055,22,'Gilbert Raje','1972-03-05','M','M','2016-08-03',50,'Group 41 - 60'),
(11056,10,'Michele Nath','1973-04-03','M','F','2016-08-29',49,'Group 41 - 60'),
(11057,5,'Carl Andersen','1973-10-12','M','M','2016-08-25',49,'Group 41 - 60'),
(11058,29,'Marc Diaz','1974-04-27','M','M','2016-09-09',48,'Group 41 - 60'),
(11059,27,'Ashlee Andersen','1974-04-01','S','F','2018-08-22',48,'Group 41 - 60'),
(11060,40,'Jon Zhou','1974-03-17','M','M','2016-09-19',48,'Group 41 - 60'),
(11061,23,'Todd Gao','1974-02-27','M','M','2016-09-13',48,'Group 41 - 60'),
(11062,547,'Noah Powell','1995-09-02','M','M','2018-07-11',27,'Group 21 - 40'),
(11063,634,'Angela Murphy','1995-04-07','S','F','2018-07-16',27,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11064,315,'Chase Reed','1995-12-07','M','M','2018-07-29',27,'Group 21 - 40'),
(11065,331,'Jessica Henderson','1993-10-09','M','F','2018-08-14',29,'Group 21 - 40'),
(11066,543,'Grace Butler','1993-11-27','M','F','2018-12-02',29,'Group 21 - 40'),
(11068,40,'Tiffany Liang','1975-09-23','S','F','2018-11-01',47,'Group 41 - 60'),
(11069,23,'Carolyn Navarro','1975-09-21','S','F','2016-10-18',47,'Group 41 - 60'),
(11070,39,'Willie Raji','1975-04-05','M','M','2016-10-29',47,'Group 41 - 60'),
(11071,24,'Linda Serrano','1975-06-26','S','F','2018-09-02',47,'Group 41 - 60'),
(11072,17,'Casey Luo','1975-02-06','S','F','2016-10-01',47,'Group 41 - 60'),
(11073,16,'Amy Ye','1976-08-14','S','F','2018-09-24',46,'Group 41 - 60'),
(11074,28,'Levi Arun','1976-08-28','S','M','2018-09-24',46,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11075,32,'Felicia Jimenez','1977-11-16','S','F','2016-10-29',45,'Group 41 - 60'),
(11076,19,'Blake Anderson','1977-07-13','S','M','2016-10-22',45,'Group 41 - 60'),
(11077,36,'Leah Ye','1977-09-19','S','F','2016-10-16',45,'Group 41 - 60'),
(11078,49,'Gina Martin','1994-01-10','S','F','2018-08-19',28,'Group 21 - 40'),
(11079,34,'Donald Gonzalez','1979-03-11','S','M','2018-09-16',43,'Group 41 - 60'),
(11080,30,'Damien Chander','1979-07-17','M','M','2016-10-11',43,'Group 41 - 60'),
(11081,311,'Savannah Baker','1986-07-24','M','F','2018-08-16',36,'Group 21 - 40'),
(11082,322,'Angela Butler','1986-08-04','S','F','2018-07-26',36,'Group 21 - 40'),
(11083,336,'Alyssa Cox','1986-03-15','M','F','2018-07-10',36,'Group 21 - 40'),
(11084,543,'Lucas Phillips','1977-09-12','S','M','2018-07-08',45,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11087,307,'Tamara Liang','1977-10-03','M','F','2018-08-29',45,'Group 41 - 60'),
(11088,359,'Hunter Davis','1977-11-25','M','M','2018-07-17',45,'Group 41 - 60'),
(11089,337,'Abigail Price','1977-02-05','S','F','2018-07-02',45,'Group 41 - 60'),
(11090,338,'Trevor Bryant','1977-12-17','S','M','2017-02-07',45,'Group 41 - 60'),
(11091,50,'Dalton Perez','1977-04-04','M','M','2018-08-02',45,'Group 41 - 60'),
(11092,22,'Cheryl Diaz','1987-05-06','M','F','2016-10-09',35,'Group 21 - 40'),
(11093,19,'Aimee He','1987-09-10','M','F','2016-10-08',35,'Group 21 - 40'),
(11094,33,'Cedric Ma','1982-04-01','S','M','2018-10-09',40,'Group 21 - 40'),
(11095,13,'Chad Kumar','1982-09-01','S','M','2016-10-02',40,'Group 21 - 40'),
(11096,12,'Andrés Anand','1982-08-10','M','M','2016-10-12',40,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11097,40,'Edwin Nara','1981-10-27','M','M','2016-10-05',41,'Group 41 - 60'),
(11098,14,'Mallory Rubio','1981-05-01','S','F','2018-08-15',41,'Group 41 - 60'),
(11099,13,'Adam Ross','1981-03-08','M','M','2016-10-08',41,'Group 41 - 60'),
(11100,28,'Latasha Navarro','1980-09-15','S','F','2016-10-17',42,'Group 41 - 60'),
(11101,33,'Abby Sai','1985-05-08','S','F','2016-10-30',37,'Group 21 - 40'),
(11103,3,'Cassie Chande','1984-10-17','S','F','2016-10-16',38,'Group 21 - 40'),
(11104,23,'Edgar Sara','1984-03-11','M','M','2016-11-04',38,'Group 21 - 40'),
(11105,8,'Candace Fernandez','1984-12-28','S','F','2016-11-14',38,'Group 21 - 40'),
(11106,40,'Jessie Liu','1984-09-11','S','M','2016-11-18',38,'Group 21 - 40'),
(11107,17,'Bianca Lin','1979-09-09','M','F','2016-11-01',43,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11108,13,'Kari Alvarez','1983-07-14','S','F','2016-11-03',39,'Group 21 - 40'),
(11109,38,'Ruben Kapoor','1983-11-05','S','M','2016-11-10',39,'Group 21 - 40'),
(11110,3,'Curtis Yang','1982-06-06','M','M','2016-11-01',40,'Group 21 - 40'),
(11111,34,'Meredith Gutierrez','1982-02-23','M','F','2016-11-20',40,'Group 21 - 40'),
(11112,25,'Crystal Wang','1982-09-09','M','F','2016-11-25',40,'Group 21 - 40'),
(11113,30,'Micheal Blanco','1982-02-21','M','M','2018-08-05',40,'Group 21 - 40'),
(11114,14,'Leslie Moreno','1982-05-28','S','F','2018-09-19',40,'Group 21 - 40'),
(11115,17,'Alvin Cai','1982-02-12','M','M','2018-08-14',40,'Group 21 - 40'),
(11116,18,'Clinton Carlson','1982-10-07','M','M','2018-09-16',40,'Group 21 - 40'),
(11117,8,'April Deng','1981-02-21','M','F','2016-11-06',41,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11119,13,'Evan James','1955-04-10','S','M','2018-08-07',67,'Group > 60'),
(11120,18,'Beth Jiménez','1956-08-09','S','F','2016-11-14',66,'Group > 60'),
(11121,10,'Orlando Suarez','1980-11-18','M','M','2018-12-26',42,'Group 41 - 60'),
(11122,12,'Byron Vazquez','1980-04-02','M','M','2018-08-25',42,'Group 41 - 60'),
(11123,39,'Philip Alvarez','1980-06-20','M','M','2018-10-19',42,'Group 41 - 60'),
(11124,40,'Ross Jordan','1977-07-27','S','M','2016-11-05',45,'Group 41 - 60'),
(11125,37,'Dana Navarro','1976-04-08','S','F','2018-08-04',46,'Group 41 - 60'),
(11126,11,'Shaun Carson','1969-04-07','M','M','2016-11-28',53,'Group 41 - 60'),
(11127,361,'Jan Edwards','1995-10-21','M','F','2018-10-12',27,'Group 21 - 40'),
(11128,635,'Samantha Long','1995-12-05','M','F','2018-12-21',27,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11129,638,'Julia Wright','1995-08-05','S','F','2017-02-06',27,'Group 21 - 40'),
(11132,51,'Melissa Richardson','2000-10-26','S','F','2018-10-11',22,'Group 21 - 40'),
(11134,30,'Larry Townsend','1966-02-26','S','M','2016-11-03',56,'Group 41 - 60'),
(11135,302,'Marcus Harris','1999-11-03','S','M','2018-10-20',23,'Group 21 - 40'),
(11136,53,'Brianna Morgan','1998-10-26','S','F','2018-07-07',24,'Group 21 - 40'),
(11140,301,'Javier Alvarez','1997-02-11','S','M','2018-09-20',25,'Group 21 - 40'),
(11141,314,'Nicole Ramirez','1997-06-21','M','F','2018-11-17',25,'Group 21 - 40'),
(11142,51,'Eduardo Patterson','1997-08-14','S','M','2018-08-17',25,'Group 21 - 40'),
(11143,334,'Jonathan Henderson','1997-02-04','M','M','2018-12-17',25,'Group 21 - 40'),
(11144,607,'Edward Hernandez','1999-09-09','S','M','2018-07-29',23,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11145,536,'Jasmine Coleman','1999-12-08','S','F','2018-07-29',23,'Group 21 - 40'),
(11146,8,'Karla Goel','1959-08-26','S','F','2018-08-09',63,'Group > 60'),
(11147,40,'Ernest Wu','1959-02-05','M','M','2016-11-13',63,'Group > 60'),
(11148,22,'Ross Vazquez','1961-08-16','M','M','2018-09-08',61,'Group > 60'),
(11149,25,'Theodore Gill','1961-04-20','M','M','2018-12-06',61,'Group > 60'),
(11150,39,'Russell Shen','1961-03-15','S','M','2018-09-28',61,'Group > 60'),
(11151,18,'Melinda Gill','1962-02-25','S','F','2016-11-15',60,'Group 41 - 60'),
(11152,633,'James Williams','1996-01-10','S','M','2018-07-13',26,'Group 21 - 40'),
(11153,635,'Angela James','1996-06-23','M','F','2018-09-30',26,'Group 21 - 40'),
(11154,553,'Megan Walker','1996-08-21','S','F','2018-07-14',26,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11155,301,'Hunter Robinson','1996-01-26','S','M','2018-07-10',26,'Group 21 - 40'),
(11156,334,'Maria Roberts','1996-02-07','S','F','2018-07-12',26,'Group 21 - 40'),
(11158,361,'Jason Wright','1995-10-08','S','M','2018-07-23',27,'Group 21 - 40'),
(11160,311,'Maurice Tang','1994-01-08','S','M','2018-08-25',28,'Group 21 - 40'),
(11161,311,'Emily Wood','1994-04-22','S','F','2018-12-03',28,'Group 21 - 40'),
(11162,331,'Chase Cox','1994-03-05','S','M','2018-08-22',28,'Group 21 - 40'),
(11163,372,'Gabriel Wang','1994-12-20','M','M','2018-11-02',28,'Group 21 - 40'),
(11164,374,'Devin Brooks','1994-05-05','S','M','2018-10-29',28,'Group 21 - 40'),
(11165,348,'Jocelyn Alexander','1993-07-18','M','F','2018-11-26',29,'Group 21 - 40'),
(11167,618,'Jasmine Barnes','1992-08-01','S','F','2018-07-11',30,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11168,348,'David Rodriguez','1988-05-15','S','M','2018-07-19',34,'Group 21 - 40'),
(11169,312,'Bryce Richardson','1988-06-22','M','M','2018-11-27',34,'Group 21 - 40'),
(11171,385,'Jonathan Hill','1987-10-09','S','M','2017-02-20',35,'Group 21 - 40'),
(11172,626,'Gabrielle Adams','1987-11-21','M','F','2018-11-04',35,'Group 21 - 40'),
(11173,552,'Sarah Thomas','1987-09-01','S','F','2018-09-03',35,'Group 21 - 40'),
(11175,300,'Luis Wang','1983-03-05','S','M','2017-02-28',39,'Group 21 - 40'),
(11176,50,'Mason Roberts','1988-01-25','M','M','2018-08-06',34,'Group 21 - 40'),
(11177,359,'Jose Flores','1962-07-04','M','M','2018-09-30',60,'Group 41 - 60'),
(11178,334,'Nathan Johnson','1963-08-24','M','M','2018-08-25',59,'Group 41 - 60'),
(11179,300,'Molly Rodriguez','1963-06-14','M','F','2018-09-13',59,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11180,307,'April Anand','1963-01-02','M','F','2018-09-18',59,'Group 41 - 60'),
(11181,338,'Devin Martin','1963-08-08','M','M','2018-11-08',59,'Group 41 - 60'),
(11183,368,'Jasmine Lee','1964-07-15','S','F','2018-11-01',58,'Group 41 - 60'),
(11185,53,'Ashley Henderson','1964-10-08','S','F','2018-08-25',58,'Group 41 - 60'),
(11187,612,'Jennifer Cooper','1964-02-22','M','F','2018-10-05',58,'Group 41 - 60'),
(11189,609,'Lawrence Blanco','1964-07-15','S','M','2017-02-26',58,'Group 41 - 60'),
(11191,310,'Kristi Perez','1965-12-18','S','F','2017-02-11',57,'Group 41 - 60'),
(11192,637,'James Brown','1965-09-13','M','M','2018-12-25',57,'Group 41 - 60'),
(11193,553,'Ian Gray','1965-02-13','M','M','2018-08-29',57,'Group 41 - 60'),
(11194,352,'Jacqueline Price','1965-06-10','M','F','2018-09-14',57,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11195,635,'Megan Henderson','1966-02-10','M','F','2018-10-16',56,'Group 41 - 60'),
(11196,536,'Alfredo Romero','1966-06-07','M','M','2018-09-04',56,'Group 41 - 60'),
(11197,637,'Andrea Morris','1966-06-18','M','F','2018-11-03',56,'Group 41 - 60'),
(11198,368,'Brooke Sanders','1966-11-26','S','F','2018-08-09',56,'Group 41 - 60'),
(11199,302,'Jacqueline Bennett','1966-11-06','M','F','2018-09-19',56,'Group 41 - 60'),
(11200,69,'Jason Griffin','1967-11-22','M','M','2018-08-11',55,'Group 41 - 60'),
(11203,60,'Luis Diaz','1968-08-21','M','M','2018-08-24',54,'Group 41 - 60'),
(11206,626,'Blake Flores','1968-09-24','M','M','2018-11-12',54,'Group 41 - 60'),
(11207,635,'Danielle Cox','1968-07-19','S','F','2018-08-04',54,'Group 41 - 60'),
(11208,325,'Maria Reed','1968-02-04','M','F','2018-09-05',54,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11209,336,'Allison Evans','1968-01-13','M','F','2018-09-26',54,'Group 41 - 60'),
(11210,383,'Edward Wood','1968-06-08','M','M','2018-11-07',54,'Group 41 - 60'),
(11211,50,'Samantha Russell','1969-10-12','M','F','2018-08-05',53,'Group 41 - 60'),
(11212,53,'Chloe Campbell','1969-11-05','M','F','2018-08-03',53,'Group 41 - 60'),
(11213,614,'Stephanie Murphy','1969-05-14','S','F','2018-09-29',53,'Group 41 - 60'),
(11215,62,'Ana Perry','1970-06-21','M','F','2018-08-19',52,'Group 41 - 60'),
(11216,547,'Jasmine Torres','1970-05-20','S','F','2017-02-15',52,'Group 41 - 60'),
(11217,547,'Natalie Adams','1970-02-11','S','F','2017-02-10',52,'Group 41 - 60'),
(11218,642,'Olivia Brown','1970-09-11','S','F','2018-09-01',52,'Group 41 - 60'),
(11220,310,'Erica Huang','1970-02-23','M','F','2018-09-15',52,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11221,334,'Nathan Perry','1970-06-10','M','M','2018-10-09',52,'Group 41 - 60'),
(11223,52,'Hailey Patterson','1971-09-16','S','F','2018-08-02',51,'Group 41 - 60'),
(11224,612,'Tiffany Li','1971-09-06','S','F','2017-02-07',51,'Group 41 - 60'),
(11225,635,'Madison Lee','1971-02-16','M','F','2018-12-24',51,'Group 41 - 60'),
(11226,552,'Sydney Ross','1971-09-27','M','F','2018-08-25',51,'Group 41 - 60'),
(11227,310,'Marshall Chavez','1971-08-12','S','M','2017-02-03',51,'Group 41 - 60'),
(11231,611,'Dennis Zhang','1972-11-14','M','M','2018-08-14',50,'Group 41 - 60'),
(11233,299,'Todd Li','1972-09-09','M','M','2018-08-12',50,'Group 41 - 60'),
(11234,337,'Anna Griffin','1972-11-19','S','F','2018-08-12',50,'Group 41 - 60'),
(11237,161,'Clarence Anand','1978-09-23','S','M','2017-03-08',44,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11238,232,'Mayra Prasad','1978-08-10','S','F','2016-07-09',44,'Group 41 - 60'),
(11239,249,'Latoya Goel','1978-10-06','M','F','2016-07-22',44,'Group 41 - 60'),
(11240,273,'Anne Hernandez','1978-12-11','M','F','2016-08-30',44,'Group 41 - 60'),
(11241,211,'Lisa Cai','1977-10-11','S','F','2018-03-14',45,'Group 41 - 60'),
(11242,209,'Larry Munoz','1977-11-11','M','M','2018-03-23',45,'Group 41 - 60'),
(11243,237,'Robin Alvarez','1977-10-09','M','F','2016-08-24',45,'Group 41 - 60'),
(11244,267,'Alexis Coleman','1977-11-26','S','F','2016-08-15',45,'Group 41 - 60'),
(11245,132,'Ricky Vazquez','1976-10-27','M','M','2017-03-29',46,'Group 41 - 60'),
(11246,147,'Latasha Rubio','1976-10-09','M','F','2017-04-05',46,'Group 41 - 60'),
(11247,242,'Claudia Zhou','1976-06-06','S','F','2016-08-21',46,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11249,178,'Cindy Patel','1975-07-13','M','F','2017-04-11',47,'Group 41 - 60'),
(11250,276,'Shannon Liu','1975-03-12','M','F','2016-09-17',47,'Group 41 - 60'),
(11252,335,'Nicholas Thompson','1952-06-07','S','M','2017-02-14',70,'Group > 60'),
(11253,69,'José Hernandez','1953-02-28','M','M','2018-09-02',69,'Group > 60'),
(11255,612,'Colin Lin','1953-04-04','M','M','2018-08-27',69,'Group > 60'),
(11256,626,'Katelyn Hernandez','1953-09-20','M','F','2018-10-17',69,'Group > 60'),
(11257,345,'Jacqueline Powell','1953-01-06','S','F','2017-02-24',69,'Group > 60'),
(11258,352,'Xavier Hill','1953-06-28','M','M','2018-11-22',69,'Group > 60'),
(11259,548,'Victoria Stewart','1985-03-27','M','F','2017-03-07',37,'Group 21 - 40'),
(11260,302,'Katelyn Kelly','1985-04-12','M','F','2018-08-09',37,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11261,359,'Stephanie Collins','1985-04-24','M','F','2017-03-30',37,'Group 21 - 40'),
(11262,60,'Jennifer Simmons','1984-05-04','M','F','2018-08-31',38,'Group 21 - 40'),
(11263,612,'Trinity Richardson','1984-09-11','M','F','2017-03-01',38,'Group 21 - 40'),
(11264,618,'Eduardo Martin','1984-06-17','S','M','2018-07-06',38,'Group 21 - 40'),
(11265,623,'Elizabeth Jones','1984-07-13','M','F','2018-07-07',38,'Group 21 - 40'),
(11266,632,'Taylor Howard','1984-05-05','S','F','2017-03-13',38,'Group 21 - 40'),
(11267,302,'David Diaz','1984-10-02','S','M','2017-03-20',38,'Group 21 - 40'),
(11268,312,'Katelyn Carter','1984-05-03','M','F','2018-11-30',38,'Group 21 - 40'),
(11270,334,'Robert Lee','1984-05-04','M','M','2017-03-13',38,'Group 21 - 40'),
(11271,360,'Danielle Reed','1984-06-05','S','F','2017-03-30',38,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11272,300,'Lauren Martinez','1976-11-10','S','F','2017-03-22',46,'Group 41 - 60'),
(11273,331,'Nathan Lal','1976-10-01','M','M','2018-11-15',46,'Group 41 - 60'),
(11274,609,'Kyle Foster','1954-04-12','M','M','2017-03-01',68,'Group > 60'),
(11275,310,'Jenny Rai','1954-01-18','M','F','2017-03-02',68,'Group > 60'),
(11276,49,'Nancy Chapman','1983-09-19','M','F','2018-08-02',39,'Group 21 - 40'),
(11277,62,'Charles Jackson','1983-06-10','M','M','2018-08-06',39,'Group 21 - 40'),
(11278,614,'Jonathan Phillips','1983-08-20','S','M','2017-03-19',39,'Group 21 - 40'),
(11279,616,'Amanda Cook','1983-09-12','M','F','2018-09-04',39,'Group 21 - 40'),
(11280,626,'Robert Collins','1983-08-21','M','M','2019-01-02',39,'Group 21 - 40'),
(11281,301,'Megan Barnes','1983-10-10','S','F','2017-03-16',39,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11282,612,'Christian Thomas','1982-01-16','M','M','2017-03-03',40,'Group 21 - 40'),
(11283,299,'Arturo Lal','1982-10-26','M','M','2018-11-30',40,'Group 21 - 40'),
(11284,307,'Theresa Serrano','1982-03-27','M','F','2018-08-10',40,'Group 21 - 40'),
(11286,374,'Hunter Griffin','1982-03-03','M','M','2017-03-24',40,'Group 21 - 40'),
(11287,49,'Henry Garcia','1981-01-16','M','M','2018-08-02',41,'Group 41 - 60'),
(11288,301,'Cindy Sanchez','1981-09-16','M','F','2018-09-06',41,'Group 41 - 60'),
(11289,315,'Maria Carter','1981-03-07','M','F','2017-03-11',41,'Group 41 - 60'),
(11290,334,'Katelyn Sanchez','1981-08-18','M','F','2017-03-23',41,'Group 41 - 60'),
(11291,335,'Jenna Wright','1981-05-05','M','F','2017-03-07',41,'Group 41 - 60'),
(11292,361,'Seth Phillips','1981-11-05','S','M','2017-03-18',41,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11293,632,'Luke Long','1975-05-27','S','M','2018-08-28',47,'Group 41 - 60'),
(11295,311,'Taylor Lewis','1974-05-16','S','F','2017-03-28',48,'Group 41 - 60'),
(11296,616,'Haley Richardson','1955-10-07','S','F','2017-03-04',67,'Group > 60'),
(11297,301,'Noah Coleman','1955-02-02','S','M','2017-03-29',67,'Group > 60'),
(11298,307,'Jon Luo','1955-03-03','M','M','2017-03-15',67,'Group > 60'),
(11299,301,'Orlando Vazquez','1956-04-01','M','M','2017-03-29',66,'Group > 60'),
(11300,54,'Fernando Barnes','1980-03-03','M','M','2018-08-04',42,'Group 41 - 60'),
(11301,607,'Cameron Rodriguez','1980-06-09','M','M','2018-12-11',42,'Group 41 - 60'),
(11302,539,'Spencer Russell','1980-12-12','S','M','2017-03-09',42,'Group 41 - 60'),
(11303,614,'Julia Coleman','1980-10-11','S','F','2017-03-05',42,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11304,547,'Julia Garcia','1980-03-17','M','F','2018-09-21',42,'Group 41 - 60'),
(11305,307,'Sean Evans','1980-06-19','M','M','2018-09-26',42,'Group 41 - 60'),
(11306,312,'Micah Zhou','1980-06-22','M','M','2019-01-01',42,'Group 41 - 60'),
(11307,314,'Hunter Rodriguez','1974-11-04','M','M','2017-03-07',48,'Group 41 - 60'),
(11311,626,'Gabrielle Lopez','1973-08-24','S','F','2018-10-20',49,'Group 41 - 60'),
(11312,626,'Sara Richardson','1973-04-03','S','F','2018-11-18',49,'Group 41 - 60'),
(11313,632,'Trevor Jenkins','1973-02-27','S','M','2018-11-08',49,'Group 41 - 60'),
(11314,618,'Mya Flores','1973-12-21','S','F','2018-08-29',49,'Group 41 - 60'),
(11315,632,'Hailey Ward','1973-10-01','S','F','2018-11-21',49,'Group 41 - 60'),
(11316,51,'Luke Allen','1973-11-17','M','M','2018-07-16',49,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11317,548,'Victoria Russell','1972-09-17','S','F','2017-03-04',50,'Group 41 - 60'),
(11319,348,'Jade Bailey','1957-04-27','M','F','2017-03-12',65,'Group > 60'),
(11320,325,'Morgan Hill','1957-06-26','M','F','2018-12-17',65,'Group > 60'),
(11321,612,'Terrance Raman','1958-07-08','M','M','2018-08-27',64,'Group > 60'),
(11322,611,'Sydney Garcia','1958-03-15','M','F','2018-09-25',64,'Group > 60'),
(11323,314,'Jose Patterson','1958-06-20','S','M','2017-03-13',64,'Group > 60'),
(11324,325,'Zachary Anderson','1959-05-14','M','M','2017-03-29',63,'Group > 60'),
(11325,637,'Elijah Ross','1959-07-02','S','M','2017-03-22',63,'Group > 60'),
(11326,300,'Rafael Xie','1959-06-26','M','M','2017-03-18',63,'Group > 60'),
(11327,301,'Jaime Moreno','1960-03-04','M','M','2017-03-29',62,'Group > 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11328,55,'Julian Griffin','1960-01-01','M','M','2018-07-09',62,'Group > 60'),
(11329,311,'Andy Alvarez','1960-07-25','S','M','2017-03-28',62,'Group > 60'),
(11330,59,'Ryan Thompson','1960-05-13','M','M','2018-08-16',62,'Group > 60'),
(11331,63,'Samantha Jenkins','1988-07-06','M','F','2018-08-11',34,'Group 21 - 40'),
(11332,153,'Deanna Ramos','1982-10-04','S','F','2017-04-17',40,'Group 21 - 40'),
(11333,261,'Emily Miller','1982-07-10','M','F','2016-09-21',40,'Group 21 - 40'),
(11334,269,'Nicole Brown','1981-03-22','M','F','2016-09-04',41,'Group 41 - 60'),
(11335,120,'Carla Raman','1981-06-24','M','F','2017-04-25',41,'Group 41 - 60'),
(11336,204,'Shaun Raji','1982-03-12','M','M','2018-03-31',40,'Group 21 - 40'),
(11337,273,'Jerome Romero','1981-09-21','M','M','2016-09-09',41,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11338,154,'Frank Navarro','1981-08-10','M','M','2017-04-13',41,'Group 41 - 60'),
(11339,202,'Dennis She','1981-07-08','S','M','2018-04-10',41,'Group 41 - 60'),
(11340,192,'Melody Munoz','1956-04-06','M','F','2018-04-30',66,'Group > 60'),
(11341,236,'Randy Zeng','1956-08-21','M','M','2016-10-12',66,'Group > 60'),
(11343,264,'Arthur Carlson','1978-09-13','M','M','2016-10-05',44,'Group 41 - 60'),
(11344,262,'Jessie Jimenez','1977-07-24','M','F','2016-11-13',45,'Group 41 - 60'),
(11345,224,'Robin Ramos','1977-03-12','S','F','2018-04-25',45,'Group 41 - 60'),
(11346,196,'Deanna Gutierrez','1975-05-22','S','F','2018-04-04',47,'Group 41 - 60'),
(11347,156,'Roy Navarro','1975-12-23','M','M','2018-09-17',47,'Group 41 - 60'),
(11348,151,'Shawn Rai','1975-09-22','M','M','2018-10-02',47,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11350,265,'Cara Zhou','1957-01-14','M','F','2018-08-09',65,'Group > 60'),
(11351,253,'Anne Ramos','1959-04-06','S','F','2016-12-13',63,'Group > 60'),
(11352,222,'Raymond Rodriguez','1960-03-07','M','M','2018-11-02',62,'Group > 60'),
(11353,271,'Carrie Ortega','1961-06-11','S','F','2016-12-13',61,'Group > 60'),
(11356,6,'Terrence Carson','2000-05-27','S','M','2016-11-10',22,'Group 21 - 40'),
(11357,21,'Ramon Ye','1999-03-23','S','M','2016-12-19',23,'Group 21 - 40'),
(11358,2,'Cynthia Malhotra','1998-11-11','S','F','2016-12-29',24,'Group 21 - 40'),
(11359,7,'Jarrod Prasad','1998-09-04','S','M','2016-12-14',24,'Group 21 - 40'),
(11360,26,'Tyrone Serrano','1998-08-02','S','M','2016-12-28',24,'Group 21 - 40'),
(11362,33,'Damien Shan','1997-11-11','M','M','2018-09-30',25,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11363,35,'Julian Ross','1997-10-20','S','M','2016-12-09',25,'Group 21 - 40'),
(11364,34,'Jennifer Collins','1999-09-23','S','F','2016-12-08',23,'Group 21 - 40'),
(11365,29,'Brittney Sun','1999-06-09','S','F','2016-12-01',23,'Group 21 - 40'),
(11366,37,'Virginia Patel','1999-10-25','M','F','2018-12-26',23,'Group 21 - 40'),
(11368,26,'Edward Miller','1998-11-25','S','M','2016-12-25',24,'Group 21 - 40'),
(11372,20,'Wendy Romero','1998-05-15','S','F','2016-12-08',24,'Group 21 - 40'),
(11374,162,'Jimmy Ortega','1963-06-28','S','M','2018-10-17',59,'Group 41 - 60'),
(11377,161,'David Robinett','1981-02-23','M','M','2018-09-01',41,'Group 41 - 60'),
(11378,184,'Shannon Liang','1980-05-22','S','F','2018-04-20',42,'Group 41 - 60'),
(11379,214,'Gary Vazquez','1979-11-18','M','M','2018-04-05',43,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11380,175,'Mitchell Kumar','1979-03-02','S','M','2017-04-13',43,'Group 41 - 60'),
(11381,249,'Meredith Raman','1979-08-22','M','F','2016-12-13',43,'Group 41 - 60'),
(11382,189,'Edward Patterson','1978-01-19','M','M','2018-05-07',44,'Group 41 - 60'),
(11387,238,'Megan Ramirez','1979-06-02','S','F','2017-01-26',43,'Group 41 - 60'),
(11388,279,'Joseph Martin','1979-07-24','M','M','2017-01-03',43,'Group 41 - 60'),
(11392,131,'Willie Zhao','1990-02-07','S','M','2018-09-30',32,'Group 21 - 40'),
(11394,259,'George McDonald','1989-10-23','S','M','2017-01-04',33,'Group 21 - 40'),
(11395,118,'Beth Gutierrez','1990-10-18','S','F','2017-05-17',32,'Group 21 - 40'),
(11398,261,'Colin Nath','1989-09-09','S','M','2017-01-03',33,'Group 21 - 40'),
(11399,202,'Brenda Mehta','1989-08-04','S','F','2018-10-15',33,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11400,251,'Franklin Raji','1989-04-19','S','M','2017-01-15',33,'Group 21 - 40'),
(11401,204,'Linda Navarro','1989-08-26','M','F','2018-05-01',33,'Group 21 - 40'),
(11402,183,'Kelli Cai','1989-11-20','M','F','2018-05-11',33,'Group 21 - 40'),
(11403,179,'Nancy Schmidt','1989-01-09','S','F','2018-05-01',33,'Group 21 - 40'),
(11404,133,'Megan Taylor','1972-01-01','S','F','2018-08-14',50,'Group 41 - 60'),
(11405,143,'Bonnie Goel','1972-02-17','S','F','2018-10-02',50,'Group 41 - 60'),
(11406,199,'Latoya Xu','1972-07-03','M','F','2018-05-08',50,'Group 41 - 60'),
(11407,170,'Mario She','1972-04-02','M','M','2018-12-25',50,'Group 41 - 60'),
(11408,257,'Darren Gill','1973-05-14','M','M','2018-09-06',49,'Group 41 - 60'),
(11409,208,'Jacqueline Hayes','1988-03-05','S','F','2018-05-21',34,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11410,201,'Maurice Goel','1988-08-25','M','M','2018-05-17',34,'Group 21 - 40'),
(11412,121,'Sydney Bryant','1974-04-09','S','F','2017-05-08',48,'Group 41 - 60'),
(11413,238,'Megan Stewart','1974-04-15','M','F','2017-02-10',48,'Group 41 - 60'),
(11414,241,'Ian Richardson','1974-03-18','S','M','2017-02-13',48,'Group 41 - 60'),
(11416,185,'Katrina Becker','1965-03-19','M','F','2018-05-11',57,'Group 41 - 60'),
(11417,222,'Lacey Zheng','1965-02-26','M','F','2018-05-08',57,'Group 41 - 60'),
(11419,273,'Kyle Scott','1965-02-18','M','M','2018-09-13',57,'Group 41 - 60'),
(11420,189,'Jordan Turner','1966-07-12','M','M','2018-05-05',56,'Group 41 - 60'),
(11421,172,'Amy Sun','1966-07-19','M','F','2017-05-06',56,'Group 41 - 60'),
(11422,268,'Dustin Deng','1966-09-01','M','M','2017-02-22',56,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11423,147,'Jasmine Stewart','1974-11-05','M','F','2017-06-12',48,'Group 41 - 60'),
(11424,164,'Pamela Garcia','1973-12-07','M','F','2018-10-23',49,'Group 41 - 60'),
(11425,184,'Ariana Gray','1974-08-06','M','F','2018-05-26',48,'Group 41 - 60'),
(11426,156,'Kristopher Mehta','1973-10-02','M','M','2018-10-11',49,'Group 41 - 60'),
(11427,168,'Desiree Dominguez','1973-12-18','M','F','2017-06-22',49,'Group 41 - 60'),
(11428,173,'Deanna Perez','1973-08-22','S','F','2017-06-07',49,'Group 41 - 60'),
(11429,218,'Marco Lopez','1972-07-16','M','M','2018-06-17',50,'Group 41 - 60'),
(11430,155,'Casey Yuan','1972-03-24','M','F','2018-09-20',50,'Group 41 - 60'),
(11431,120,'Bryant Garcia','1972-10-27','M','M','2017-06-23',50,'Group 41 - 60'),
(11432,206,'Dominique Prasad','1971-09-11','M','F','2018-06-13',51,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11433,224,'Maurice Shan','1971-09-02','M','M','2018-06-05',51,'Group 41 - 60'),
(11434,274,'Andre Lopez','1971-05-06','M','M','2018-12-17',51,'Group 41 - 60'),
(11436,273,'Taylor Cox','1970-09-18','M','F','2018-11-23',52,'Group 41 - 60'),
(11438,162,'Jenny Nara','1969-10-14','M','F','2018-08-09',53,'Group 41 - 60'),
(11439,217,'Janet Munoz','1968-05-17','M','F','2018-06-02',54,'Group 41 - 60'),
(11440,187,'Sergio Weber','1967-09-27','M','M','2018-09-28',55,'Group 41 - 60'),
(11443,31,'Grace Griffin','1996-05-22','S','F','2016-12-08',26,'Group 21 - 40'),
(11444,32,'Tina Mehta','1996-04-28','M','F','2016-12-02',26,'Group 21 - 40'),
(11445,15,'Kari Kim','1994-07-21','S','F','2016-12-07',28,'Group 21 - 40'),
(11446,5,'Bethany Chander','1994-08-12','S','F','2016-12-19',28,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11447,25,'Jennifer Roberts','1994-08-16','M','F','2016-12-29',28,'Group 21 - 40'),
(11448,35,'Kyle Patterson','1995-04-28','S','M','2016-12-17',27,'Group 21 - 40'),
(11449,37,'Alvin Hu','1995-02-02','M','M','2016-12-20',27,'Group 21 - 40'),
(11450,28,'Brett Mehta','1995-11-12','S','M','2016-12-30',27,'Group 21 - 40'),
(11451,10,'Ruben Muñoz','1994-11-09','S','M','2017-01-29',28,'Group 21 - 40'),
(11452,21,'Erika Rubio','1993-11-05','S','F','2017-01-11',29,'Group 21 - 40'),
(11453,31,'Stanley Malhotra','1993-08-21','S','M','2017-01-15',29,'Group 21 - 40'),
(11454,35,'Melinda Navarro','1994-04-22','S','F','2017-01-31',28,'Group 21 - 40'),
(11455,36,'Ross Sanz','1994-04-21','M','M','2017-01-01',28,'Group 21 - 40'),
(11456,17,'Jon Gao','1994-07-08','M','M','2017-01-17',28,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11457,19,'Jaime Gutierrez','1993-05-21','M','F','2017-01-17',29,'Group 21 - 40'),
(11458,16,'Bianca Liu','1993-04-05','M','F','2018-10-01',29,'Group 21 - 40'),
(11459,13,'Tasha Deng','1992-10-13','S','F','2017-01-27',30,'Group 21 - 40'),
(11460,33,'Melvin Chande','1992-10-07','S','M','2017-01-21',30,'Group 21 - 40'),
(11461,6,'Victor Jimenez','1992-03-25','S','M','2017-01-31',30,'Group 21 - 40'),
(11462,8,'Laura Lin','1992-01-19','M','F','2017-01-16',30,'Group 21 - 40'),
(11463,28,'Alisha Beck','1992-03-12','M','F','2018-09-06',30,'Group 21 - 40'),
(11464,38,'Alejandro Huang','1991-11-16','M','M','2017-01-22',31,'Group 21 - 40'),
(11465,23,'Louis Luo','1991-02-19','M','M','2017-01-14',31,'Group 21 - 40'),
(11466,6,'Grant Tang','1991-08-03','M','M','2018-11-23',31,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11468,278,'Jaclyn Andersen','1995-06-18','M','F','2017-02-08',27,'Group 21 - 40'),
(11470,177,'Jay Suarez','1993-09-25','S','M','2017-07-25',29,'Group 21 - 40'),
(11471,207,'Latasha Suarez','1993-09-25','S','F','2018-11-18',29,'Group 21 - 40'),
(11472,24,'Kenneth Kumar','1983-04-03','S','M','2017-01-26',39,'Group 21 - 40'),
(11473,221,'Grace Henderson','2000-08-02','S','F','2018-12-04',22,'Group 21 - 40'),
(11475,251,'Cesar Subram','1998-10-09','S','M','2018-10-25',24,'Group 21 - 40'),
(11478,218,'Billy Hernandez','1993-02-25','S','M','2018-10-21',29,'Group 21 - 40'),
(11479,182,'Darryl Wu','1993-04-22','M','M','2018-06-08',29,'Group 21 - 40'),
(11480,224,'Colleen Ma','1993-03-11','M','F','2018-06-28',29,'Group 21 - 40'),
(11481,156,'Erica Hu','1993-05-23','M','F','2017-07-30',29,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11482,272,'Adrienne Torres','1992-07-19','S','F','2017-03-11',30,'Group 21 - 40'),
(11483,199,'Calvin Chande','1992-05-22','M','M','2018-06-25',30,'Group 21 - 40'),
(11484,171,'Erick Sai','1992-03-06','S','M','2017-07-05',30,'Group 21 - 40'),
(11485,237,'Donald Chandra','1992-08-07','M','M','2017-03-17',30,'Group 21 - 40'),
(11488,256,'Jermaine Lopez','1991-09-21','S','M','2017-04-30',31,'Group 21 - 40'),
(11489,262,'Deborah Goel','1991-03-07','S','F','2017-04-30',31,'Group 21 - 40'),
(11490,217,'Danny Rubio','1991-01-06','S','M','2018-10-06',31,'Group 21 - 40'),
(11491,255,'Andre Perez','1991-04-06','M','M','2017-05-10',31,'Group 21 - 40'),
(11492,115,'Terrence Chander','1991-11-19','S','M','2017-08-14',31,'Group 21 - 40'),
(11493,255,'Dawn Wu','1990-12-02','S','F','2017-05-17',32,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11494,267,'Jimmy Gutierrez','1990-07-28','S','M','2017-06-25',32,'Group 21 - 40'),
(11496,272,'Gary Ortega','1990-10-17','S','M','2017-06-02',32,'Group 21 - 40'),
(11498,49,'Arturo Sun','1994-01-15','S','M','2018-09-01',28,'Group 21 - 40'),
(11499,311,'Pedro Vance','1994-11-14','S','M','2018-10-08',28,'Group 21 - 40'),
(11500,52,'Sarah Simmons','1994-09-18','S','F','2018-08-04',28,'Group 21 - 40'),
(11501,49,'Brandy Chandra','1995-07-07','S','F','2018-09-28',27,'Group 21 - 40'),
(11502,63,'Jared Peterson','1995-03-07','S','M','2018-08-03',27,'Group 21 - 40'),
(11503,312,'Dennis Wu','1950-10-13','M','M','2018-11-27',72,'Group > 60'),
(11504,315,'Jordan Baker','1951-04-20','M','F','2018-11-02',71,'Group > 60'),
(11505,43,'Jasmine Powell','1986-07-07','S','F','2018-08-26',36,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11506,60,'Nicholas Brown','1986-05-17','S','M','2018-09-09',36,'Group 21 - 40'),
(11507,69,'Isabella Russell','1986-11-20','S','F','2018-08-21',36,'Group 21 - 40'),
(11508,626,'Elizabeth Wilson','1986-07-07','S','F','2018-11-03',36,'Group 21 - 40'),
(11510,54,'Seth Roberts','1973-07-13','M','M','2018-09-13',49,'Group 41 - 60'),
(11511,543,'Caleb Perry','1973-06-14','M','M','2018-09-14',49,'Group 41 - 60'),
(11513,62,'Alyssa Howard','1974-09-27','S','F','2018-12-10',48,'Group 41 - 60'),
(11514,642,'Dalton Diaz','1974-04-20','M','M','2018-12-26',48,'Group 41 - 60'),
(11515,301,'Shannon Huang','1974-02-25','M','F','2017-03-03',48,'Group 41 - 60'),
(11516,310,'Mya Gonzales','1974-10-21','M','F','2017-03-18',48,'Group 41 - 60'),
(11517,355,'Katherine Bryant','1974-06-20','M','F','2018-12-28',48,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11519,49,'Jerome Navarro','1975-03-17','M','M','2018-09-14',47,'Group 41 - 60'),
(11520,60,'Jada Morgan','1975-04-11','M','F','2018-08-26',47,'Group 41 - 60'),
(11521,644,'Ariana Peterson','1975-12-09','M','F','2018-09-06',47,'Group 41 - 60'),
(11522,546,'Christian Hughes','1975-12-23','M','M','2017-03-06',47,'Group 41 - 60'),
(11523,54,'Lucas Taylor','1976-08-10','M','M','2018-08-19',46,'Group 41 - 60'),
(11525,543,'Ariana Cook','1976-01-09','M','F','2017-03-09',46,'Group 41 - 60'),
(11526,70,'Katherine Diaz','1976-08-06','M','F','2018-08-07',46,'Group 41 - 60'),
(11527,361,'Jenna Green','1976-06-04','M','F','2018-08-11',46,'Group 41 - 60'),
(11528,325,'Joan Washington','1977-08-19','M','F','2017-03-15',45,'Group 41 - 60'),
(11529,547,'Austin Bryant','1977-11-16','M','M','2017-03-27',45,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11530,54,'Andrew Martinez','1977-07-26','M','M','2018-08-01',45,'Group 41 - 60'),
(11531,300,'Nina Yuan','1977-01-07','M','F','2017-03-02',45,'Group 41 - 60'),
(11532,634,'Lauren Miller','1977-02-26','M','F','2018-10-07',45,'Group 41 - 60'),
(11533,280,'Ebony Gill','1977-07-21','M','F','2018-11-15',45,'Group 41 - 60'),
(11534,337,'Cameron Lewis','1978-11-13','S','M','2017-03-21',44,'Group 41 - 60'),
(11535,543,'Devin Nelson','1978-07-03','M','M','2017-03-05',44,'Group 41 - 60'),
(11536,322,'Logan Chow','1978-04-17','M','M','2017-03-27',44,'Group 41 - 60'),
(11537,310,'Dakota Ross','1978-03-24','M','M','2017-03-24',44,'Group 41 - 60'),
(11538,352,'Nicole Taylor','1979-08-28','S','F','2017-03-19',43,'Group 41 - 60'),
(11539,311,'Justin Washington','1979-08-22','M','M','2017-03-26',43,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11540,312,'Alberto Navarro','1979-01-28','S','M','2017-03-16',43,'Group 41 - 60'),
(11541,547,'Aidan Ross','1979-04-12','S','M','2017-03-15',43,'Group 41 - 60'),
(11542,278,'Alejandro Tang','1988-09-10','S','M','2018-11-12',34,'Group 21 - 40'),
(11546,189,'Christine Chande','1988-03-14','M','F','2018-06-05',34,'Group 21 - 40'),
(11547,201,'Cindy Sai','1988-03-08','M','F','2018-06-28',34,'Group 21 - 40'),
(11548,230,'Raymond Sanchez','1988-10-12','S','M','2017-06-04',34,'Group 21 - 40'),
(11549,257,'Crystal Liang','1988-09-06','M','F','2017-06-23',34,'Group 21 - 40'),
(11550,263,'Deb Torres','1988-08-08','S','F','2017-07-23',34,'Group 21 - 40'),
(11551,215,'Shannon Alvarez','1987-05-25','S','M','2018-09-02',35,'Group 21 - 40'),
(11554,224,'Sydney Simmons','1946-09-28','S','F','2018-11-09',76,'Group > 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11555,237,'Alexandria Henderson','1946-07-08','M','F','2018-11-09',76,'Group > 60'),
(11561,159,'Briana Dominguez','1986-07-24','S','F','2017-08-22',36,'Group 21 - 40'),
(11562,158,'Jarrod Gonzalez','1986-04-19','M','M','2018-12-28',36,'Group 21 - 40'),
(11564,146,'Jorge Liang','1986-07-12','S','M','2017-08-19',36,'Group 21 - 40'),
(11566,226,'April Shan','1987-09-02','M','F','2018-08-01',35,'Group 21 - 40'),
(11567,165,'Carla Perez','1987-09-23','M','F','2018-09-16',35,'Group 21 - 40'),
(11568,236,'Alexia Foster','1986-10-23','S','F','2017-07-13',36,'Group 21 - 40'),
(11570,124,'Kristin Andersen','1986-01-22','M','F','2017-09-26',36,'Group 21 - 40'),
(11571,183,'Joel Sai','1986-05-18','M','M','2018-06-15',36,'Group 21 - 40'),
(11572,186,'Billy Moreno','1986-03-15','M','M','2018-06-12',36,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11575,243,'Jackson Campbell','1985-04-21','S','M','2017-07-23',37,'Group 21 - 40'),
(11603,244,'Geoffrey Gonzalez','1997-02-06','S','M','2017-07-21',25,'Group 21 - 40'),
(11604,275,'Edgar Sanchez','1997-06-03','S','M','2017-07-06',25,'Group 21 - 40'),
(11609,277,'Eugene Ye','1996-06-26','S','M','2017-07-31',26,'Group 21 - 40'),
(11610,269,'Blake Collins','1995-04-23','S','M','2017-07-13',27,'Group 21 - 40'),
(11612,230,'Keith Andersen','1994-10-11','S','M','2017-08-05',28,'Group 21 - 40'),
(11750,10,'Latoya She','1988-03-24','M','F','2017-01-14',34,'Group 21 - 40'),
(11751,36,'Victoria Gonzales','1990-07-17','M','F','2017-01-08',32,'Group 21 - 40'),
(11754,7,'Janet Ortega','1990-07-08','M','F','2017-01-16',32,'Group 21 - 40'),
(11756,17,'Linda Ortega','1988-09-13','S','F','2017-01-28',34,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11759,28,'Dawn Nath','1989-11-22','M','F','2017-01-10',33,'Group 21 - 40'),
(11761,31,'Edgar Mehta','1987-04-19','S','M','2017-02-05',35,'Group 21 - 40'),
(11762,19,'Randall Gomez','1987-08-24','M','M','2017-02-07',35,'Group 21 - 40'),
(11764,10,'Jessie Ramos','1987-07-17','S','F','2017-03-12',35,'Group 21 - 40'),
(11765,11,'Marc Torres','1986-10-11','M','M','2017-03-15',36,'Group 21 - 40'),
(11766,38,'Candace Raman','1986-07-04','S','F','2017-03-22',36,'Group 21 - 40'),
(11767,24,'Meagan Madan','1986-05-24','S','F','2017-03-20',36,'Group 21 - 40'),
(11768,30,'Clayton Nara','1986-10-08','M','M','2017-03-06',36,'Group 21 - 40'),
(11892,14,'Julio Ortega','1989-10-08','M','M','2017-03-07',33,'Group 21 - 40'),
(11893,18,'Orlando Carlson','1989-02-09','M','M','2017-03-03',33,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11894,25,'Ann Gonzalez','1989-05-04','M','F','2017-03-25',33,'Group 21 - 40'),
(11895,23,'Dustin Chander','1989-07-21','M','M','2017-03-15',33,'Group 21 - 40'),
(11896,16,'Frank Carlson','1989-11-18','M','M','2017-03-04',33,'Group 21 - 40'),
(11897,38,'Orlando Ashe','1988-11-28','S','M','2017-03-02',34,'Group 21 - 40'),
(11898,20,'Angela Henderson','1990-07-03','M','F','2017-03-17',32,'Group 21 - 40'),
(11899,36,'Brenda Perez','1990-09-16','S','F','2017-03-07',32,'Group 21 - 40'),
(11900,10,'Byron Carlson','1990-03-07','S','M','2017-03-24',32,'Group 21 - 40'),
(11901,3,'Stacy Alvarez','1988-02-19','S','F','2017-03-13',34,'Group 21 - 40'),
(11903,21,'Kate Raji','1989-04-27','S','F','2017-03-24',33,'Group 21 - 40'),
(11904,34,'Kaylee Cook','1989-11-09','S','F','2017-03-20',33,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11905,31,'Isaiah Ramirez','1989-06-16','S','M','2017-03-01',33,'Group 21 - 40'),
(11906,20,'Gabriella Sanders','1987-02-18','M','F','2017-03-13',35,'Group 21 - 40'),
(11907,19,'Sarah Garcia','1987-09-08','S','F','2017-03-31',35,'Group 21 - 40'),
(11908,38,'Rafael Tang','1986-07-11','S','M','2017-03-22',36,'Group 21 - 40'),
(11909,26,'Nichole She','1986-02-10','M','F','2017-03-23',36,'Group 21 - 40'),
(11910,4,'Jaclyn Zheng','1986-06-12','M','F','2017-04-11',36,'Group 21 - 40'),
(11912,27,'Rachael Sai','1985-12-17','S','F','2017-04-29',37,'Group 21 - 40'),
(11914,13,'Meagan Rana','1988-05-08','S','F','2017-04-20',34,'Group 21 - 40'),
(11915,13,'Philip Carlson','1988-03-16','S','M','2017-04-04',34,'Group 21 - 40'),
(11916,40,'Joe Rana','1985-09-07','S','M','2017-04-03',37,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11917,3,'Roy Sanz','1985-10-22','S','M','2017-04-29',37,'Group 21 - 40'),
(11918,2,'Kaylee Hill','1984-03-03','M','F','2017-04-15',38,'Group 21 - 40'),
(11919,26,'Warren Andersen','1984-02-18','M','M','2017-04-07',38,'Group 21 - 40'),
(11920,20,'Adrienne Gomez','1984-02-28','S','F','2017-04-12',38,'Group 21 - 40'),
(11942,10,'George Gonzalez','1969-06-13','M','M','2017-04-17',53,'Group 41 - 60'),
(11943,40,'Dawn Huang','1969-02-27','M','F','2017-04-20',53,'Group 41 - 60'),
(11944,15,'Rachael Rodriguez','1970-10-15','S','F','2017-04-21',52,'Group 41 - 60'),
(11946,18,'Brandy Saunders','1971-01-03','S','F','2017-04-23',51,'Group 41 - 60'),
(11947,14,'Jenny Zheng','1971-10-22','S','F','2017-04-15',51,'Group 41 - 60'),
(11952,34,'Dorothy Robinson','1974-09-23','S','M','2017-04-07',48,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11963,2,'Antonio Patterson','1975-06-13','M','M','2017-04-24',47,'Group 41 - 60'),
(11964,22,'Sharon Salavaria','1976-02-17','S','M','2017-04-16',46,'Group 41 - 60'),
(11967,25,'Latasha Munoz','1977-02-10','S','F','2017-04-25',45,'Group 41 - 60'),
(11968,9,'Kelsey Becker','1978-10-21','S','F','2017-04-30',44,'Group 41 - 60'),
(11969,30,'Randy Xu','1978-07-25','S','M','2017-04-21',44,'Group 41 - 60'),
(11976,12,'Audrey Ramos','1979-05-26','S','F','2017-04-27',43,'Group 41 - 60'),
(11977,10,'Bonnie Jai','1979-05-23','M','F','2017-05-04',43,'Group 41 - 60'),
(11986,34,'Max Alvarez','1983-07-24','S','M','2017-05-25',39,'Group 21 - 40'),
(11988,4,'Kathryn Chapman','1982-08-20','S','F','2017-05-13',40,'Group 21 - 40'),
(11989,24,'Kara Anand','1982-03-28','S','F','2017-05-06',40,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11990,10,'Joanna Vazquez','1982-07-15','S','F','2017-05-16',40,'Group 21 - 40'),
(11994,27,'Leah Hu','1986-10-22','S','F','2017-05-28',36,'Group 21 - 40'),
(11996,21,'Veronica Srini','1980-08-02','S','F','2017-05-07',42,'Group 41 - 60'),
(11997,2,'Kristina Kapoor','1980-04-07','M','F','2017-05-08',42,'Group 41 - 60'),
(11998,24,'Donna Sharma','1980-08-10','M','F','2017-05-19',42,'Group 41 - 60'),
(11999,10,'Johnny Shan','1980-06-05','M','M','2017-05-13',42,'Group 41 - 60'),
(12000,21,'Ashley Russell','1985-03-12','S','F','2017-05-19',37,'Group 21 - 40'),
(12001,4,'Shannon Yang','1985-07-06','S','F','2017-05-17',37,'Group 21 - 40'),
(12002,5,'Adriana Lopez','1984-02-06','S','F','2017-05-27',38,'Group 21 - 40'),
(12003,25,'Audrey Munoz','1983-03-11','S','F','2017-05-09',39,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(12004,36,'Jarrod Suri','1983-12-20','S','M','2017-05-11',39,'Group 21 - 40'),
(12005,24,'Gilbert Shen','1982-07-17','M','M','2017-05-24',40,'Group 21 - 40'),
(12007,20,'Shannon Sun','1981-07-26','M','F','2017-06-09',41,'Group 41 - 60'),
(12009,11,'Ann Martinez','1977-08-03','S','F','2017-06-13',45,'Group 41 - 60'),
(12010,27,'Max Serrano','1977-02-26','M','M','2017-06-23',45,'Group 41 - 60'),
(12011,32,'Morgan Johnson','1955-02-17','S','F','2017-06-03',67,'Group > 60'),
(12037,21,'Patricia Chapman','1963-09-14','S','F','2017-06-29',59,'Group 41 - 60'),
(12039,32,'Ricardo Nath','1963-02-13','M','M','2017-06-29',59,'Group 41 - 60'),
(12123,275,'Wesley Liang','1978-06-14','M','M','2017-08-13',44,'Group 41 - 60'),
(12124,192,'Brandi Gill','1977-02-08','S','F','2016-08-01',45,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(12125,149,'Diana Ortega','1977-01-12','M','F','2017-11-16',45,'Group 41 - 60'),
(12128,123,'Kristy Munoz','1976-12-16','M','F','2017-11-02',46,'Group 41 - 60'),
(12129,158,'Wendy Alvarez','1976-09-21','M','F','2017-11-26',46,'Group 41 - 60'),
(12130,151,'Suzanne Zhou','1976-08-12','S','F','2017-11-09',46,'Group 41 - 60'),
(12131,186,'Randall Dominguez','1975-10-17','M','M','2016-08-24',47,'Group 41 - 60'),
(12132,224,'Kaitlyn Henderson','1975-11-19','M','F','2016-08-02',47,'Group 41 - 60'),
(12133,242,'Colleen Xie','1975-12-26','M','F','2017-08-14',47,'Group 41 - 60'),
(12210,247,'Alan He','1998-09-25','M','M','2017-09-16',24,'Group 21 - 40'),
(12214,243,'Julie Raje','1982-09-20','M','F','2017-09-08',40,'Group 21 - 40'),
(12215,254,'Karla She','1982-12-14','M','F','2017-09-11',40,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(12216,258,'Gerald Rodriguez','1982-04-02','M','M','2017-09-26',40,'Group 21 - 40'),
(12222,248,'Jenny Xu','1981-03-20','M','F','2017-09-14',41,'Group 41 - 60'),
(12239,254,'Alberto Ramos','1962-06-01','M','M','2017-09-24',60,'Group 41 - 60'),
(12263,259,'Emmanuel Garcia','1980-03-15','S','M','2017-09-29',42,'Group 41 - 60'),
(12292,229,'Nicolas Kumar','1964-03-24','M','M','2017-11-21',58,'Group 41 - 60'),
(12296,211,'Francisco Sara','1965-02-15','M','M','2016-11-19',57,'Group 41 - 60'),
(12299,274,'Walter Serrano','1965-06-10','M','M','2017-11-10',57,'Group 41 - 60'),
(12300,180,'Adriana Gonzalez','1966-07-18','S','F','2016-11-24',56,'Group 41 - 60'),
(12301,223,'Nichole Nara','1966-12-05','S','F','2016-11-10',56,'Group 41 - 60'),
(12305,234,'Xavier Bailey','1974-07-06','M','M','2017-12-29',48,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(12307,226,'Brad She','1974-11-13','M','M','2016-11-29',48,'Group 41 - 60'),
(12308,184,'Margaret He','1974-04-25','M','F','2016-12-04',48,'Group 41 - 60'),
(12321,211,'Rosa Hu','1971-02-15','M','F','2016-12-03',51,'Group 41 - 60'),
(12337,6,'Dustin Goldstein','1995-10-09','S','M','2017-06-07',27,'Group 21 - 40'),
(12338,38,'Monica Vance','1996-07-08','S','F','2017-06-26',26,'Group 21 - 40'),
(12339,29,'Clayton Jai','1996-07-08','S','M','2017-07-16',26,'Group 21 - 40'),
(12340,21,'Stacy Diaz','1996-11-05','S','F','2017-07-26',26,'Group 21 - 40'),
(12341,5,'Katie Kumar','1996-09-09','M','F','2017-07-07',26,'Group 21 - 40'),
(12342,18,'Morgan Young','1995-03-09','M','F','2017-07-13',27,'Group 21 - 40'),
(12343,9,'Gloria Ruiz','1994-06-04','M','F','2017-07-20',28,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(12346,15,'Wesley Gao','1995-05-22','S','M','2017-07-07',27,'Group 21 - 40'),
(12347,40,'Summer Madan','1995-02-21','M','F','2017-07-16',27,'Group 21 - 40'),
(12348,6,'Jimmy Vazquez','1994-02-24','M','M','2017-07-31',28,'Group 21 - 40'),
(12349,15,'Lacey Yuan','1994-07-26','S','F','2017-07-01',28,'Group 21 - 40'),
(12350,34,'Logan Hernandez','1993-02-25','M','M','2017-07-09',29,'Group 21 - 40'),
(12353,24,'Joe Ramos','1993-10-20','M','M','2017-07-28',29,'Group 21 - 40'),
(12354,34,'Lance Ortega','1993-08-07','M','M','2017-07-06',29,'Group 21 - 40'),
(12355,19,'Monique Ortega','1993-03-23','S','F','2017-07-01',29,'Group 21 - 40'),
(12356,13,'Julia Wood','1991-08-22','S','F','2017-07-12',31,'Group 21 - 40'),
(12358,9,'Lacey Raje','1990-02-26','M','F','2017-07-31',32,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(12360,12,'Mario Goel','1991-07-26','S','M','2017-07-19',31,'Group 21 - 40'),
(12398,187,'Ashley Clark','1991-07-12','S','F','2016-12-18',31,'Group 21 - 40'),
(12510,205,'Roberto Sanz','1982-11-20','M','M','2017-02-27',40,'Group 21 - 40'),
(12607,213,'Tamara Zhu','1980-09-22','M','F','2017-03-04',42,'Group 41 - 60'),
(12620,190,'Maurice Lal','1989-04-17','M','M','2017-03-23',33,'Group 21 - 40'),
(12621,198,'Barry Martinez','1989-12-12','M','M','2017-03-28',33,'Group 21 - 40'),
(12667,31,'Maria Wood','1996-11-22','M','F','2017-08-04',26,'Group 21 - 40'),
(12668,19,'Melissa Patterson','1996-04-26','S','F','2017-08-13',26,'Group 21 - 40'),
(12669,2,'Irving Schmidt','1996-03-04','S','M','2017-08-10',26,'Group 21 - 40'),
(12670,18,'Sarah Martinez','1995-07-21','S','F','2017-08-26',27,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(12671,26,'Alan Huang','1994-02-11','S','M','2017-08-12',28,'Group 21 - 40'),
(12673,35,'Colin Stone','1995-08-28','M','M','2017-08-27',27,'Group 21 - 40'),
(12674,26,'Jimmy Travers','1995-07-27','M','M','2017-08-23',27,'Group 21 - 40'),
(12675,37,'Holly Fernandez','1993-10-05','S','F','2017-08-13',29,'Group 21 - 40'),
(12676,32,'Michele Madan','1994-06-28','S','F','2017-08-21',28,'Group 21 - 40'),
(12677,2,'Cedric Liu','1994-11-05','M','M','2017-08-07',28,'Group 21 - 40'),
(12680,18,'George Sanchez','1992-07-02','S','M','2017-08-24',30,'Group 21 - 40'),
(12681,21,'Christy Chow','1992-03-08','S','F','2017-08-29',30,'Group 21 - 40'),
(12683,25,'Laura Zhou','1993-02-01','S','F','2017-08-21',29,'Group 21 - 40'),
(12684,4,'Shaun Shen','1993-05-23','M','M','2017-08-09',29,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(12685,40,'Jaclyn Xu','1992-03-22','M','F','2017-08-01',30,'Group 21 - 40'),
(12686,32,'Trisha Zhou','1992-10-18','S','F','2017-08-31',30,'Group 21 - 40'),
(12687,2,'Marshall Li','1992-04-20','S','M','2017-09-18',30,'Group 21 - 40'),
(12688,24,'Stacy Navarro','1992-08-04','S','F','2017-09-09',30,'Group 21 - 40'),
(12689,21,'Tamara Pal','1992-10-05','S','F','2017-09-24',30,'Group 21 - 40'),
(12693,14,'Ruth Gonzalez','1991-01-09','M','F','2017-09-03',31,'Group 21 - 40'),
(12694,17,'Jay Arthur','1992-01-11','S','M','2017-09-13',30,'Group 21 - 40'),
(12698,13,'Mohamed Pal','1990-05-14','M','M','2017-09-14',32,'Group 21 - 40'),
(12699,35,'Amy Chow','1990-03-18','M','F','2017-09-15',32,'Group 21 - 40'),
(12700,24,'Mindy Kumar','1991-03-20','M','F','2017-10-30',31,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(12701,10,'Gary Gutierrez','1991-10-18','M','M','2017-10-19',31,'Group 21 - 40'),
(12702,27,'Yolanda Shan','1991-09-07','M','F','2017-10-20',31,'Group 21 - 40'),
(12703,6,'Renee Suarez','1991-06-20','M','F','2017-10-06',31,'Group 21 - 40'),
(12705,30,'Andre Garcia','1989-08-10','M','M','2017-10-01',33,'Group 21 - 40'),
(12706,24,'Louis Liang','1989-01-13','M','M','2017-10-14',33,'Group 21 - 40'),
(12750,212,'Teresa Vazquez','1990-08-11','S','F','2017-04-12',32,'Group 21 - 40'),
(12754,223,'Lindsey Deng','1990-06-20','M','F','2017-04-08',32,'Group 21 - 40'),
(12805,215,'Marvin Moreno','1988-06-13','M','M','2017-04-26',34,'Group 21 - 40'),
(12987,39,'Felicia Moreno','1989-05-12','M','F','2017-10-18',33,'Group 21 - 40'),
(12988,5,'Barbara Goel','1989-01-26','S','F','2017-10-02',33,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(12989,3,'Carly Goel','1989-11-13','M','F','2017-10-02',33,'Group 21 - 40'),
(12990,25,'Leslie Hernandez','1989-10-15','S','F','2017-10-19',33,'Group 21 - 40'),
(12991,3,'Jésus Serrano','1988-03-12','M','M','2017-10-19',34,'Group 21 - 40'),
(12994,27,'Anna Martinez','1990-04-09','S','F','2017-10-29',32,'Group 21 - 40'),
(12995,13,'Grant Nara','1990-09-02','M','M','2017-10-18',32,'Group 21 - 40'),
(12996,28,'Jaclyn Liu','1990-05-13','M','F','2017-10-23',32,'Group 21 - 40'),
(12998,8,'Mayra Mehta','1988-01-11','S','F','2017-10-02',34,'Group 21 - 40'),
(12999,7,'Nichole Shen','1987-06-20','S','F','2017-10-24',35,'Group 21 - 40'),
(13000,31,'Rafael Raje','1989-09-20','M','M','2017-10-11',33,'Group 21 - 40'),
(13001,39,'Clarence Zhang','1989-09-06','S','M','2017-10-25',33,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(13006,34,'Whitney Rana','1986-04-21','S','F','2017-10-25',36,'Group 21 - 40'),
(13007,27,'Brooke Ward','1985-10-05','S','F','2017-10-07',37,'Group 21 - 40'),
(13010,27,'Erica Ye','1985-08-16','M','F','2017-10-29',37,'Group 21 - 40'),
(13011,34,'Anne Ortega','1985-05-04','S','F','2017-10-21',37,'Group 21 - 40'),
(13012,4,'Krystal Hu','1985-09-24','S','F','2017-10-21',37,'Group 21 - 40'),
(13038,5,'Wilson Pais','1970-02-01','M','M','2017-10-13',52,'Group 41 - 60'),
(13049,23,'Autumn Wang','1973-07-06','M','F','2017-10-24',49,'Group 41 - 60'),
(13051,4,'Ethan Jones','1974-11-27','S','M','2017-10-13',48,'Group 41 - 60'),
(13075,32,'Kelvin Lin','1975-04-11','M','M','2017-10-23',47,'Group 41 - 60'),
(13076,30,'Craig Munoz','1975-03-03','S','M','2017-10-23',47,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(13077,14,'Alejandro Goel','1976-05-24','S','M','2017-10-24',46,'Group 41 - 60'),
(13078,15,'Michele Chande','1976-01-22','S','F','2017-10-08',46,'Group 41 - 60'),
(13079,38,'Edwin Bhat','1977-02-26','S','M','2017-10-26',45,'Group 41 - 60'),
(13080,30,'Denise Mehta','1977-05-18','S','F','2017-11-06',45,'Group 41 - 60'),
(13081,25,'Krista Ruiz','1977-03-24','S','F','2017-11-28',45,'Group 41 - 60'),
(13082,33,'Juan Peterson','1978-02-24','S','M','2017-11-08',44,'Group 41 - 60'),
(13089,27,'Elizabeth Alexander','1979-09-01','M','F','2017-11-20',43,'Group 41 - 60'),
(13090,27,'Wayne Tang','1979-06-01','S','M','2017-12-24',43,'Group 41 - 60'),
(13091,21,'Deanna Martin','1979-08-11','S','F','2017-12-26',43,'Group 41 - 60'),
(13103,34,'Brendan Raji','1983-08-02','S','M','2017-12-28',39,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(13104,3,'Gregory Becker','1983-04-12','S','M','2017-12-12',39,'Group 21 - 40'),
(13257,120,'Jon Chander','1977-07-06','M','M','2016-07-16',45,'Group 41 - 60'),
(13258,133,'Anne Dominguez','1977-03-03','M','F','2016-07-08',45,'Group 41 - 60'),
(13259,170,'Allen Garcia','1977-11-07','M','M','2016-07-26',45,'Group 41 - 60'),
(13260,171,'James Flores','1977-10-09','M','M','2016-07-20',45,'Group 41 - 60'),
(13261,160,'Lindsey Andersen','1977-04-05','M','F','2016-07-11',45,'Group 41 - 60'),
(13263,188,'Kate Anand','1976-04-24','S','F','2017-05-16',46,'Group 41 - 60'),
(13264,121,'Melanie Sanchez','1976-05-23','M','F','2016-07-06',46,'Group 41 - 60'),
(13265,160,'Luke Adams','1976-01-22','S','M','2016-07-14',46,'Group 41 - 60'),
(13405,189,'Ethan Bryant','1977-10-05','M','M','2017-05-04',45,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(13406,170,'Craig Jiménez','1977-01-05','M','M','2016-07-31',45,'Group 41 - 60'),
(13540,117,'Paula Ortega','1980-03-06','M','F','2016-08-12',42,'Group 41 - 60'),
(13541,157,'Ashlee Xu','1980-08-12','M','F','2016-08-31',42,'Group 41 - 60'),
(13555,183,'Tammy Smith','1989-09-13','M','F','2017-06-26',33,'Group 21 - 40'),
(13556,205,'Alisha Nath','1989-11-13','S','F','2017-06-21',33,'Group 21 - 40'),
(13558,190,'Karen Lu','1989-06-22','M','F','2017-06-18',33,'Group 21 - 40'),
(13559,123,'Lori Ramos','1989-06-17','S','F','2016-08-29',33,'Group 21 - 40'),
(13560,167,'Andres Shan','1989-08-16','M','M','2016-09-19',33,'Group 21 - 40'),
(13575,211,'Alicia Shen','1964-08-25','M','F','2017-07-21',58,'Group 41 - 60'),
(13577,204,'Theodore Torres','1965-08-14','M','M','2017-07-24',57,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(13579,121,'Alan Chen','1966-02-26','M','M','2016-09-27',56,'Group 41 - 60'),
(13580,172,'Carol Xu','1966-07-18','M','F','2016-09-23',56,'Group 41 - 60'),
(13584,267,'Isaiah Cox','1973-08-17','S','M','2016-07-29',49,'Group 41 - 60'),
(13585,243,'Savannah Morris','1973-05-17','M','F','2016-07-25',49,'Group 41 - 60'),
(13590,277,'Louis Xie','1973-05-18','M','M','2016-07-06',49,'Group 41 - 60'),
(13591,278,'Latasha Alonso','1973-05-25','M','F','2016-07-05',49,'Group 41 - 60'),
(13592,207,'Gabriella Collins','1972-06-07','M','F','2017-07-05',50,'Group 41 - 60'),
(13595,220,'Cole Stewart','1971-06-02','S','M','2017-07-16',51,'Group 41 - 60'),
(13600,273,'Marie Sanz','1971-02-19','M','F','2016-08-06',51,'Group 41 - 60'),
(13602,231,'Virginia Mehta','1970-05-17','M','F','2016-08-08',52,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(13605,184,'Gerrit Straatsma','1969-11-18','M','M','2017-07-24',53,'Group 41 - 60'),
(13606,118,'Drew Sharma','1969-07-01','M','M','2016-10-18',53,'Group 41 - 60'),
(13607,145,'Levi Rana','1969-04-05','S','M','2016-10-19',53,'Group 41 - 60'),
(13685,123,'Briana Torres','1993-02-16','M','F','2016-10-30',29,'Group 21 - 40'),
(13686,128,'Peter Jai','1993-10-14','M','M','2016-10-09',29,'Group 21 - 40'),
(13697,172,'Jésus Munoz','1991-06-24','S','M','2016-10-25',31,'Group 21 - 40'),
(13768,216,'Ross Munoz','1988-04-20','M','M','2017-07-20',34,'Group 21 - 40'),
(13769,205,'Brendan Kumar','1988-09-02','M','M','2017-07-20',34,'Group 21 - 40'),
(13770,131,'Gerald Moreno','1988-07-26','M','M','2016-10-20',34,'Group 21 - 40'),
(13771,147,'Victor Moreno','1988-12-24','S','M','2016-11-09',34,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(13782,144,'Kelli Lu','1987-07-21','M','F','2016-11-03',35,'Group 21 - 40'),
(13822,117,'Jay Moyer','1982-06-08','M','M','2016-12-15',40,'Group 21 - 40'),
(13823,213,'Margaret Zheng','1982-05-06','M','F','2017-08-19',40,'Group 21 - 40'),
(13841,278,'Clayton Kumar','1994-01-04','S','M','2016-09-22',28,'Group 21 - 40'),
(14146,238,'Toni Sara','1979-07-22','M','F','2016-10-20',43,'Group 41 - 60'),
(14150,243,'Billy Munoz','1979-02-21','M','M','2016-10-10',43,'Group 41 - 60'),
(14157,255,'Willie Xu','1989-04-14','S','M','2016-10-11',33,'Group 21 - 40'),
(14160,117,'Brittney Hu','1989-07-05','M','F','2017-02-23',33,'Group 21 - 40'),
(14161,115,'Claudia Li','1989-02-02','S','F','2017-02-04',33,'Group 21 - 40'),
(14162,131,'Brett Garcia','1989-11-18','M','M','2017-02-10',33,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(14163,153,'Ebony Garcia','1989-10-23','M','F','2017-02-19',33,'Group 21 - 40'),
(14164,130,'Kari Smith','1989-11-12','S','F','2017-02-13',33,'Group 21 - 40'),
(14171,118,'Michele Lal','1964-09-05','S','F','2017-02-08',58,'Group 41 - 60'),
(14183,260,'Robyn Carlson','1973-10-17','S','F','2016-10-11',49,'Group 41 - 60'),
(14185,211,'Frank Vazquez','1972-11-19','S','M','2017-09-18',50,'Group 41 - 60'),
(14186,192,'Katrina Tang','1972-06-26','M','F','2017-09-21',50,'Group 41 - 60'),
(14191,266,'Derrick Martin','1971-01-15','M','M','2016-10-12',51,'Group 41 - 60'),
(14192,222,'Ronald Kapoor','1970-08-23','M','M','2017-09-22',52,'Group 41 - 60'),
(14195,247,'Clinton Blanco','1970-05-04','S','M','2016-10-23',52,'Group 41 - 60'),
(14200,215,'Colleen Goel','1968-10-07','M','F','2017-09-10',54,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(14203,220,'Seth Rodriguez','1967-05-14','S','M','2017-09-02',55,'Group 41 - 60'),
(14424,213,'Stefanie Raman','1977-07-08','S','F','2017-09-05',45,'Group 41 - 60'),
(14427,251,'Emmanuel Patel','1976-05-08','M','M','2016-10-07',46,'Group 41 - 60'),
(14428,173,'Cassie Andersen','1975-10-12','S','F','2017-03-01',47,'Group 41 - 60'),
(14525,238,'Claudia Sun','1997-06-07','M','F','2016-10-09',25,'Group 21 - 40'),
(14697,248,'Nelson Jimenez','1992-02-10','S','M','2016-11-29',30,'Group 21 - 40'),
(14702,234,'Curtis Zimmerman','1992-12-07','M','M','2016-11-07',30,'Group 21 - 40'),
(14712,252,'Eugene Liu','1991-11-22','S','M','2016-11-20',31,'Group 21 - 40'),
(14713,172,'Jon Ye','1990-07-08','S','M','2017-03-14',32,'Group 21 - 40'),
(14714,183,'Meghan Diaz','1990-08-11','S','F','2017-10-24',32,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(14716,184,'Shannon Zhou','1991-06-01','S','F','2017-10-11',31,'Group 21 - 40'),
(14719,182,'Ronnie He','1990-04-08','M','M','2017-10-09',32,'Group 21 - 40'),
(14770,229,'Melvin Andersen','1988-06-05','M','M','2016-12-29',34,'Group 21 - 40'),
(14771,249,'Heidi Vance','1988-08-23','M','F','2016-12-19',34,'Group 21 - 40'),
(14774,143,'Max Ferrier','1988-03-17','S','M','2017-03-04',34,'Group 21 - 40'),
(14778,242,'Renee Jimenez','1987-06-21','S','F','2016-12-14',35,'Group 21 - 40'),
(14833,241,'Riley Hayes','1982-06-13','S','F','2016-12-12',40,'Group 21 - 40'),
(14843,243,'Lee Vazquez','1995-07-07','S','M','2016-12-18',27,'Group 21 - 40'),
(14846,259,'Kelsey Chande','1994-11-13','S','F','2017-01-20',28,'Group 21 - 40'),
(14847,270,'Vadim Sazanovich','1994-03-12','S','F','2017-01-21',28,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(14928,251,'Roy Patel','1988-03-21','M','M','2017-01-30',34,'Group 21 - 40'),
(14929,276,'Peter Anand','1988-10-03','M','M','2017-01-18',34,'Group 21 - 40'),
(14937,278,'Brendan Xu','1986-11-23','S','M','2017-01-07',36,'Group 21 - 40'),
(14940,151,'Carmen Rana','1987-02-23','M','F','2017-05-19',35,'Group 21 - 40'),
(14941,261,'Emma Patterson','1986-07-27','S','F','2017-01-14',36,'Group 21 - 40'),
(14947,234,'Alejandro Chen','1985-01-11','S','M','2017-01-02',37,'Group 21 - 40'),
(14949,235,'Steve Wu','1985-04-14','M','M','2017-01-18',37,'Group 21 - 40'),
(14950,267,'Maria Hernandez','1984-08-27','S','F','2017-01-13',38,'Group 21 - 40'),
(15080,134,'Evelyn Chandra','1989-11-09','M','F','2017-06-30',33,'Group 21 - 40'),
(15084,133,'Adrienne Serrano','1989-09-20','S','F','2017-07-25',33,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(15100,171,'Brenda Chandra','1966-11-23','M','F','2017-07-07',56,'Group 41 - 60'),
(15101,162,'Shawn Shan','1966-10-17','S','M','2017-07-07',56,'Group 41 - 60'),
(15114,176,'Erika Munoz','1971-10-27','M','F','2017-07-04',51,'Group 41 - 60'),
(15116,133,'Mackenzie Ramirez','1970-04-26','M','F','2017-07-04',52,'Group 41 - 60'),
(15117,129,'Dana Dominguez','1969-05-14','M','F','2017-07-22',53,'Group 41 - 60'),
(15357,157,'Craig Navarro','1975-10-22','M','M','2017-07-12',47,'Group 41 - 60'),
(15625,142,'Clinton Alvarez','1992-10-17','M','M','2017-08-11',30,'Group 21 - 40'),
(15626,155,'Eduardo White','1992-07-23','M','M','2017-08-31',30,'Group 21 - 40'),
(15627,146,'Troy Srini','1992-12-24','S','M','2017-08-20',30,'Group 21 - 40'),
(15630,260,'Nichole Tang','1991-05-03','S','F','2017-04-26',31,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(15631,263,'Clayton Andersen','1991-11-12','S','M','2017-04-26',31,'Group 21 - 40'),
(15632,245,'Gloria Carlson','1991-01-09','M','F','2017-05-12',31,'Group 21 - 40'),
(15638,259,'Rosa He','1961-07-26','M','F','2017-05-22',61,'Group > 60'),
(15652,229,'Barbara Wang','1981-05-25','M','F','2017-05-20',41,'Group 41 - 60'),
(15653,254,'Gerald Madan','1981-06-07','S','M','2017-05-12',41,'Group 41 - 60'),
(15657,271,'Marcus Hayes','1980-06-20','M','M','2017-05-08',42,'Group 41 - 60'),
(15660,250,'April Jai','1979-09-02','M','F','2017-06-19',43,'Group 41 - 60'),
(15661,269,'Brandon Robinson','1979-08-20','M','M','2017-06-08',43,'Group 41 - 60'),
(15662,279,'Megan Richardson','1980-05-24','M','F','2017-06-08',42,'Group 41 - 60'),
(15675,120,'Jay Alonso','1989-10-16','M','M','2017-09-10',33,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(15684,168,'Tyrone Suarez','1964-07-10','S','M','2017-09-10',58,'Group 41 - 60'),
(15685,172,'Robin Vazquez','1964-06-09','M','F','2017-09-26',58,'Group 41 - 60'),
(15693,127,'Isabel Barnes','1974-07-19','S','F','2017-09-29',48,'Group 41 - 60'),
(15697,121,'Julia Morris','1973-07-06','M','F','2017-09-17',49,'Group 41 - 60'),
(15926,153,'Donna Deng','1976-02-12','S','F','2017-09-02',46,'Group 41 - 60'),
(15927,164,'Gilbert Huang','1976-12-04','S','M','2017-09-08',46,'Group 41 - 60'),
(15928,171,'Priscilla Pal','1976-05-08','S','F','2017-09-23',46,'Group 41 - 60'),
(15932,178,'Tabitha Jimenez','1975-09-11','M','F','2017-09-07',47,'Group 41 - 60'),
(16033,248,'Erica Lin','1991-10-15','M','F','2017-07-11',31,'Group 21 - 40'),
(16045,260,'Evelyn Sara','1978-07-04','M','F','2017-07-23',44,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(16046,275,'Robyn Gomez','1978-08-20','S','F','2017-07-06',44,'Group 41 - 60'),
(16053,267,'Frederick Perez','1976-06-18','M','M','2017-07-29',46,'Group 41 - 60'),
(16196,145,'Kurt Raheem','1993-10-21','M','M','2017-09-08',29,'Group 21 - 40'),
(17647,186,'Molly Lopez','1991-11-15','S','F','2017-12-06',31,'Group 21 - 40'),
(17648,211,'Gilbert Sharma','1991-04-17','S','M','2017-12-27',31,'Group 21 - 40'),
(17651,208,'Ethan Butler','1990-02-25','S','M','2017-12-05',32,'Group 21 - 40'),
(18626,118,'Tony Pal','1992-09-08','S','M','2017-12-25',30,'Group 21 - 40'),
(19802,56,'Sara James','1994-07-13','S','F','2016-07-30',28,'Group 21 - 40'),
(20075,66,'Aaron Allen','1973-05-18','S','M','2017-06-04',49,'Group 41 - 60'),
(20716,157,'Kristina Arun','1993-09-13','M','F','2017-11-05',29,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(22971,49,'Morgan Howard','2000-11-06','S','F','2017-01-09',22,'Group 21 - 40'),
(22975,53,'Courtney Turner','1998-09-12','S','F','2017-01-06',24,'Group 21 - 40'),
(23566,52,'Benjamin Shan','1999-03-27','S','M','2017-04-06',23,'Group 21 - 40'),
(23806,52,'Olivia Foster','1978-08-19','M','F','2017-04-29',44,'Group 41 - 60'),
(24491,66,'Kaitlyn Russell','2000-05-05','S','F','2017-06-19',22,'Group 21 - 40'),
(24493,55,'Seth Bennett','1999-03-28','S','M','2017-06-04',23,'Group 21 - 40'),
(24501,50,'Victoria Garcia','1999-04-28','S','F','2017-06-29',23,'Group 21 - 40'),
(24646,62,'Juan Murphy','1964-07-12','M','M','2017-06-23',58,'Group 41 - 60'),
(24781,41,'Carmen Garcia','1992-10-22','M','F','2017-07-07',30,'Group 21 - 40'),
(24786,60,'Haley Adams','1990-01-24','M','F','2017-07-19',32,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(24817,66,'Victoria Richardson','1989-10-11','M','F','2017-07-20',33,'Group 21 - 40'),
(24824,59,'Alexandria Wood','1985-09-08','S','F','2017-07-18',37,'Group 21 - 40'),
(24832,55,'Morgan Martin','1985-08-02','M','F','2017-07-30',37,'Group 21 - 40'),
(24976,64,'Stephanie Cooper','1969-07-17','M','F','2017-07-05',53,'Group 41 - 60'),
(24977,69,'Sophia Green','1969-07-12','M','F','2017-07-14',53,'Group 41 - 60'),
(25046,57,'Caleb Long','1993-09-10','M','M','2017-07-05',29,'Group 21 - 40'),
(25061,68,'Julia Hughes','1994-07-23','S','F','2017-07-25',28,'Group 21 - 40'),
(25093,55,'Madison Griffin','1987-06-27','S','F','2017-07-17',35,'Group 21 - 40'),
(25094,68,'Charles Thomas','1987-03-15','S','M','2017-07-15',35,'Group 21 - 40'),
(25095,69,'Adam Jai','1987-07-14','S','M','2017-08-04',35,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(25100,49,'Kristen Huang','1979-05-14','M','F','2017-08-06',43,'Group 41 - 60'),
(25361,60,'Haley Ross','1978-06-21','S','F','2017-08-05',44,'Group 41 - 60'),
(25363,62,'Alexandria Gray','1978-02-19','M','F','2017-08-11',44,'Group 41 - 60'),
(25371,49,'Renee Gomez','1992-02-22','M','F','2017-08-17',30,'Group 21 - 40'),
(25393,66,'Lucas Cox','1991-12-14','M','M','2017-08-27',31,'Group 21 - 40'),
(25857,552,'Abigail Perry','1964-09-05','S','F','2016-07-22',58,'Group 41 - 60'),
(25861,385,'Garrett Cooper','1965-02-26','M','M','2016-07-09',57,'Group 41 - 60'),
(25864,68,'Petr Lazecky','1966-06-07','M','F','2017-08-12',56,'Group 41 - 60'),
(25875,60,'Jocelyn Price','1968-06-12','M','F','2017-08-19',54,'Group 41 - 60'),
(25883,71,'Luis Carter','1969-02-03','M','M','2017-08-17',53,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(25892,60,'Stephanie Price','1971-03-21','M','F','2017-08-15',51,'Group 41 - 60'),
(25911,51,'Alexandra Sanders','1998-04-02','S','F','2017-09-30',24,'Group 21 - 40'),
(25995,62,'Jack Phillips','1981-04-02','M','M','2017-12-28',41,'Group 41 - 60'),
(25999,71,'Joshua Thompson','1980-07-01','M','M','2017-12-27',42,'Group 41 - 60'),
(26127,608,'Terry Chander','1969-04-02','M','M','2017-07-09',53,'Group 41 - 60'),
(26174,548,'Isaac Adams','2000-06-26','S','M','2017-07-11',22,'Group 21 - 40'),
(26183,298,'Allen Arthur','1997-02-04','S','M','2017-07-27',25,'Group 21 - 40'),
(26249,641,'Thomas Ross','1974-10-01','M','M','2017-07-12',48,'Group 41 - 60'),
(26316,59,'Stephanie Hughes','1989-10-07','S','F','2017-08-19',33,'Group 21 - 40'),
(26481,331,'Luke Young','1965-10-03','M','M','2017-10-21',57,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(26482,62,'Sydney Hill','1965-05-17','M','F','2017-11-21',57,'Group 41 - 60'),
(26496,70,'Cassidy Griffin','1968-11-08','M','F','2017-11-27',54,'Group 41 - 60'),
(26503,55,'Jeremiah Townsend','1969-02-03','M','M','2017-12-05',53,'Group 41 - 60'),
(26504,62,'Jennifer Robinson','1969-08-20','M','F','2017-12-16',53,'Group 41 - 60'),
(26512,52,'Christina Cooper','1970-02-01','M','F','2017-12-08',52,'Group 41 - 60'),
(26620,63,'Isabella Green','1987-05-21','S','F','2016-07-30',35,'Group 21 - 40'),
(26629,53,'Miranda Price','1980-02-06','M','F','2016-08-19',42,'Group 41 - 60'),
(26630,64,'Vanessa Powell','1980-03-15','M','F','2016-10-22',42,'Group 41 - 60'),
(26643,66,'Benjamin Miller','1978-10-13','M','M','2016-11-27',44,'Group 41 - 60'),
(26782,69,'Seth Lewis','2000-09-25','S','M','2017-01-01',22,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(26789,55,'Chase Morris','1998-11-10','S','M','2017-02-06',24,'Group 21 - 40'),
(27026,54,'Jonathan Perry','1975-07-11','S','M','2017-06-03',47,'Group 41 - 60'),
(27027,59,'Jennifer White','1975-07-14','S','F','2017-08-08',47,'Group 41 - 60'),
(27043,59,'Dalton Murphy','1978-06-09','S','M','2017-08-17',44,'Group 41 - 60'),
(27053,59,'Steven Cook','1979-03-24','S','M','2017-09-16',43,'Group 41 - 60'),
(27060,60,'Lucas Coleman','1993-03-28','M','M','2017-09-26',29,'Group 21 - 40'),
(27062,66,'Edward Harris','1993-04-03','S','M','2017-09-28',29,'Group 21 - 40'),
(27071,58,'Anthony Clark','1991-01-09','S','M','2017-09-08',31,'Group 21 - 40'),
(27082,60,'Zachary Taylor','1990-03-08','M','M','2017-10-24',32,'Group 21 - 40'),
(27084,71,'Fernando Russell','1990-03-03','M','M','2017-10-01',32,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(27085,58,'Christian Wilson','1990-10-02','M','M','2017-11-27',32,'Group 21 - 40'),
(27099,50,'Zachary Williams','1990-10-03','M','M','2017-11-27',32,'Group 21 - 40'),
(27101,51,'Eduardo Bell','1990-03-05','S','M','2017-11-27',32,'Group 21 - 40'),
(27102,55,'Katherine Miller','1990-07-12','S','F','2017-11-28',32,'Group 21 - 40'),
(27242,59,'Hunter Diaz','1993-06-19','M','M','2017-12-26',29,'Group 21 - 40'),
(27252,59,'Andrea Stewart','1991-07-17','M','F','2017-12-29',31,'Group 21 - 40'),
(27253,49,'Connor Jai','1992-04-15','M','M','2017-12-29',30,'Group 21 - 40'),
(27259,62,'Angela Diaz','1990-02-28','M','F','2017-12-20',32,'Group 21 - 40'),
(27265,53,'Isabella Thomas','1989-09-08','S','F','2017-12-05',33,'Group 21 - 40'),
(27577,632,'Patrick Cook','1978-06-04','S','M','2016-07-09',44,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(27578,334,'Courtney Carter','1978-11-08','M','F','2016-07-17',44,'Group 41 - 60'),
(27601,301,'Sydney Rogers','1973-11-10','S','F','2016-07-05',49,'Group 41 - 60'),
(27604,632,'Richard Brooks','1977-03-03','M','M','2016-07-10',45,'Group 41 - 60'),
(27605,638,'Miguel Martinez','1977-01-22','M','M','2016-07-29',45,'Group 41 - 60'),
(27611,316,'Jack Edwards','1976-12-03','M','M','2016-07-29',46,'Group 41 - 60'),
(27612,299,'Lucas Hill','1976-11-25','M','M','2016-07-06',46,'Group 41 - 60'),
(27614,609,'Warren Ye','1976-07-08','M','M','2016-07-19',46,'Group 41 - 60'),
(27649,637,'Evan Bailey','1975-06-08','M','M','2016-07-19',47,'Group 41 - 60'),
(27666,322,'Alyssa Garcia','1974-07-26','M','F','2016-07-09',48,'Group 41 - 60'),
(27672,59,'Justin Brown','1973-04-07','S','M','2017-02-25',49,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(27673,611,'Jennifer Young','1973-05-23','S','F','2016-07-31',49,'Group 41 - 60'),
(27678,542,'Angel Carter','1971-09-11','S','M','2016-08-20',51,'Group 41 - 60'),
(27681,307,'Olivia Jackson','1971-06-10','M','F','2016-08-18',51,'Group 41 - 60'),
(27726,335,'Sophia Hall','2000-03-26','S','F','2016-08-07',22,'Group 21 - 40'),
(27752,69,'Christian Butler','1995-05-23','S','M','2017-02-19',27,'Group 21 - 40'),
(27759,635,'Alexandria Brooks','1985-05-10','S','F','2016-08-20',37,'Group 21 - 40'),
(27917,337,'Andrea Sanders','1993-11-02','S','F','2016-08-21',29,'Group 21 - 40'),
(28013,60,'James Miller','1964-04-15','M','M','2017-02-13',58,'Group 41 - 60'),
(28014,300,'Rachel Robinson','1964-10-23','S','F','2016-08-07',58,'Group 41 - 60'),
(28017,611,'Christopher Martin','1965-06-24','S','M','2016-08-14',57,'Group 41 - 60');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(28018,355,'Rachel Foster','1965-03-21','S','F','2016-08-02',57,'Group 41 - 60'),
(28022,315,'Jason Lopez','1966-06-12','S','M','2016-08-18',56,'Group 41 - 60'),
(28036,66,'Jonathan Gonzales','1968-06-05','S','M','2017-02-03',54,'Group 41 - 60'),
(28039,352,'Xavier Lee','1968-09-02','S','M','2016-08-12',54,'Group 41 - 60'),
(28040,616,'Jack Mitchell','1969-02-22','M','M','2016-08-11',53,'Group 41 - 60'),
(28041,631,'Rebecca Wright','1969-05-02','S','F','2016-08-30',53,'Group 41 - 60'),
(28042,311,'Joseph Brown','1969-04-15','S','M','2016-08-15',53,'Group 41 - 60'),
(28044,311,'Jimmy Navarro','1969-07-12','S','M','2016-08-19',53,'Group 41 - 60'),
(11000,26,'Jon Yang','1986-04-08','M','M','2016-07-22',36,'Group 21 - 40'),
(11001,37,'Eugene Huang','1985-05-14','S','M','2016-07-18',37,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(11002,31,'Ruben Torres','1985-08-12','M','M','2016-07-10',37,'Group 21 - 40'),
(11004,19,'Elizabeth Johnson','1988-08-08','S','F','2016-07-26',34,'Group 21 - 40'),
(11005,22,'Julio Ruiz','1985-08-05','S','M','2016-07-02',37,'Group 21 - 40'),
(11006,8,'Janet Alvarez','1985-12-06','S','F','2016-07-27',37,'Group 21 - 40'),
(11007,40,'Marco Mehta','1984-05-09','M','M','2016-07-12',38,'Group 21 - 40'),
(11008,32,'Rob Verhoff','1984-07-07','S','F','2016-07-28',38,'Group 21 - 40'),
(11009,25,'Shannon Carlson','1984-04-01','S','M','2016-07-30',38,'Group 21 - 40'),
(11010,22,'Jacquelyn Suarez','1984-02-06','S','F','2016-07-17',38,'Group 21 - 40'),
(11011,22,'Curtis Lu','1983-11-04','M','M','2016-07-02',39,'Group 21 - 40'),
(11012,611,'Lauren Walker','1988-01-18','M','F','2018-09-17',34,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(28047,536,'Jay Sanchez','1970-12-20','S','M','2016-08-18',52,'Group 41 - 60'),
(28051,68,'Thomas Young','1971-01-15','S','M','2017-02-28',51,'Group 41 - 60'),
(28088,298,'Marshall Lal','1999-04-28','M','M','2016-09-06',23,'Group 21 - 40'),
(28092,50,'Morgan Hall','1998-12-16','S','F','2017-02-11',24,'Group 21 - 40'),
(28096,299,'Alexandra Stewart','1998-11-19','M','F','2016-09-15',24,'Group 21 - 40'),
(28097,307,'Jennifer Barnes','1998-09-03','S','F','2016-09-09',24,'Group 21 - 40'),
(28112,315,'Savannah Evans','2000-07-22','M','F','2016-09-07',22,'Group 21 - 40'),
(28129,66,'Justin Griffin','1994-03-06','S','M','2017-02-13',28,'Group 21 - 40'),
(28130,52,'Joshua Taylor','1993-02-02','S','M','2017-02-14',29,'Group 21 - 40'),
(28142,607,'Willie Lin','1994-08-14','S','M','2016-09-26',28,'Group 21 - 40');
INSERT INTO public.dim_customer (customer_id,geography_id,customer_name,birthdate,maritalstatus,gender,datefirstpurchase,age,grouping_age) VALUES
(28145,301,'Brandon Jones','1994-11-11','S','M','2016-09-02',28,'Group 21 - 40'),
(28147,298,'Omar Black','1984-07-18','S','M','2016-09-30',38,'Group 21 - 40'),
(28148,611,'Jon Zhao','1984-02-19','S','M','2016-09-19',38,'Group 21 - 40'),
(28149,334,'William Miller','1984-08-11','M','M','2016-09-16',38,'Group 21 - 40'),
(28150,336,'Connor Chen','1984-11-06','S','M','2016-09-15',38,'Group 21 - 40'),
(28161,57,'Jessica Perry','1982-03-14','S','F','2017-02-11',40,'Group 21 - 40'),
(28162,326,'Bruce Ward','1982-06-11','M','M','2016-09-17',40,'Group 21 - 40'),
(28163,553,'Rachel Washington','1982-03-11','M','F','2016-09-23',40,'Group 21 - 40'),
(28164,334,'Gabrielle Coleman','1982-10-21','M','F','2016-09-14',40,'Group 21 - 40'),