java LocationRollUp city 3 0 city , Number of Sales , Total number of sold items , Total $$ made Los Angeles 2650 7911 32810.78 San Diego 946 2945 12403.96 Olympia 922 2765 11318.63 Tucson 889 2741 11210.24 Santa Barbara 938 2787 11181.99 Portland 947 2816 11089.06 San Francisco 897 2805 11042.11 Flagstaff 930 2815 11022.58 Sacramento 883 2650 10950.36 San Jose 924 2780 10878.13 San Luis Obispo 855 2539 10831.21 Monterey 886 2615 10751.52 Stockton 884 2643 10486.51 Las Vegas 869 2617 10381.71 Bakersfield 820 2411 9629.67 Reno 817 2456 9606.73 Phoenix 817 2418 9565.66 Seattle 861 2521 9467.89 java LocationRollUp zip 2 1 a zip , AVG Number of Sales , AVG number of sold items , AVG $$ made 93308 820 2411 9629.67 85016 817 2418 9565.66 89507 817 2456 9606.73 98111 861 2521 9467.89 90001 854.5 2530 10578.69 93405 855 2539 10831.21 93943 886 2615 10751.52 89101 869 2617 10381.71 95208 884 2643 10486.51 94211 883 2650 10950.36 85701 889 2741 11210.24 98512 922 2765 11318.63 95106 924 2780 10878.13 93108 938 2787 11181.99 94171 897 2805 11042.11 86001 930 2815 11022.58 97209 947 2816 11089.06 90081 941 2851 11653.39 92110 946 2945 12403.96 java LocationRollUp location 1 0 d Store , Number of Sales , Total number of sold items , Total $$ made 13 947 2816 11089.06 6 946 2945 12403.96 3 941 2851 11653.39 8 938 2787 11181.99 19 930 2815 11022.58 7 924 2780 10878.13 15 922 2765 11318.63 1 897 2805 11042.11 20 889 2741 11210.24 9 886 2615 10751.52 12 884 2643 10486.51 11 883 2650 10950.36 17 869 2617 10381.71 5 864 2524 10559.55 14 861 2521 9467.89 2 855 2539 10831.21 4 845 2536 10597.84 10 820 2411 9629.67 16 817 2456 9606.73 18 817 2418 9565.66 java LocationRollUpSlice location item Chocolate Cake 2 0 d Store , Number of Sales , Total number of sold items , Total $$ made 6 946 2945 12403.96 3 941 2851 11653.39 13 947 2816 11089.06 19 930 2815 11022.58 1 897 2805 11042.11 8 938 2787 11181.99 7 924 2780 10878.13 15 922 2765 11318.63 20 889 2741 11210.24 11 883 2650 10950.36 12 884 2643 10486.51 17 869 2617 10381.71 9 886 2615 10751.52 2 855 2539 10831.21 4 845 2536 10597.84 5 864 2524 10559.55 14 861 2521 9467.89 16 817 2456 9606.73 18 817 2418 9565.66 10 820 2411 9629.67 java LocationRollUpSlice state type Drink 1 1 state , AVG Number of Sales , AVG number of sold items , AVG $$ made OR 204 619 1549.91 AZ 191.33 592 1471.16 NV 191 584.5 1410.88 CA 186.41 565.5 1383.76 WA 184.5 551 1332.76 java LocationRollUpSlice zip Food Cookie 3 0 a zip , Number of Sales , Total number of sold items , Total $$ made 98111 861 2521 9467.89 85016 817 2418 9565.66 89507 817 2456 9606.73 93308 820 2411 9629.67 89101 869 2617 10381.71 95208 884 2643 10486.51 93943 886 2615 10751.52 93405 855 2539 10831.21 95106 924 2780 10878.13 94211 883 2650 10950.36 86001 930 2815 11022.58 94171 897 2805 11042.11 97209 947 2816 11089.06 93108 938 2787 11181.99 85701 889 2741 11210.24 98512 922 2765 11318.63 90081 941 2851 11653.39 92110 946 2945 12403.96 90001 1709 5060 21157.39 java TimeRollUp month location 0 0 d Month , location , Number of Sales , Total number of sold items , Total $$ made 12 1 81 244 1266.69 11 1 72 221 848.91 10 1 78 254 1054.25 09 1 66 213 735.55 08 1 55 166 726 07 1 68 200 760.45 06 1 66 219 873.66 05 1 96 302 1167.39 04 1 52 158 571.78 03 1 88 288 1318.34 02 1 69 202 686.74 01 1 106 338 1032.35 01 2 855 2539 10831.21 01 3 941 2851 11653.39 01 4 845 2536 10597.84 01 5 864 2524 10559.55 01 6 946 2945 12403.96 01 7 924 2780 10878.13 01 8 938 2787 11181.99 01 9 886 2615 10751.52 01 10 820 2411 9629.67 01 11 883 2650 10950.36 01 12 884 2643 10486.51 01 13 947 2816 11089.06 01 14 861 2521 9467.89 01 15 922 2765 11318.63 01 16 817 2456 9606.73 01 17 869 2617 10381.71 01 18 817 2418 9565.66 01 19 930 2815 11022.58 01 20 889 2741 11210.24 java TimeRollUp day state 0 1 d Day , state , AVG Number of Sales , AVG number of sold items , AVG $$ made 29 AZ 885.61 2688.67 10753.03 29 CA 886.61 2657.17 10860.08 29 NV 827.61 2488.85 9764.88 29 OR 947 2816 11089.06 29 WA 898.19 2669.78 10596.39 28 AZ 890.64 2712.17 10877.55 28 CA 887.46 2663.39 10876.67 28 NV 842.13 2533.81 9981.30 28 OR 947 2816 11089.06 28 WA 889.59 2635.37 10335.42 27 AZ 891 2706 10806.26 27 CA 888.34 2666.38 10919.17 27 NV 838.66 2523.08 9929.63 27 OR 947 2816 11089.06 27 WA 884.23 2613.95 10172.93 26 AZ 880.91 2669.47 10665.15 26 CA 882.55 2648.00 10774.13 26 NV 846.71 2548 10049.57 26 OR 947 2816 11089.06 26 WA 894.88 2656.55 10496.07 25 AZ 887.06 2688.06 10713.54 25 CA 885.74 2660.74 10834.71 25 NV 853.70 2569.64 10153.77 25 OR 947 2816 11089.06 25 WA 889.37 2634.48 10328.69 24 AZ 873.22 2645.25 10594.47 24 CA 892.47 2684.57 10964.84 24 NV 840.21 2527.87 9952.70 24 OR 947 2816 11089.06 24 WA 893.53 2651.13 10454.95 23 AZ 896.93 2723.13 10844.92 23 CA 893.62 2688.00 10942.14 23 NV 850.54 2559.87 10106.71 23 OR 947 2816 11089.06 23 WA 900.56 2679.27 10668.37 22 AZ 877.41 2661.90 10668.34 22 CA 887.34 2669.84 10862.10 22 NV 844.92 2542.46 10022.92 22 OR 947 2816 11089.06 22 WA 888.64 2631.56 10306.50 21 AZ 885.27 2688.98 10764.23 21 CA 887.28 2658.28 10860.18 21 NV 836.5 2516.37 9897.34 21 OR 947 2816 11089.06 21 WA 888 2629 10287.07 20 AZ 884.88 2677.68 10657.63 20 CA 893.90 2686.89 10979.63 20 NV 849.93 2557.96 10097.55 20 OR 947 2816 11089.06 20 WA 884.36 2614.44 10176.68 19 AZ 884.83 2679.42 10676.57 19 CA 894.80 2701.03 10982.73 19 NV 842.39 2534.62 9985.20 19 OR 947 2816 11089.06 19 WA 893.29 2650.17 10447.69 18 AZ 859.44 2591.12 10358.46 18 CA 891.27 2672.62 10888.77 18 NV 844.62 2541.53 10018.43 18 OR 947 2816 11089.06 18 WA 894.27 2654.09 10477.38 17 AZ 883.74 2678.85 10695.91 17 CA 888.53 2664.64 10910.02 17 NV 835.30 2512.69 9879.60 17 OR 947 2816 11089.06 17 WA 901.66 2683.66 10701.71 16 AZ 875.41 2647.54 10567.35 16 CA 887.22 2664.13 10853.60 16 NV 839.75 2526.43 9945.78 16 OR 947 2816 11089.06 16 WA 913.97 2732.89 11075.11 15 AZ 872.17 2632.73 10490.66 15 CA 891.79 2675.98 10893.51 15 NV 842.36 2534.53 9984.76 15 OR 947 2816 11089.06 15 WA 894.37 2654.50 10480.55 14 AZ 893.88 2714.07 10822.28 14 CA 891.52 2675.16 10900.64 14 NV 843.57 2538.28 10002.83 14 OR 947 2816 11089.06 14 WA 896.04 2661.17 10531.08 13 AZ 898.86 2732.17 10892.80 13 CA 881.93 2645.03 10777.87 13 NV 836.37 2515.98 9895.44 13 OR 947 2816 11089.06 13 WA 892.17 2645.71 10413.82 12 AZ 882.00 2673.93 10685.43 12 CA 888.42 2671.18 10930.62 12 NV 838.58 2522.83 9928.42 12 OR 947 2816 11089.06 12 WA 894.45 2654.80 10482.81 11 AZ 879.92 2662.41 10615.68 11 CA 885.30 2663.19 10868.57 11 NV 842.46 2534.85 9986.31 11 OR 947 2816 11089.06 11 WA 892.24 2645.97 10415.83 10 AZ 875.40 2641.12 10502.08 10 CA 893.33 2686.52 10940.69 10 NV 845.26 2543.5 10027.91 10 OR 947 2816 11089.06 10 WA 893.29 2650.17 10447.69 09 AZ 884.94 2680.05 10680.43 09 CA 890.00 2670.09 10939.42 09 NV 843 2536.5 9994.22 09 OR 947 2816 11089.06 09 WA 889.26 2634.07 10325.55 08 AZ 891.72 2704.55 10774.72 08 CA 887.61 2669.30 10870.95 08 NV 843.53 2538.14 10002.12 08 OR 947 2816 11089.06 08 WA 892.51 2647.06 10424.10 07 AZ 879.25 2647.70 10480.67 07 CA 890.05 2679.77 10884.85 07 NV 840.71 2529.43 9960.22 07 OR 947 2816 11089.06 07 WA 890.82 2640.28 10372.69 06 AZ 873.30 2647.56 10616.39 06 CA 884.28 2655.20 10821.00 06 NV 832.82 2505 9842.59 06 OR 947 2816 11089.06 06 WA 876.25 2582 9930.57 05 AZ 903.36 2740.05 10869.60 05 CA 897.90 2706.67 10984.79 05 NV 845.54 2544.39 10032.20 05 OR 947 2816 11089.06 05 WA 895.52 2659.11 10515.47 04 AZ 877.92 2652.07 10555.86 04 CA 889.52 2666.92 10855.19 04 NV 838.47 2522.5 9926.83 04 OR 947 2816 11089.06 04 WA 885.95 2620.81 10225.01 03 AZ 905.54 2755 10972.24 03 CA 890.84 2672.87 10875.36 03 NV 832.36 2503.56 9835.70 03 OR 947 2816 11089.06 03 WA 899.81 2676.27 10645.63 02 AZ 866.15 2620.42 10503.53 02 CA 888.02 2676.49 10902.59 02 NV 833.48 2507.04 9852.45 02 OR 947 2816 11089.06 02 WA 896.19 2661.76 10535.62 01 AZ 893.20 2708.48 10780.77 01 CA 888.50 2683.76 10918.43 01 NV 840.21 2527.87 9952.70 01 OR 947 2816 11089.06 01 WA 889.89 2636.57 10344.55 java TimeRollUp week zip 1 0 a Week , zip , Number of Sales , Total number of sold items , Total $$ made 13 94171 3 7 64.15 34 94171 4 14 55 19 94171 5 19 34.45 22 94171 6 23 74.35 14 94171 6 15 50.33 26 94171 6 15 55.85 39 94171 8 26 72.71 46 94171 8 28 111.61 25 94171 9 23 109.02 0 94171 10 28 88.35 40 94171 10 28 70.08 37 94171 10 25 75.57 8 94171 11 30 110.04 32 94171 11 36 180.75 30 94171 12 32 161.78 4 94171 12 42 125.45 15 94171 12 40 118.8 49 94171 12 39 204.25 50 94171 12 36 149.26 12 94171 14 50 158.05 42 94171 14 48 167.4 45 94171 15 40 175.36 43 94171 16 60 376.26 28 94171 16 47 118.13 38 94171 16 60 242.4 35 94171 16 51 161.17 11 94171 16 53 232.55 16 94171 17 52 161 7 94171 17 48 152.78 33 94171 17 56 274.7 52 94171 18 55 440.57 5 94171 18 49 202.29 29 94171 18 59 200.14 3 94171 19 49 142.72 27 94171 19 55 264.55 6 94171 20 66 210.18 51 94171 21 64 319.1 24 94171 21 77 300.53 47 94171 21 72 244.63 44 94171 22 65 274.34 10 94171 23 66 318.16 31 94171 23 60 215.55 48 94171 24 66 196.48 21 94171 24 82 347.78 36 94171 24 77 256.41 18 94171 24 73 279.89 23 94171 27 88 349.76 20 94171 27 77 304.47 17 94171 30 95 378.3 41 94171 30 92 367.8 1 94171 32 102 325.54 2 94171 33 117 350.29 9 94171 38 128 621.03 0 89101 63 213 890.16 0 93943 66 179 671.42 0 98111 70 194 569.34 0 85016 71 181 825.68 0 95106 72 218 1035.42 0 90081 82 256 884.45 0 85701 89 273 1087.28 0 93308 92 277 1220.57 0 97209 92 250 925.01 0 93405 93 289 1120.13 0 89507 97 291 864.12 0 98512 102 330 1235.12 0 93108 102 321 1108.33 0 95208 102 322 1312.68 0 86001 106 309 1241.08 0 92110 114 374 1548.42 4 85016 116 337 1490.61 4 95208 118 356 1260.24 4 98512 121 344 1367.72 0 94211 122 354 1351.27 4 90081 126 375 1610.84 4 93108 129 397 1525 4 98111 129 396 1471.93 4 92110 131 401 1746.63 1 93405 146 441 1936.04 0 90001 147 427 1817 4 89507 147 470 1803.13 2 98111 154 449 1750.63 3 93308 156 460 1875.3 4 94211 159 494 2252.77 3 89507 161 480 1841.44 4 89101 164 513 1896.74 4 93405 165 474 1907.53 4 93308 166 468 1847.26 4 93943 168 500 1760.56 4 95106 168 498 1797.72 1 85701 170 520 2465.81 4 86001 172 523 2155.33 4 97209 182 555 2376.47 1 85016 182 547 2229.52 4 85701 185 570 2318.47 1 89507 186 527 2250.56 1 94211 188 548 2473.6 2 95106 189 560 2171.85 3 93943 191 574 2608.49 3 86001 191 564 2169 2 94211 199 603 2285.36 1 93308 199 588 2246.9 1 95208 206 608 2678.16 2 95208 206 611 2245.15 1 89101 207 651 2763.07 2 93308 207 618 2439.64 2 97209 207 608 2315.21 2 93108 209 610 2195.9 2 92110 212 650 2866.14 2 89101 212 624 2415.99 3 97209 213 640 2498.35 2 93405 215 650 2937.47 3 94211 215 651 2587.36 1 98512 218 653 2634.5 2 93943 219 658 2552.45 3 85701 221 691 2526.06 3 85016 223 688 2646.57 3 89101 223 616 2415.75 2 85701 224 687 2812.62 2 85016 225 665 2373.28 2 89507 226 688 2847.48 1 95106 227 685 2860.52 2 86001 229 684 2572.63 1 93108 231 677 2915.87 1 86001 232 735 2884.54 2 90081 234 707 2773.03 3 98512 235 709 2858.87 1 92110 236 742 3195.52 3 93405 236 685 2930.04 1 93943 242 704 3158.6 1 90081 242 753 3396.4 2 98512 246 729 3222.42 3 98111 247 740 2843.9 3 95208 252 746 2990.28 3 92110 253 778 3047.25 1 97209 253 763 2974.02 3 90081 257 760 2988.67 1 98111 261 742 2832.09 3 93108 267 782 3436.89 3 95106 268 819 3012.62 4 90001 330 950 4083.97 1 90001 384 1130 4719.03 3 90001 420 1291 5244.96 2 90001 428 1262 5292.43 java EmployeeSlice Manager June June Employee Type, Month, Number of Sales, Total # of sold items, Total $$ made Manager 06 27 96 262.08 java EmployeeSlice Full January May Employee Type, Month, Number of Sales, Total # of sold items, Total $$ made Barista 01 494 1476 6113.04 Cashier 01 1174 3482 13939.67 Manager 01 13785 41313 166407.72 Shift Manager 01 1099 3317 13514.95 Cashier 02 11 34 104.78 Manager 02 30 89 305.99 Cashier 03 17 55 167.13 Manager 03 26 89 429.63 Cashier 04 15 39 119.47 Manager 04 28 90 353.81 Cashier 05 7 25 53.95 Manager 05 52 159 587.55 java EmployeeSlice Barista January December Employee Type, Month, Number of Sales, Total # of sold items, Total $$ made Barista 01 886 2656 10756.64 Barista 02 28 79 275.97 Barista 03 45 144 721.58 Barista 04 9 29 98.5 Barista 05 37 118 525.89 Barista 06 21 53 217.12 Barista 07 15 53 186.02 Barista 08 7 23 172.35 Barista 09 19 62 247.42 Barista 10 26 76 370.72 Barista 11 29 93 320.53 Barista 12 26 90 444.14 java StoreRank 1 3 state Chocolate Cake Rank of location 1: 1 out of 12 java StoreRank 1 2 July Drink Rank of location 1: 1 out of 1 java StoreRank 5 1 January Rank of location 5: 13 out of 20