Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Ecommerce Website Analysis by SQL

Language: Layout:
absolute service time: 0,77 sec 
edit mode |  history  | discussion
   customerid country
1 1 Germany
2 2 Mexico
3 3 Mexico
4 4 UK
5 5 Sweden
6 6 Germany
7 7 France
8 8 Spain
9 9 France
10 10 Canada
   categoryid categoryname
1 1 Beverages
2 2 Condiments
3 3 Confections
4 4 Dairy Products
5 5 Grains/Cereals
6 6 Meat/Poultry
7 7 Produce
8 8 Seafood
   employeeid birthdate
1 1 08.12.1968 00:00:00
2 2 19.02.1952 00:00:00
3 3 30.08.1963 00:00:00
4 4 19.09.1958 00:00:00
5 5 04.03.1955 00:00:00
   orderid productid quantity
1 10248 11 12
2 10248 42 10
3 10248 72 5
4 10249 14 9
5 10249 51 40
6 10250 41 10
7 10250 51 35
8 10250 65 15
9 10251 22 6
10 10251 57 15
   orderid customerid
1 10248 90
2 10249 81
3 10250 34
4 10251 84
5 10252 76
6 10253 34
7 10254 14
8 10255 68
9 10256 88
10 10257 35
   productid categoryid price
1 1 1 18
2 2 1 19
3 3 2 10
4 4 2 22
5 5 2 21
6 6 2 25
7 7 7 30
8 8 2 40
9 9 6 97
10 10 8 31
   customerid
1 17
2 15
3 65
4 68
5 84
6 6
7 20
8 11
9 12
10 5
11 55
12 81
13 1
14 61
15 9
16 88
17 10
18 24
19 8
20 76
21 87
22 35
23 7
24 34
25 18
26 2
27 13
28 19
29 90
30 16
31 4
32 3
33 14
   count
1 20
   count
1 17
   count
1 33
   customerid orderid country
1 7 10265 France
2 13 10259 Mexico
3 14 10254 Switzerland
4 20 10263 Austria
5 20 10258 Austria
   categoryid productid sales row_num
1 1 43 1150 1
2 1 2 950 2
3 2 5 1365 1
4 2 44 399 2
5 3 20 3240 1
6 3 27 1100 2
7 4 31 520 1
8 4 12 456 2
9 5 42 140 1
10 5 22 126 2
11 6 29 1240 1
12 6 17 1170 2
13 7 28 920 1
14 7 7 450 2
15 8 30 1560 1
16 8 40 1080 2
   categoryid productid sales rank_num
1 1 43 1150 1
2 1 2 950 2
3 2 5 1365 1
4 2 44 399 2
5 3 20 3240 1
6 3 27 1100 2
7 4 31 520 1
8 4 12 456 2
9 5 42 140 1
10 5 22 126 2
11 6 29 1240 1
12 6 17 1170 2
13 7 28 920 1
14 7 7 450 2
15 8 30 1560 1
16 8 40 1080 2
   categoryid productid sales d_rank_num
1 1 43 1150 1
2 1 2 950 2
3 2 5 1365 1
4 2 44 399 2
5 3 20 3240 1
6 3 27 1100 2
7 4 31 520 1
8 4 12 456 2
9 5 42 140 1
10 5 22 126 2
11 6 29 1240 1
12 6 17 1170 2
13 7 28 920 1
14 7 7 450 2
15 8 30 1560 1
16 8 40 1080 2
   orderid productid quantity buckets
