Customer Information
ID Full Name Gender City Country Phone_Number
10001 Cornelius Kujawa Male Tokyo Japan 555-1234
10002 Patrica Courville Female New York Metro USA 555-1236
10003 Sanford Xiong Male Sao Paulo Brazil 555-1238
10004 Allen Burrus Male Seoul South Korea 555-1240
10005 Kathrine Fritzler Female Mexico City Mexico 555-1242
10006 Colin Minter Male Osaka Japan 555-1244
10007 Velda Kimberling Female Manila Philippines 555-1246
10008 Vernon Addy Male Mumbai India 555-1248
10009 Blythe Fleischer Female Delhi India 555-1250
10010 Tad Hammack Male Jakarta Indonesia 555-1252
10011 Carlita Schroyer Female Lagos Nigeria 555-1256
10012 Trisha Arter Female Kolkata India 555-1258
10013 Leigha Bouffard Female Cairo Egypt 555-1260
10014 Lola Schmidt Female Los Angeles USA 555-1262
10015 Bella Logan Female Buenos Aires Argentina 555-1264
10016 Myung Koons Female Rio de Janeiro Brazil 555-1266
10017 Genaro Knutson Male Moscow Russia 555-1268
10018 Isaiah Chavarria Male Shanghai China 555-1270
10019 Thi Tipton Female Karachi Pakistan 555-1272
10020 Erik Crinklaw Male Paris France 555-1274
10021 Jesus Dallas Male Tokyo Japan 555-1276
10022 Celeste Weidner Female New York Metro USA 555-1278
10023 Richie Kimberling Male Sao Paulo Brazil 555-1280
10024 Beata Smyth Female Ho Chi Minh City Vietnam 555-1284
10025 Franklyn BrandenbergeMale Madrid Spain 555-1286
10026 Lennie Grasso Male Tianjin China 555-1288
10027 Leona Saia Female Kuala Lumpur Malaysia 555-1290
10028 Margery Farabee Female Toronto Canada 555-1292
10029 Annabel Rawlings Female Milan Italy 555-1294
10030 Britni Baisden Female Lima Peru 555-1296
10031 Jeannine Clayton Female Bangkok Thailand 555-1298
10032 Henry Steinmetz Male Brussels Belgium 555-1300
10033 Cherish Breland Female Vienna Austria 555-1302
10034 Debi Mealy Female San Jose USA 555-1304
10035 Houston Gouin Male Damman Saudi Arabia 555-1306
10036 Cathern Howey Female Copenhagen Denmark 555-1308
10037 Leonore Cloud Female Brisbane Australia 555-1310
10038 Desmond Bradfield Male Riverside USA 555-1312
10039 Jere Waters Male Cincinnati USA 555-1314
10040 Lenita Blankenship Female Accra Ghana 555-1316
10041 Mattie Gebhardt Male Tokyo Japan 555-1318
10042 Lizette Minto Female New York Metro USA 555-1320
10043 Lydia Geil Female Sao Paulo Brazil 555-1322
10044 Jerrell Mccafferty Male Ho Chi Minh City Vietnam 555-1324
10045 Foster Czaja Male Madrid Spain 555-1326
10046 Jewell Kyser Female Tianjin China 555-1328
10047 Stewart Warthen Male Kuala Lumpur Malaysia 555-1330
10048 Clorinda Clemmer Female Toronto Canada 555-1332
10049 Terresa Murrieta Female Milan Italy 555-1334
10050 Christen Donnelly Female Shenyang China 555-1336
10051 Madge Freudenthal Female Dallas USA 555-1338
10052 Precious Ellett Female Boston USA 555-1340
10053 Sueann Oster Female Belo Horizonte Brazil 555-1342
10054 Gracie Linwood Female Khartoum Sudan 555-1344
10055 Joshua Farone Male Riyadh Saudi Arabia 555-1346
10056 Candra Derrick Female Singapore Singapore 555-1348
10057 Willis Brinks Male Washington USA 555-1352
10058 Margy Gamet Female Brussels Belgium 555-1354
10059 Sharlene Rothschild Female Vienna Austria 555-1356
10060 Solomon Mahurin Male San Jose USA 555-1358
10061 Willis Tolbert Male Damman Saudi Arabia 555-1360
10062 Josefa Effinger Male Copenhagen Denmark 555-1362
10063 Vida Gayer Female Brisbane Australia 555-1364
10064 Damian Nedeau Male Riverside USA 555-1366
10065 Tracey Voyles Male Cincinnati USA 555-1368
10066 Berry Plumadore Male Accra Ghana 555-1370
10067 Irina Roberge Female Tokyo Japan 555-1372
10068 Neda Asmus Female New York Metro USA 555-1374
10069 Larissa Louviere Female Sao Paulo Brazil 555-1376
10070 Lorina Shawgo Female Ankara Turkey 555-1380
10071 Alex Turnbull Male Recife Brazil 555-1382
10072 Artie Mendoza Male Mesa USA 555-1384
10073 Danuta Hennig Female Durban South Africa 555-1386
10074 Jewel Dumbleton Male Porto Alegre Brazil 555-1388
10075 Evangeline Grandstaff Female Dalian China 555-1390
10076 Flora Zuniga Female Jeddah Saudi Arabia 555-1392
10077 Theresia Folk Female Seattle USA 555-1394
10078 Logan Schwan Male Cape Town South Africa 555-1396
10079 Marilyn Wittner Female San Diego USA 555-1398
10080 Hue Beeson Male Fortaleza Brazil 555-1400
10081 Anya Tellez Female Curitiba Brazil 555-1402
10082 Charles Ascencio Male Rome Italy 555-1404
10082 Charles Ascencio Male Rome Italy 555-1406
10083 Delta Seitz Male Naples Italy 555-1408
10084 Mauricio Thetford Male Minneapolis USA 555-1410
10085 Celeste Dorothy Female Tel Aviv Israel 555-1412
10086 Lisette Bowsher Female Birmingham UK 555-1414
10087 Annamaria Valdovinos Female Frankfurt Germany 555-1416
10088 Christene Kennell Female Lisbon Portugal 555-1418
10089 Evan Maxie Male Manchester UK 555-1420
10090 Tiana Brigham Female San Juan Puerto Rico 555-1422
10091 Milagros Colangelo Male Katowice Poland 555-1424
10092 Percy Rizzuto Female Tashkent Uzbekistan 555-1426
10093 Jack Dimas Male Fukuoka Japan 555-1428
10094 Cristobal Ritter Male Baku Azerbaijan 555-1430
10095 Camelia Korn Female St. Louis USA 555-1432
10096 Edwin Mehr Male Baltimore USA 555-1434
10097 Bulah Kaplan Female Sapporo Japan 555-1436
10098 Emerald Fernald Female Tampa USA 555-1438
10099 Cecille Holdridge Female Taichung Taiwan 555-1440
10100 Patrick Manuel Male Warsaw Poland 555-1442
10101 Steve Meinhardt Male Denver USA 555-1444
10102 Jonell Archibald Female Cologne/Bonn Germany 555-1446
10103 Kit Platner Male Hamburg Germany 555-1448
10104 Landon Zerr Male Dubai UAE 555-1450
10105 Dave Shives Male Pretoria South Africa 555-1452
10106 Ignacio Lucas Male Vancouver Canada 555-1454
10107 Teresita Schatz Female Beirut Lebanon 555-1456
10108 Margit Gardenhire Female Budapest Hungary 555-1458
10109 Belen Sanden Male Cleveland USA 555-1462
10110 Granville Core Male Pittsburgh USA 555-1464
10111 Boris Hine Male Campinas Brazil 555-1466
10112 Dylan Beeks Male Harare Zimbabwe 555-1468
10113 Jenniffer Mangual Female Brasilia Brazil 555-1470
10114 Lorri Brook Female Kuwait Kuwait 555-1472
10115 Krystle Spainhour Female Munich Germany 555-1474
10116 Michael Villareal Male Portland USA 555-1476
10117 Anton Higuera Male Brussels Belgium 555-1478
10118 Therese Mcnellis Female Vienna Austria 555-1480
10119 Beverlee Lawlor Female San Jose USA 555-1482
10120 Iris Delosantos Female Damman Saudi Arabia 555-1484
10121 Dorris Bennetts Female Copenhagen Denmark 555-1486
10122 Mark Macy Male Brisbane Australia 555-1488
10123 Tamika Pritchett Female Riverside USA 555-1490
10124 Verda Pilot Female Cincinnati USA 555-1492
10125 Kyra Coffin Female Accra Ghana 555-1494
10126 Roy Reber Male Tokyo Japan 555-1496
10127 Lyndsey Fagen Female New York Metro USA 555-1498
10128 Tynisha Kyllonen Female Sao Paulo Brazil 555-1500
10129 Corine Ashline Female Seoul South Korea 555-1502
10130 Omega Woolford Female Mexico City Mexico 555-1504
10131 Wilmer Markert Male Osaka Japan 555-1506
10132 Alden Overbey Male Manila Philippines 555-1508
10133 Conrad Haggard Male Mumbai India 555-1510
10134 Marco Jacobo Male Delhi India 555-1512
10135 Santiago Nold Male Jakarta Indonesia 555-1514
10136 Ela Omara Female Lagos Nigeria 555-1516
10137 Gwyneth Goodsell Female Kolkata India 555-1518
10138 Jamel Biery Male Cairo Egypt 555-1520
10139 Federico Taliaferro Male Kuala Lumpur Malaysia 555-1522
10140 Gordon Lehr Male Toronto Canada 555-1524
10141 Vanetta Eisenhower Female Delhi India 555-1526
10142 Byron Flick Male Jakarta Indonesia 555-1528
10143 Gertude Neitzel Female Lagos Nigeria 555-1530
10144 Mariella Lansford Female Kolkata India 555-1532
10145 Nicol Westerberg Female Shenyang China 555-1534
10146 Bobby Greening Male Dallas USA
10147 Johnathon Haug Male Boston USA
10148 Etta Bosque Female Belo Horizonte Brazil
10149 Tomas Coppinger Male Khartoum Sudan
10150 Nanci Bonier Female Riyadh Saudi Arabia
Order ID Order_Date Product Quantity Unit Price Total Cost Order Category
101 10127 9/23/2015 Product 8 23 $8.00 $184.00 Large Order
102 10041 11/10/2015 Product 1 6 $18.00 $108.00 Normal Order
103 10044 3/29/2010 Product 10 19 $13.00 $247.00 Large Order
104 10125 6/2/2014 Product 6 29 $4.00 $116.00 Large Order
105 10034 10/21/2011 Product 6 30 $4.00 $120.00 Large Order
106 10054 8/24/2013 Product 5 30 $12.00 $360.00 Large Order
107 10075 3/2/2012 Product 3 24 $12.00 $288.00 Large Order
108 10123 10/1/2011 Product 7 16 $9.00 $144.00 Large Order
109 10036 11/28/2013 Product 3 13 $12.00 $156.00 Normal Order
110 10017 8/29/2015 Product 7 17 $9.00 $153.00 Large Order
111 10041 12/8/2015 Product 2 7 $12.00 $84.00 Normal Order
112 10051 7/5/2010 Product 5 22 $12.00 $264.00 Large Order
113 10057 1/31/2012 Product 3 25 $12.00 $300.00 Large Order
114 10113 12/1/2011 Product 1 29 $18.00 $522.00 Large Order
115 10123 8/6/2013 Product 6 17 $4.00 $68.00 Large Order
116 10104 11/29/2015 Product 9 29 $2.00 $58.00 Large Order
117 10083 1/17/2015 Product 8 1 $8.00 $8.00 Small Order
118 10050 3/25/2010 Product 3 2 $12.00 $24.00 Small Order
119 10063 11/2/2015 Product 5 25 $12.00 $300.00 Large Order
120 10040 11/20/2013 Product 7 23 $9.00 $207.00 Large Order
121 10017 11/15/2014 Product 4 19 $2.00 $38.00 Large Order
122 10078 8/26/2010 Product 4 18 $2.00 $36.00 Large Order
123 10028 10/8/2010 Product 2 20 $12.00 $240.00 Large Order
124 10047 4/26/2013 Product 1 17 $18.00 $306.00 Large Order
125 10076 3/23/2015 Product 8 18 $8.00 $144.00 Large Order
126 10102 5/1/2013 Product 6 28 $4.00 $112.00 Large Order
127 10033 6/9/2014 Product 3 23 $12.00 $276.00 Large Order
128 10102 6/3/2010 Product 2 18 $12.00 $216.00 Large Order
129 10131 2/20/2012 Product 2 30 $12.00 $360.00 Large Order
130 10022 2/24/2012 Product 7 8 $9.00 $72.00 Normal Order
131 10140 9/15/2011 Product 3 16 $12.00 $192.00 Large Order
132 10143 12/23/2010 Product 1 1 $18.00 $18.00 Small Order
133 10133 8/28/2013 Product 10 18 $13.00 $234.00 Large Order
134 10127 2/5/2014 Product 7 26 $9.00 $234.00 Large Order
135 10090 6/16/2013 Product 1 25 $18.00 $450.00 Large Order
136 10036 10/1/2013 Product 7 13 $9.00 $117.00 Normal Order
137 10054 6/4/2012 Product 9 5 $2.00 $10.00 Small Order
138 10045 5/11/2012 Product 7 23 $9.00 $207.00 Large Order
139 10091 3/19/2013 Product 7 5 $9.00 $45.00 Small Order
140 10017 4/23/2015 Product 1 24 $18.00 $432.00 Large Order
141 10146 1/8/2013 Product 8 14 $8.00 $112.00 Normal Order
142 10024 6/29/2015 Product 4 24 $2.00 $48.00 Large Order
143 10097 11/16/2012 Product 9 26 $2.00 $52.00 Large Order
144 10091 4/9/2014 Product 8 29 $8.00 $232.00 Large Order
145 10035 9/25/2013 Product 10 27 $13.00 $351.00 Large Order
146 10073 7/21/2010 Product 4 21 $2.00 $42.00 Large Order
147 10111 12/6/2013 Product 2 11 $12.00 $132.00 Normal Order
148 10125 8/25/2010 Product 8 6 $8.00 $48.00 Normal Order
149 10111 1/2/2012 Product 3 10 $12.00 $120.00 Normal Order
150 10027 11/12/2011 Product 3 18 $12.00 $216.00 Large Order
151 10131 2/23/2014 Product 2 12 $12.00 $144.00 Normal Order
152 10028 5/9/2012 Product 6 19 $4.00 $76.00 Large Order
153 10085 8/26/2011 Product 7 21 $9.00 $189.00 Large Order
154 10032 12/25/2012 Product 1 29 $18.00 $522.00 Large Order
155 10075 11/10/2012 Product 4 8 $2.00 $16.00 Normal Order
156 10047 9/7/2012 Product 9 7 $2.00 $14.00 Normal Order
157 10006 1/26/2013 Product 4 6 $2.00 $12.00 Normal Order
158 10075 12/2/2010 Product 4 13 $2.00 $26.00 Normal Order
159 10051 7/16/2011 Product 9 26 $2.00 $52.00 Large Order
160 10118 10/30/2011 Product 3 23 $12.00 $276.00 Large Order
161 10149 12/25/2012 Product 7 13 $9.00 $117.00 Normal Order
162 10032 11/29/2015 Product 5 2 $12.00 $24.00 Small Order
163 10148 12/19/2013 Product 8 10 $8.00 $80.00 Normal Order
164 10118 12/18/2014 Product 7 4 $9.00 $36.00 Small Order
165 10066 1/4/2015 Product 3 30 $12.00 $360.00 Large Order
166 10081 9/11/2015 Product 6 15 $4.00 $60.00 Large Order
167 10045 5/13/2010 Product 4 24 $2.00 $48.00 Large Order
168 10092 7/22/2014 Product 7 15 $9.00 $135.00 Large Order
169 10079 12/18/2014 Product 9 6 $2.00 $12.00 Normal Order
170 10126 8/21/2010 Product 4 4 $2.00 $8.00 Small Order
171 10091 8/18/2015 Product 7 7 $9.00 $63.00 Normal Order
172 10055 10/9/2010 Product 1 26 $18.00 $468.00 Large Order
173 10003 5/28/2010 Product 8 9 $8.00 $72.00 Normal Order
174 10116 4/2/2010 Product 4 15 $2.00 $30.00 Large Order
175 10002 3/8/2012 Product 10 16 $13.00 $208.00 Large Order
176 10001 11/18/2014 Product 8 5 $8.00 $40.00 Small Order
177 10050 3/16/2015 Product 8 14 $8.00 $112.00 Normal Order
178 10125 1/14/2012 Product 3 2 $12.00 $24.00 Small Order
179 10095 8/26/2010 Product 1 12 $18.00 $216.00 Normal Order
180 10100 2/10/2010 Product 3 19 $12.00 $228.00 Large Order
181 10126 1/20/2010 Product 7 26 $9.00 $234.00 Large Order
182 10120 1/3/2012 Product 10 8 $13.00 $104.00 Normal Order
183 10134 5/2/2011 Product 9 4 $2.00 $8.00 Small Order
Maximum Quantity Sold
Sale Report
Product Time Month Full Date Quantity
Product 1 3:00 January 1/1/2015 300
Product 2 4:00 February 1/2/2015 450
Product 3 5:00 March 1/3/2015 230
Product 4 6:00 April 1/4/2015 56
Product 5 7:00 May 1/5/2015 780
Product 6 8:00 June 1/6/2015 230
Product 7 9:00 July 1/7/2015 1000
Product 8 10:00 August 1/8/2015 200
Product 9 11:00 September 1/9/2015 340
Product 10 12:00 October 1/10/2015 560
Shipping
Product Distance (meters) Price per meter
Product 1 84.879 75.8
Product 2 306.595 84.4
Product 3 561.985 94.6
Product 4 561.985 109.6
Product 5 390.568 86.2
Product 6 2175.030 64.2
Product 7 623.473 80.6
Product 8 287.603 93.4
Product 9 5512.038 37.6
Product 10 1783.180 44.2
Product 1 405.213 82.8
Product 2 90.456 116.2
Product 3 492.231 78.6
Product 4 2469.645 47.6
Product 5 1164.838 68.6
Product 6 579.208 101.0
Product 7 292.998 140.2
Product 8 350.852 74.8
Product 9 368.136 84.6
Product 10 23.383 95.4
Product 1 2275.877 58.6
Product 2 279.173 103.2
Product 3 1360.139 49.2
Product 4 279.173 95.8
Product 5 480.698 77.6
Product 6 1487.868 54.0
Product 7 383.862 112.4
Product 8 276.449 67.2
Product 9 557.478 94.0
Product 10 451.244 114.2
