CustomerID CustomerName SupplierID CategoryID
1 Simon Arman 1 1
2 Barbara Bartholomew 1 1
3 Alice Childs 1 2
4 Linda Greenburg 2 2
5 Sam Lundquist 2 2
6 Michael Mc Tague 3 2
7 Antonio Quayle 3 7
8 Orlando Rivena 3 2
9 Oscar Stark 4 6
10 Maria Unger 4 8
11 Caroline Hanover 5 4
12 Enrique Jaen 5 4
13 Alana Monder 6 8
14 Chika Innoue 6 7
15 Maureen Ryan 6 2
16 John Clark 7 3
17 Amanda Rapp 7 6
18 Cathy Booth 7 8
19 Jim Diehl 8 3
20 Elizabeth Smith 8 3
21 Katie Merkley 8 3
22 Beth Cuzens 9 5
23 Aidan Quionski 9 5
24 Abby Johnson 10 1
25 Alice Trembleye 11 3
26 Adame Clarke 11 3
27 Alysa Jones 11 3
28 Adolp Lee 12 7
29 Alexis Quayle 12 6
30 Abrille Aravia 13 8
31 Alamar Bazalde 14 4
32 Camiria Trembleye 14 4
33 Consuelo Clarisse 15 4
34 Alysa Ronalze 16 1
35 Muhammed MacIntyre 16 1
36 Barry French 17 8
37 Carl Jackson 17 8
38 Monica Federle 18 1
39 Dorothy Badders 18 1
40 Carlos Daly 19 8
41 Claudia Miner 19 8
42 Neola Schneider 20 5
43 Allen Rosenblatt 20 1
44 Sylvia Foulston 20 2
45 Jim Radford 21 8
46 Don Miller 21 8
47 Annie Cyprus 22 3
48 Carl Ludwig 22 3
49 Alice Childs 23 3
50 Linda Greenburg 23 3
51 Sam Lundquist 24 7
52 Michael Mc Tague 24 5
53 Antonio Quayle 24 6
54 Orlando Rivena 25 6
55 Oscar Stark 25 6
56 Maria Unger 26 5
57 Caroline Hanover 26 5
58 Enrique Jaen 27 8
59 Alana Monder 28 4
60 Chika Innoue 28 4
61 Maureen Ryan 29 2
62 John Clark 29 3
63 Amanda Rapp 7 2
64 Cathy Booth 12 5
65 Jim Diehl 2 2
66 Henry Goldwyn 2 2
67 Frank Price 16 1
68 Delfina Latchford 8 3
69 Roy Skaria 15 4
70 Jack O'Briant 7 1
71 Consuelo Clarisse 15 4
72 Alysa Ronalze 14 4
73 Muhammed MacIntyre 17 8
74 Barry French 4 7
75 Carl Jackson 12 1
76 Monica Federle 23 1
77 Carl Weiss 12 2
QuantityPerUnit UnitPrice Region OrderAmount
10 boxes x 20 bags 18 Korea 39
24 - 12 oz bottles 19 China 17
12 - 550 ml bottles 10 Vietnam 13
48 - 6 oz jars 22 Japan 53
36 boxes 21.35 Thailand 0
12 - 8 oz jars 25 Korea 120
12 - 1 lb pkgs. 30 Japan 15
12 - 12 oz jars 40 Vietnam 6
18 - 500 g pkgs. 97 Japan 29
12 - 200 ml jars 31 China 31
1 kg pkg. 21 China 22
10 - 500 g pkgs. 38 China 86
2 kg box 6 Vietnam 24
40 - 100 g pkgs. 23.25 Taiwan 35
24 - 250 ml bottles 15.5 Hongkong 39
32 - 500 g boxes 17.45 Hongkong 29
20 - 1 kg tins 39 Korea 0
16 kg pkg. 62.5 Hongkong 42
10 boxes x 12 pieces 9.2 Vietnam 25
30 gift boxes 81 Hongkong 40
24 pkgs. x 4 pieces 10 Korea 3
24 - 500 g pkgs. 21 China 104
12 - 250 g pkgs. 9 China 61
12 - 355 ml cans 4.5 China 20
20 - 450 g glasses 14 Vietnam 76
100 - 250 g bags 31.23 Hongkong 15
100 - 100 g pieces 43.9 Vietnam 49
25 - 825 g cans 45.6 Taiwan 26
50 bags x 30 sausgs. 123.79 Korea 0
10 - 200 g glasses 25.89 Taiwan 10
12 - 100 g pkgs 12.5 Vietnam 0
24 - 200 g pkgs. 32 Vietnam 9
500 g 2.5 Taiwan 112
24 - 12 oz bottles 14 China 111
24 - 12 oz bottles 18 Hongkong 20
24 - 250 g jars 19 Japan 112
12 - 500 g pkgs. 26 Hongkong 11
12 - 75 cl bottles 263.5 Vietnam 17
750 cc per bottle 18 Taiwan 69
24 - 4 oz tins 18.4 Vietnam 123
12 - 12 oz cans 9.65 Hongkong 85
32 - 1 kg pkgs. 14 Hongkong 26
16 - 500 g tins 46 Japan 17
20 - 2 kg bags 19.45 Taiwan 27
1k pkg. 9.5 Hongkong 5
4 - 450 g glasses 12 Korea 95
10 - 4 oz boxes 9.5 Hongkong 36
10 pkgs. 12.75 Hongkong 15
24 - 50 g pkgs. 20 Korea 10
12 - 100 g bars 16.25 Taiwan 65
50 - 300 g pkgs. 53 Korea 20
16 - 2 kg boxes 7 Hongkong 38
48 pieces 32.8 Vietnam 0
16 pies 7.45 Thailand 21
24 boxes x 2 pies 24 Thailand 115
24 - 250 g pkgs. 38 Thailand 21
24 - 250 g pkgs. 19.5 Hongkong 36
24 pieces 13.25 Korea 62
5 kg pkg. 55 Hongkong 79
15 - 300 g rounds 34 Hongkong 19
24 - 500 ml bottles 28.5 Taiwan 113
48 pies 49.3 Thailand 17
15 - 625 g jars 43.9 Thailand 24
20 bags x 4 pieces 33.25 Vietnam 22
32 - 8 oz bottles 21.05 Hongkong 76
24 - 8 oz jars 17 Hongkong 4
24 - 12 oz bottles 14 Taiwan 52
10 boxes x 8 pieces 12.5 Hongkong 6
10 kg pkg. 36 Hongkong 26
24 - 355 ml bottles 15 Korea 15
10 - 500 g pkgs. 21.5 Taiwan 26
24 - 200 g pkgs. 34.8 Korea 14
24 - 150 g jars 15 Hongkong 101
5 kg pkg. 10 Korea 4
24 - 0.5 l bottles 7.75 Hongkong 125
500 ml 18 Thailand 57
12 boxes 13 Taiwan 32
OrderDate Total Order Amount Average
10/13/2018 702 Average
10/1/2016 323
10/1/2016 130 Maximum Total
7/10/2017 1166 Maximum
8/28/2018 0
8/28/2018 3000
6/17/2017 450
6/17/2017 240
3/24/2017 2813
2/26/2018 961
11/23/2018 462
11/23/2018 3268
6/8/2016 144
6/8/2016 813.75
8/4/2016 604.5
5/30/2017 506.05
11/25/2015 0
2/14/2016 2625
2/14/2016 230
4/15/2016 3240
4/15/2016 30
3/12/2018 2184
3/12/2018 549
3/9/2017 90
3/9/2017 1064
8/4/2016 468.45
5/6/2017 2151.1
12/23/2018 1185.6
11/8/2018 0
10/21/2016 258.9
1/1/2017 0
1/1/2017 288
10/10/2017 280
10/10/2017 1554
9/23/2018 360
7/19/2017 2128
10/9/2015 286
10/9/2015 4479.5
10/9/2015 1242
12/9/2018 2263.2
10/8/2016 820.25
5/2/2016 364
3/8/2018 782
5/28/2017 525.15
9/19/2018 47.5
8/31/2017 1140
8/31/2017 342
8/31/2017 191.25
8/31/2017 200
7/8/2017 1056.25
1/30/2015 1060
1/8/2016 266
11/7/2018 0
4/29/2018 156.45
12/31/2017 2760
8/12/2015 798
8/12/2015 702
11/12/2017 821.5
11/12/2017 4345
1/20/2016 646
3/20/2015 3220.5
7/21/2016 838.1
7/21/2016 1053.6
6/12/2016 731.5
1/15/2015 1599.8
1/15/2015 68
6/4/2018 728
2/18/2018 75
11/16/2017 936
11/16/2017 225
11/16/2017 559
8/7/2017 487.2
6/8/2018 1515
10/17/2015 40
8/28/2017 968.75
9/29/2017 1026
9/29/2017 416
Toys Ordered Price Each Q. Ordered Price
BBQ Barbie Doll 12.99 2 25.98
Prince Eric Doll 8.99 3 26.97
Princess Jasmine Doll 9.99 1 9.99
Cinderella’s Coach 19.99 1 19.99
Spiderman gloves 14.99 3 44.97
Hama Bead Starter Kit 12.5 2 25
Pink Heart Light Set 14.5 1 14.5
Harry Potter Magic Set 19.99 1 19.99
Discount Final Price
1.8186 24.1614
1.8879 25.0821
0.6993 9.2907
1.3993 18.5907
3.1479 41.8221
1.75 23.25
1.015 13.485
1.3993 18.5907
Moab Trails Su
Q1 successful attempts
Trail Apr May Jun Total
Chicken Comers 365.00 318.00 985.00 1,668.00
Gemini Bridges 231.00 181.00 423.00 835.00
Poison Spider Mesa 422.00 564.00 568.00 1,554.00
Moab Rim 452.00 441.00 756.00 1,649.00
Lizard Hole 632.00 785.00 986.00 2,403.00
Moab Trails Successful Attempts
1,200.00
1,000.00
800.00
600.00
400.00
200.00
-
Chicken Comers Gemini Bridges Poison Spider Moab Rim Lizard Hole
Mesa
Column B Column C Column D
-
Chicken Comers Gemini Bridges Poison Spider Moab Rim Lizard Hole
Mesa
Column B Column C Column D
Moab Trails Successful Attempts
Customers StateProvince Country/Region
Paul Dan Alabama United State
Jason Lee Florida United State
Maark Tuan New Brunswick Canada
Paul Dan Pennsylvania United State
Vin Sharyn Northwest Territories Canada
Costello John Connecticut United State
Maark Tuan Northwest Territories Canada
Munoz Dan Utah United State
Stewart Sandra Northwest Territories Canada
Katty Sandra Connecticut United State
Vin Sharyn Northwest Territories Canada
Kincade Lisa Florida United State
Carpenter John New Brunswick Canada
Kincade Lisa Connecticut United State
Houston Sharyn New Brunswick Canada
Houston Sharyn West Virginia United State
Jason Lee Northwest Territories Canada
Paul Dan West Virginia United State
Vin Sharyn Northwest Territories Canada
Maark Tuan Pennsylvania United State
Paul Dan Northwest Territories Canada
Katty Sandra Pennsylvania United State
Costello John Northwest Territories Canada
Munoz Dan Pennsylvania United State
Houston Sharyn Northwest Territories Canada
Munoz Dan Pennsylvania United State
Katty Sandra Northwest Territories Canada
Jason Lee Pennsylvania United State
Jason Lee Northwest Territories Canada
Carpenter John Pennsylvania United State
Stewart Sandra Northwest Territories Canada
Houston Sharyn Pennsylvania United State
Carpenter John Northwest Territories Canada
Vin Sharyn Pennsylvania United State
Carpenter John Northwest Territories Canada
Costello John Pennsylvania United State
Kincade Lisa Northwest Territories Canada
Stewart Sandra Pennsylvania United State
Maark Tuan Northwest Territories Canada
Costello John Pennsylvania United State
Kincade Lisa Northwest Territories Canada
Maark Tuan Pennsylvania United State
Carpenter John New Brunswick Canada
Jason Lee Pennsylvania United State
Jason Lee Northwest Territories Canada
Maark Tuan Pennsylvania United State
Katty Sandra Northwest Territories Canada
Postal Code Average Age Highest Age
AX10100 40 75
KE05432-043 24 81
CA12209 23 63
EC2 5NT 27 56
SK02389-673 42 86
PO31 7PJ 45 65
S-958 22 44 50
HX4110 50 55
MT75012 50 66
SE82520 34 59
WX1 6LT 34 63
PL28001 48 64
B-6000 42 62
MX05487-020 26 70
DL5022 37 77
CH67000 50 58
SD14776 45 73
SW7 1RZ 47 61
KA05442-030 41 72
ML1756 44 58
WX3 6FW 23 83
B-1180 25 76
AX10100 25 78
KE05432-043 39 67
CA12209 38 73
EC2 5NT 35 89
SK02389-673 33 88
PO31 7PJ 26 51
S-958 22 35 80
HX4110 48 56
MT75012 24 66
SE82520 30 63
WX1 6LT 38 76
PL28001 34 62
B-6000 42 60
MX05487-020 47 66
DL5022 30 76
CH67000 24 88
SD14776 28 75
SW7 1RZ 27 68
KA05442-030 43 64
ML1756 40 85
WX3 6FW 38 72
B-1180 48 57
AX10100 49 67
KE05432-043 27 74
CA12209 21 55