1 10258 2 50 1
2 10264 2 35 1
3 10255 2 20 2
4 10258 5 65 1
5 10262 5 12 2
6 10262 7 15 1
7 10273 10 24 1
8 10276 10 15 2
9 10248 11 12 1
10 10266 12 12 1
11 10276 13 10 1
12 10249 14 9 1
13 10283 15 20 1
14 10263 16 60 1
15 10255 16 35 2
16 10265 17 30 1
17 10279 17 15 2
18 10283 19 18 1
19 10281 19 1 2
20 10252 20 40 1
21 10272 20 6 2
22 10261 21 20 1
23 10259 21 10 2
24 10251 22 6 1
25 10263 24 28 1
26 10254 24 15 1
27 10280 24 12 1
28 10275 24 12 2
29 10281 24 6 2
30 10257 27 25 1
31 10284 27 15 2
32 10277 28 20 1
33 10268 29 10 1
34 10263 30 60 1
35 10282 30 6 2
36 10272 31 40 1
37 10253 31 20 1
38 10273 31 15 2
39 10258 32 6 1
40 10269 33 60 1
41 10252 33 25 1
42 10271 33 24 2
43 10273 33 20 2
44 10261 35 20 1
45 10281 35 4 2
46 10270 36 30 1
47 10255 36 25 2
48 10259 37 1 1
49 10253 39 42 1
50 10257 39 6 2
51 10273 40 60 1
52 10267 40 50 2
53 10264 41 25 1
54 10260 41 16 1
55 10250 41 10 2
56 10248 42 10 1
57 10270 43 25 1
58 10284 44 21 1
59 10278 44 16 2
60 10253 49 40 1
61 10249 51 40 1
62 10250 51 35 2
63 10256 53 15 1
64 10254 55 21 1
65 10280 55 20 2
66 10262 56 2 1
67 10260 57 50 1
68 10251 57 15 1
69 10282 57 2 2
70 10267 59 70 1
71 10255 59 30 1
72 10278 59 15 2
73 10275 59 6 2
74 10252 60 40 1
75 10283 60 35 1
76 10284 60 20 2
77 10260 62 15 1
78 10277 62 12 2
79 10278 63 8 1
80 10251 65 20 1
81 10250 65 15 2
82 10284 67 5 1
83 10260 70 21 1
84 10265 70 20 2
85 10274 71 20 1
86 10272 72 24 1
87 10269 72 20 1
88 10274 72 7 1
89 10248 72 5 2
90 10268 72 4 2
91 10283 72 3 2
92 10278 73 25 1
93 10263 74 36 1
94 10254 74 21 2
95 10280 75 30 1
96 10273 76 33 1
97 10267 76 15 2
98 10257 77 15 1
99 10256 77 12 2
   orderid productid quantity buckets
1 10267 59 70 1
2 10258 5 65 1
3 10273 40 60 1
4 10263 30 60 1
5 10269 33 60 1
6 10263 16 60 1
7 10267 40 50 1
8 10258 2 50 1
9 10260 57 50 1
10 10253 39 42 1
11 10249 51 40 1
12 10272 31 40 1
13 10253 49 40 1
14 10252 60 40 1
15 10252 20 40 1
16 10263 74 36 1
17 10264 2 35 1
18 10283 60 35 1
19 10250 51 35 1
20 10255 16 35 1
21 10273 76 33 1
22 10265 17 30 1
23 10255 59 30 1
24 10280 75 30 1
25 10270 36 30 1
26 10263 24 28 1
27 10264 41 25 1
28 10270 43 25 1
29 10252 33 25 1
30 10255 36 25 1
31 10257 27 25 1
32 10278 73 25 1
33 10272 72 24 1
34 10271 33 24 1
35 10273 10 24 1
36 10260 70 21 1
37 10284 44 21 1
38 10254 74 21 1
39 10254 55 21 1
40 10251 65 20 1
41 10283 15 20 1
42 10284 60 20 1
43 10274 71 20 1
44 10261 21 20 1
45 10261 35 20 1
46 10280 55 20 1
47 10255 2 20 1
48 10253 31 20 1
49 10273 33 20 1
50 10269 72 20 1
51 10277 28 20 2
52 10265 70 20 2
53 10283 19 18 2
54 10278 44 16 2
55 10260 41 16 2
56 10256 53 15 2
57 10250 65 15 2
58 10251 57 15 2
59 10254 24 15 2
60 10257 77 15 2
61 10260 62 15 2
62 10262 7 15 2
63 10267 76 15 2
64 10273 31 15 2
65 10276 10 15 2
66 10278 59 15 2
67 10279 17 15 2
68 10284 27 15 2
69 10266 12 12 2
70 10262 5 12 2
71 10275 24 12 2
72 10277 62 12 2
73 10280 24 12 2
74 10256 77 12 2
75 10248 11 12 2
76 10268 29 10 2
77 10250 41 10 2
78 10276 13 10 2
79 10259 21 10 2
80 10248 42 10 2
81 10249 14 9 2
82 10278 63 8 2
83 10274 72 7 2
84 10281 24 6 2
85 10258 32 6 2
86 10257 39 6 2
87 10282 30 6 2
88 10251 22 6 2
89 10272 20 6 2
90 10275 59 6 2
91 10284 67 5 2
92 10248 72 5 2
93 10281 35 4 2
94 10268 72 4 2
95 10283 72 3 2
96 10282 57 2 2
97 10262 56 2 2
98 10281 19 1 2
99 10259 37 1 2
   orderid productid quantity running_order_total d_rank_num
1 10248 11 12 27 1
2 10248 42 10 27 2
3 10248 72 5 27 3
4 10249 51 40 76 1
5 10249 14 9 76 2
6 10250 51 35 136 1
7 10250 65 15 136 2
8 10250 41 10 136 3
9 10251 65 20 177 1
10 10251 57 15 177 2
11 10251 22 6 177 3
12 10252 60 40 282 1
13 10252 20 40 282 1
14 10252 33 25 282 2
15 10253 39 42 384 1
16 10253 49 40 384 2
17 10253 31 20 384 3
18 10254 74 21 441 1
19 10254 55 21 441 1
20 10254 24 15 441 2
21 10255 16 35 551 1
22 10255 59 30 551 2
23 10255 36 25 551 3
24 10255 2 20 551 4
25 10256 53 15 578 1
26 10256 77 12 578 2
27 10257 27 25 624 1
28 10257 77 15 624 2
29 10257 39 6 624 3
30 10258 5 65 745 1
31 10258 2 50 745 2
32 10258 32 6 745 3
33 10259 21 10 756 1
34 10259 37 1 756 2
35 10260 57 50 858 1
36 10260 70 21 858 2
37 10260 41 16 858 3
38 10260 62 15 858 4
39 10261 21 20 898 1
40 10261 35 20 898 1
41 10262 7 15 927 1
42 10262 5 12 927 2
43 10262 56 2 927 3
44 10263 16 60 1111 1
45 10263 30 60 1111 1
46 10263 74 36 1111 2
47 10263 24 28 1111 3
48 10264 2 35 1171 1
49 10264 41 25 1171 2
50 10265 17 30 1221 1
51 10265 70 20 1221 2
52 10266 12 12 1233 1
53 10267 59 70 1368 1
54 10267 40 50 1368 2
55 10267 76 15 1368 3
56 10268 29 10 1382 1
57 10268 72 4 1382 2
58 10269 33 60 1462 1
59 10269 72 20 1462 2
60 10270 36 30 1517 1
61 10270 43 25 1517 2
62 10271 33 24 1541 1
63 10272 31 40 1611 1
64 10272 72 24 1611 2
65 10272 20 6 1611 3
66 10273 40 60 1763 1
67 10273 76 33 1763 2
68 10273 10 24 1763 3
69 10273 33 20 1763 4
70 10273 31 15 1763 5
71 10274 71 20 1790 1
72 10274 72 7 1790 2
73 10275 24 12 1808 1
74 10275 59 6 1808 2
75 10276 10 15 1833 1
76 10276 13 10 1833 2
77 10277 28 20 1865 1
78 10277 62 12 1865 2
79 10278 73 25 1929 1
80 10278 44 16 1929 2
81 10278 59 15 1929 3
82 10278 63 8 1929 4
83 10279 17 15 1944 1
84 10280 75 30 2006 1
85 10280 55 20 2006 2
86 10280 24 12 2006 3
87 10281 24 6 2017 1
88 10281 35 4 2017 2
89 10281 19 1 2017 3
90 10282 30 6 2025 1
91 10282 57 2 2025 2
92 10283 60 35 2101 1
93 10283 15 20 2101 2
94 10283 19 18 2101 3
95 10283 72 3 2101 4
96 10284 44 21 2162 1
97 10284 60 20 2162 2
98 10284 27 15 2162 3
99 10284 67 5 2162 4
   orderid productid quantity running_order_total
1 10248 72 5 5
2 10248 42 10 15
3 10248 11 12 27
4 10249 14 9 9
5 10249 51 40 49
6 10250 41 10 10
7 10250 65 15 25
8 10250 51 35 60
9 10251 22 6 6
10 10251 57 15 21
11 10251 65 20 41
12 10252 33 25 25
13 10252 20 40 105
14 10252 60 40 105
15 10253 31 20 20
16 10253 49 40 60
17 10253 39 42 102
18 10254 24 15 15
19 10254 55 21 57
20 10254 74 21 57
21 10255 2 20 20
22 10255 36 25 45
23 10255 59 30 75
24 10255 16 35 110
25 10256 77 12 12
26 10256 53 15 27
27 10257 39 6 6
28 10257 77 15 21
29 10257 27 25 46
30 10258 32 6 6
31 10258 2 50 56
32 10258 5 65 121
33 10259 37 1 1
34 10259 21 10 11
35 10260 62 15 15
36 10260 41 16 31
37 10260 70 21 52
38 10260 57 50 102
39 10261 35 20 40
40 10261 21 20 40
41 10262 56 2 2
42 10262 5 12 14
43 10262 7 15 29
44 10263 24 28 28
45 10263 74 36 64
46 10263 16 60 184
47 10263 30 60 184
48 10264 41 25 25
49 10264 2 35 60
50 10265 70 20 20
51 10265 17 30 50
52 10266 12 12 12
53 10267 76 15 15
54 10267 40 50 65
55 10267 59 70 135
56 10268 72 4 4
57 10268 29 10 14
58 10269 72 20 20
59 10269 33 60 80
60 10270 43 25 25
61 10270 36 30 55
62 10271 33 24 24
63 10272 20 6 6
64 10272 72 24 30
65 10272 31 40 70
66 10273 31 15 15
67 10273 33 20 35
68 10273 10 24 59
69 10273 76 33 92
70 10273 40 60 152
71 10274 72 7 7
72 10274 71 20 27
73 10275 59 6 6
74 10275 24 12 18
75 10276 13 10 10
76 10276 10 15 25
77 10277 62 12 12
78 10277 28 20 32
79 10278 63 8 8
80 10278 59 15 23
81 10278 44 16 39
82 10278 73 25 64
83 10279 17 15 15
84 10280 24 12 12
85 10280 55 20 32
86 10280 75 30 62
87 10281 19 1 1
88 10281 35 4 5
89 10281 24 6 11
90 10282 57 2 2
91 10282 30 6 8
92 10283 72 3 3
93 10283 19 18 21
94 10283 15 20 41
95 10283 60 35 76
96 10284 67 5 5
97 10284 27 15 20
98 10284 60 20 40
99 10284 44 21 61
   orderid productid quantity running_order_total running_order_total
1 10263 16 60 1111 1111
2 10263 24 28 1111 1111
3 10263 30 60 1111 1111
4 10263 74 36 1111 1111
5 10264 2 35 1171 1171
6 10264 41 25 1171 1171
7 10265 17 30 1221 1221
8 10265 70 20 1221 1221
9 10266 12 12 1233 1233
10 10267 40 50 1368 1368
11 10267 59 70 1368 1368
12 10267 76 15 1368 1368
13 10268 29 10 1382 1382
14 10268 72 4 1382 1382
15 10269 33 60 1462 1462
16 10269 72 20 1462 1462
17 10270 36 30 1517 1517
18 10270 43 25 1517 1517
19 10271 33 24 1541 1541
20 10272 20 6 1611 1611
21 10272 31 40 1611 1611
22 10272 72 24 1611 1611
23 10273 10 24 1763 1763
24 10273 31 15 1763 1763
25 10273 33 20 1763 1763
26 10273 40 60 1763 1763
27 10273 76 33 1763 1763
28 10274 71 20 1790 1790
29 10274 72 7 1790 1790
30 10275 24 12 1808 1808
31 10275 59 6 1808 1808
32 10276 10 15 1833 1833
33 10276 13 10 1833 1833
34 10277 28 20 1865 1865
35 10277 62 12 1865 1865
36 10278 44 16 1929 1929
37 10278 59 15 1929 1929
38 10278 63 8 1929 1929
39 10278 73 25 1929 1929
40 10279 17 15 1944 1944
41 10280 24 12 2006 2006
42 10280 55 20 2006 2006
43 10280 75 30 2006 2006
44 10281 19 1 2017 2017
45 10281 24 6 2017 2017
46 10281 35 4 2017 2017
47 10282 30 6 2025 2025
48 10282 57 2 2025 2025
49 10283 15 20 2101 2101
50 10283 19 18 2101 2101
51 10283 60 35 2101 2101
52 10283 72 3 2101 2101
53 10284 27 15 2162 2162
54 10284 44 21 2162 2162
55 10284 60 20 2162 2162
56 10284 67 5 2162 2162
   country country_flag
1 Germany Developed Country
2 Mexico Developing Country
3 Mexico Developing Country
4 UK other countries
5 Sweden other countries
6 Germany Developed Country
7 France other countries
8 Spain other countries
9 France other countries
10 Canada other countries
11 UK other countries
12 Argentina other countries
13 Mexico Developing Country
14 Switzerland other countries
15 Brazil other countries
16 UK other countries
17 Germany Developed Country
18 France other countries
19 UK other countries
20 Austria other countries
   orderid products beverages_sales
1 10271 1 NULL
2 10283 2 NULL
3 10266 1 NULL
4 10277 1 NULL
5 10250 1 NULL
6 10249 1 NULL
7 10270 2 25
8 10258 3 50
9 10260 1 NULL
10 10253 3 42
11 10264 2 35
12 10282 1 NULL
13 10276 2 NULL
14 10255 3 20
15 10269 1 NULL
16 10268 1 NULL
17 10251 1 NULL
18 10281 3 10
19 10261 2 20
20 10267 1 NULL
21 10272 2 NULL
22 10252 2 NULL
23 10257 2 6
24 10259 2 NULL
25 10275 1 12
26 10280 1 12
27 10254 1 15
28 10278 1 NULL
29 10265 1 NULL
30 10273 4 NULL
31 10279 1 NULL
32 10262 2 NULL
33 10284 2 NULL
34 10248 2 NULL
35 10263 3 28
   country total_sales
1 Austria 305
2 Switzerland 57
3 France 50
4 Mexico 11
5 Germany 0
6 Canada 0
7 UK 0
8 Sweden 0
9 Brazil 0
10 Spain 0
11 Argentina 0
   country revenue
1 Argentina NULL
2 Brazil NULL
3 Sweden NULL
4 Germany NULL
5 Canada NULL
6 UK NULL
7 Spain NULL
8 Austria 5227
9 France 1170
10 Mexico 126
11 Switzerland 75
   country revenue
1 Austria 5227
2 France 1170
3 Mexico 126
4 Switzerland 75
5 Germany 0
6 Canada 0
7 UK 0
8 Sweden 0
9 Brazil 0
10 Spain 0
11 Argentina 0
   country revenue
1 Austria 5227
2 France 1170
3 Mexico 126
4 Switzerland 75
5 Germany 0
6 Canada 0
7 UK 0
8 Sweden 0
9 Brazil 0
10 Spain 0
11 Argentina 0
   country categoryid revenue
1 Austria 1 1090
2 Austria 2 1365
3 Austria 3 1020
4 Austria 4 192
5 Austria 8 1560
   country categoryid revenue
1 Austria 1 1090
2 Austria 2 1365
3 Austria 3 1020
4 Austria 4 192
5 Austria 8 1560
   customerid total_spend total_order avg_spend
1 7 1170 1 1170
2 13 126 1 126
3 14 75 1 75
4 20 5227 2 2613
   customerid total_spend total_order avg_spend
1 7 1170 1 1170
2 13 126 1 126
3 14 75 1 75
4 20 5227 2 2613
   categoryid categoryname productid quantity rank_num
1 1 Beverages 2 105 1
2 1 Beverages 24 73 2
3 1 Beverages 39 48 3
4 1 Beverages 43 25 4
5 1 Beverages 35 24 5
6 2 Condiments 5 77 1
7 2 Condiments 44 37 2
8 2 Condiments 15 20 3
9 3 Confections 16 95 1
10 3 Confections 20 46 2
11 3 Confections 27 40 3
12 3 Confections 49 40 3
13 3 Confections 21 30 5
14 4 Dairy Products 33 129 1
15 4 Dairy Products 31 75 2
16 4 Dairy Products 12 12 3
17 4 Dairy Products 11 12 3
18 4 Dairy Products 32 6 5
19 5 Grains/Cereals 42 10 1
20 5 Grains/Cereals 22 6 2
21 6 Meat/Poultry 17 45 1
22 6 Meat/Poultry 29 10 2
23 7 Produce 28 20 1
24 7 Produce 7 15 2
25 7 Produce 14 9 3
26 8 Seafood 40 110 1
27 8 Seafood 30 66 2
28 8 Seafood 36 55 3
29 8 Seafood 41 51 4
30 8 Seafood 10 39 5
   categoryid categoryname productid quantity dense_rank_num
1 1 Beverages 2 105 1
2 1 Beverages 24 73 2
3 1 Beverages 39 48 3
4 1 Beverages 43 25 4
5 1 Beverages 35 24 5
6 2 Condiments 5 77 1
7 2 Condiments 44 37 2
8 2 Condiments 15 20 3
9 3 Confections 16 95 1
10 3 Confections 20 46 2
11 3 Confections 27 40 3
12 3 Confections 49 40 3
13 3 Confections 21 30 4
14 3 Confections 19 19 5
15 4 Dairy Products 33 129 1
16 4 Dairy Products 31 75 2
17 4 Dairy Products 12 12 3
18 4 Dairy Products 11 12 3
19 4 Dairy Products 32 6 4
20 5 Grains/Cereals 42 10 1
21 5 Grains/Cereals 22 6 2
22 6 Meat/Poultry 17 45 1
23 6 Meat/Poultry 29 10 2
24 7 Produce 28 20 1
25 7 Produce 7 15 2
26 7 Produce 14 9 3
27 8 Seafood 40 110 1
28 8 Seafood 30 66 2
29 8 Seafood 36 55 3
30 8 Seafood 41 51 4
31 8 Seafood 10 39 5
   categoryid categoryname productid quantity row_num
1 1 Beverages 2 105 1
2 1 Beverages 24 73 2
3 1 Beverages 39 48 3
4 1 Beverages 43 25 4
5 1 Beverages 35 24 5
6 2 Condiments 5 77 1
7 2 Condiments 44 37 2
8 2 Condiments 15 20 3
9 3 Confections 16 95 1
10 3 Confections 20 46 2
11 3 Confections 27 40 3
12 3 Confections 49 40 4
13 3 Confections 21 30 5
14 4 Dairy Products 33 129 1
15 4 Dairy Products 31 75 2
16 4 Dairy Products 12 12 3
17 4 Dairy Products 11 12 4
18 4 Dairy Products 32 6 5
19 5 Grains/Cereals 42 10 1
20 5 Grains/Cereals 22 6 2
21 6 Meat/Poultry 17 45 1
22 6 Meat/Poultry 29 10 2
23 7 Produce 28 20 1
24 7 Produce 7 15 2
25 7 Produce 14 9 3
26 8 Seafood 40 110 1
27 8 Seafood 30 66 2
28 8 Seafood 36 55 3
29 8 Seafood 41 51 4
30 8 Seafood 10 39 5
   categoryid categoryname productid quantity buckets
1 4 Dairy Products 33 129 1
2 8 Seafood 40 110 1
3 1 Beverages 2 105 1
4 3 Confections 16 95 1
5 2 Condiments 5 77 1
6 4 Dairy Products 31 75 1
7 1 Beverages 24 73 1
8 8 Seafood 30 66 2
9 8 Seafood 36 55 2
10 8 Seafood 41 51 2
11 1 Beverages 39 48 2
12 3 Confections 20 46 2
13 6 Meat/Poultry 17 45 2
14 3 Confections 49 40 2
15 3 Confections 27 40 3
16 8 Seafood 10 39 3
17 2 Condiments 44 37 3
18 3 Confections 21 30 3
19 1 Beverages 43 25 3
20 1 Beverages 35 24 3
21 2 Condiments 15 20 3
22 7 Produce 28 20 4
23 3 Confections 19 19 4
24 7 Produce 7 15 4
25 4 Dairy Products 12 12 4
26 4 Dairy Products 11 12 4
27 5 Grains/Cereals 42 10 4
28 8 Seafood 13 10 5
29 6 Meat/Poultry 29 10 5
30 7 Produce 14 9 5
31 5 Grains/Cereals 22 6 5
32 4 Dairy Products 32 6 5
33 8 Seafood 37 1 5
   categoryid categoryname productid quantity row_num
1 1 Beverages 2 105 1
2 1 Beverages 24 73 2
3 1 Beverages 39 48 3
4 1 Beverages 43 25 4
5 1 Beverages 35 24 5
6 2 Condiments 5 77 1
7 2 Condiments 44 37 2
8 2 Condiments 15 20 3
9 3 Confections 16 95 1
10 3 Confections 20 46 2
11 3 Confections 27 40 3
12 3 Confections 49 40 4
13 3 Confections 21 30 5
14 4 Dairy Products 33 129 1
15 4 Dairy Products 31 75 2
16 4 Dairy Products 12 12 3
17 4 Dairy Products 11 12 4
18 4 Dairy Products 32 6 5
19 5 Grains/Cereals 42 10 1
20 5 Grains/Cereals 22 6 2
21 6 Meat/Poultry 17 45 1
22 6 Meat/Poultry 29 10 2
23 7 Produce 28 20 1
24 7 Produce 7 15 2
25 7 Produce 14 9 3
26 8 Seafood 40 110 1
27 8 Seafood 30 66 2
28 8 Seafood 36 55 3
29 8 Seafood 41 51 4
30 8 Seafood 10 39 5
   categoryid productid sales row_num
1 1 2 105 1
2 1 24 73 2
3 1 39 48 3
4 1 43 25 4
5 1 35 24 5
6 2 5 77 1
7 2 44 37 2
8 2 15 20 3
9 3 16 95 1
10 3 20 46 2
11 3 27 40 3
12 3 49 40 4
13 3 21 30 5
14 4 33 129 1
15 4 31 75 2
16 4 11 12 3
17 4 12 12 4
18 4 32 6 5
19 5 42 10 1
20 5 22 6 2
21 6 17 45 1
22 6 29 10 2
23 7 28 20 1
24 7 7 15 2
25 7 14 9 3
26 8 40 110 1
27 8 30 66 2
28 8 36 55 3
29 8 41 51 4
30 8 10 39 5
   categoryid productid sales row_num
1 1 2 105 1
2 1 24 73 2
3 1 39 48 3
4 1 43 25 4
5 1 35 24 5
6 2 5 77 1
7 2 44 37 2
8 2 15 20 3
9 3 16 95 1
10 3 20 46 2
11 3 27 40 3
12 3 49 40 4
13 3 21 30 5
14 4 33 129 1
15 4 31 75 2
16 4 11 12 3
17 4 12 12 4
18 4 32 6 5
19 5 42 10 1
20 5 22 6 2
21 6 17 45 1
22 6 29 10 2
23 7 28 20 1
24 7 7 15 2
25 7 14 9 3
26 8 40 110 1
27 8 30 66 2
28 8 36 55 3
29 8 41 51 4
30 8 10 39 5
   categoryid productid sales row_num
1 1 2 105 1
2 1 24 73 2
3 1 39 48 3
4 1 43 25 4
5 1 35 24 5
6 2 5 77 1
7 2 44 37 2
8 2 15 20 3
9 3 16 95 1
10 3 20 46 2
11 3 27 40 3
12 3 49 40 4
13 3 21 30 5
14 4 33 129 1
15 4 31 75 2
16 4 11 12 3
17 4 12 12 4
18 4 32 6 5
19 5 42 10 1
20 5 22 6 2
21 6 17 45 1
22 6 29 10 2
23 7 28 20 1
24 7 7 15 2
25 7 14 9 3
26 8 40 110 1
27 8 30 66 2
28 8 36 55 3
29 8 41 51 4
30 8 10 39 5
   customerid bev_sales condi_sales other_sales
1 7 0 0 30
2 13 0 0 11
3 14 15 0 0
4 20 78 65 126
   customerid categoryname bev_sales condi_sale other_sales
1 7 Meat/Poultry 0 0 30
2 13 Confections 0 0 10
3 13 Seafood 0 0 1
4 14 Beverages 15 0 0
5 20 Beverages 78 0 0
6 20 Condiments 0 65 0
7 20 Confections 0 0 60
8 20 Dairy Products 0 0 6
9 20 Seafood 0 0 60
   customerid categoryname bev_sales condi_sale other_sales
1 7 Meat/Poultry 0 0 30
2 13 Confections 0 0 10
3 13 Seafood 0 0 1
4 14 Beverages 15 0 0
5 20 Beverages 78 0 0
6 20 Condiments 0 65 0
7 20 Confections 0 0 60
8 20 Dairy Products 0 0 6
9 20 Seafood 0 0 60
   categoryid productid med
1 1 35 20
2 1 2 20
3 2 15 20
4 3 21 20
5 4 33 20
6 4 31 20
7 5 22 6
8 5 42 10
9 6 17 15
10 7 7 15
11 8 10 24