java LocationRollUp city 3 0 

city , Number of Sales , Total number of sold items , Total $$ made 
Los Angeles	10838			32563			132653.04
Flagstaff	3794			11444			47212.52
Seattle	3747			11385			46757.83
Sacramento	3716			11225			44969.38
Bakersfield	3647			10980			44144.01
San Luis Obispo	3546			10532			44118.12
Santa Barbara	3517			10620			43895.68
Olympia	3471			10540			43566.12
Reno	3539			10607			43100.83
Monterey	3562			10740			42924.11
Stockton	3481			10444			42884.59
Phoenix	3414			10395			42837.68
San Jose	3526			10615			42647.26
San Francisco	3564			10671			42579.21
Portland	3612			10757			42416.7
Las Vegas	3473			10449			42063.7
Tucson	3465			10373			41180.61
San Diego	3218			9626			38733.51
java LocationRollUp zip 2 1 a 

zip , AVG Number of Sales , AVG number of sold items , AVG $$ made 
92110	3218			9626			38733.51
85701	3465			10373			41180.61
85016	3414			10395			42837.68
95208	3481			10444			42884.59
89101	3473			10449			42063.7
93405	3546			10532			44118.12
98512	3471			10540			43566.12
89507	3539			10607			43100.83
95106	3526			10615			42647.26
93108	3517			10620			43895.68
94171	3564			10671			42579.21
90081	3552			10693			44088.08
93943	3562			10740			42924.11
97209	3612			10757			42416.7
90001	3643			10935			44282.48
93308	3647			10980			44144.01
94211	3716			11225			44969.38
98111	3747			11385			46757.83
86001	3794			11444			47212.52
java LocationRollUp location 1 0 d 

Store , Number of Sales , Total number of sold items , Total $$ made 
19	3794			11444			47212.52
14	3747			11385			46757.83
11	3716			11225			44969.38
4	3715			11103			44527.61
10	3647			10980			44144.01
13	3612			10757			42416.7
5	3571			10767			44037.35
1	3564			10671			42579.21
9	3562			10740			42924.11
3	3552			10693			44088.08
2	3546			10532			44118.12
16	3539			10607			43100.83
7	3526			10615			42647.26
8	3517			10620			43895.68
12	3481			10444			42884.59
17	3473			10449			42063.7
15	3471			10540			43566.12
20	3465			10373			41180.61
18	3414			10395			42837.68
6	3218			9626			38733.51
java LocationRollUpSlice location item Chocolate Cake 2 0 d 

Store , Number of Sales , Total number of sold items , Total $$ made 
19	3794			11444			47212.52
14	3747			11385			46757.83
11	3716			11225			44969.38
4	3715			11103			44527.61
10	3647			10980			44144.01
5	3571			10767			44037.35
13	3612			10757			42416.7
9	3562			10740			42924.11
3	3552			10693			44088.08
1	3564			10671			42579.21
8	3517			10620			43895.68
7	3526			10615			42647.26
16	3539			10607			43100.83
15	3471			10540			43566.12
2	3546			10532			44118.12
17	3473			10449			42063.7
12	3481			10444			42884.59
18	3414			10395			42837.68
20	3465			10373			41180.61
6	3218			9626			38733.51
java LocationRollUpSlice state type Drink 1 1 

state , AVG Number of Sales , AVG number of sold items , AVG $$ made 
WA	781.5			2335			5813.62
OR	775			2380			5862.59
AZ	769.33			2278			5607.64
CA	755.16			2252.5			5569.08
NV	753			2234.5			5409.68
java LocationRollUpSlice zip Food Cookie 3 0 a 

zip , Number of Sales , Total number of sold items , Total $$ made 
92110	3218			9626			38733.51
85701	3465			10373			41180.61
89101	3473			10449			42063.7
97209	3612			10757			42416.7
94171	3564			10671			42579.21
95106	3526			10615			42647.26
85016	3414			10395			42837.68
95208	3481			10444			42884.59
93943	3562			10740			42924.11
89507	3539			10607			43100.83
98512	3471			10540			43566.12
93108	3517			10620			43895.68
90081	3552			10693			44088.08
93405	3546			10532			44118.12
93308	3647			10980			44144.01
94211	3716			11225			44969.38
98111	3747			11385			46757.83
86001	3794			11444			47212.52
90001	7286			21870			88564.96
java TimeRollUp month location 0 0 d 

Month , location , Number of Sales , Total number of sold items , Total $$ made 
12	1	285			837			3164.33
11	1	359			1086			4360.56
10	1	301			936			3926.79
09	1	370			1109			4734.13
08	1	265			778			3413.77
07	1	306			907			3690.84
06	1	339			1051			4199.71
05	1	278			825			3473.6
04	1	309			905			3540.03
03	1	243			748			2712.92
02	1	262			747			2702.19
01	1	247			742			2660.34
01	2	3546			10532			44118.12
01	3	3552			10693			44088.08
01	4	3715			11103			44527.61
01	5	3571			10767			44037.35
01	6	3218			9626			38733.51
01	7	3526			10615			42647.26
01	8	3517			10620			43895.68
01	9	3562			10740			42924.11
01	10	3647			10980			44144.01
01	11	3716			11225			44969.38
01	12	3481			10444			42884.59
01	13	3612			10757			42416.7
01	14	3747			11385			46757.83
01	15	3471			10540			43566.12
01	16	3539			10607			43100.83
01	17	3473			10449			42063.7
01	18	3414			10395			42837.68
01	19	3794			11444			47212.52
01	20	3465			10373			41180.61
java TimeRollUp day state 0 1 d 

Day , state , AVG Number of Sales , AVG number of sold items , AVG $$ made 
29	AZ	3542.70			10678.49			43329.69
29	CA	3544.51			10649.22			43138.24
29	NV	3511.91			10542.15			42675.18
29	OR	3612			10757			42416.7
29	WA	3566.38			10832.02			44669.13
28	AZ	3551.07			10700.49			43410.68
28	CA	3534.02			10616.83			43010.98
28	NV	3511.63			10541.48			42670.8
28	OR	3612			10757			42416.7
28	WA	3550.35			10782.93			44483.73
27	AZ	3546.09			10681.56			43281.78
27	CA	3537.24			10628.42			43077.75
27	NV	3509.90			10537.35			42643.67
27	OR	3612			10757			42416.7
27	WA	3572.56			10850.96			44740.66
26	AZ	3548.03			10690.02			43347.11
26	CA	3545.20			10650.65			43155.91
26	NV	3512.24			10542.94			42680.37
26	OR	3612			10757			42416.7
26	WA	3595.2			10920.25			45002.38
25	AZ	3549.14			10696.66			43409.04
25	CA	3535.62			10620.70			42984.15
25	NV	3508			10532.78			42613.69
25	OR	3612			10757			42416.7
25	WA	3553.8			10793.5			44523.63
24	AZ	3531.32			10640.39			43106.40
24	CA	3536.44			10622.69			43033.35
24	NV	3509.23			10535.74			42633.1
24	OR	3612			10757			42416.7
24	WA	3584.35			10887.05			44876.99
23	AZ	3539.89			10666.10			43233.40
23	CA	3538.69			10631.16			43047.14
23	NV	3507.97			10532.71			42613.22
23	OR	3612			10757			42416.7
23	WA	3551.5			10786.45			44497.03
22	AZ	3553.09			10719.37			43617.25
22	CA	3540.49			10636.76			43073.00
22	NV	3514.63			10548.66			42717.89
22	OR	3612			10757			42416.7
22	WA	3550.65			10783.85			44487.22
21	AZ	3544.97			10687.42			43392.50
21	CA	3541.09			10639.13			43128.68
21	NV	3508.35			10533.64			42619.30
21	OR	3612			10757			42416.7
21	WA	3570.18			10843.67			44713.14
20	AZ	3529.75			10628.68			42986.77
20	CA	3537.96			10629.16			43057.99
20	NV	3508.2			10533.26			42616.83
20	OR	3612			10757			42416.7
20	WA	3563			10821.66			44630.02
19	AZ	3549.03			10700.62			43466.59
19	CA	3527.48			10595.66			42911.22
19	NV	3510.27			10538.22			42649.37
19	OR	3612			10757			42416.7
19	WA	3569.41			10841.31			44704.25
18	AZ	3531.28			10636.03			43047.44
18	CA	3538.33			10630.14			43092.82
18	NV	3514.18			10547.59			42710.86
18	OR	3612			10757			42416.7
18	WA	3559.08			10809.68			44584.75
17	AZ	3537.12			10655.33			43158.34
17	CA	3538.09			10629.89			43018.59
17	NV	3511.68			10541.62			42671.67
17	OR	3612			10757			42416.7
17	WA	3588.44			10899.57			44924.29
16	AZ	3531.39			10632.83			43000.38
16	CA	3536.88			10625.27			43006.97
16	NV	3515.16			10549.94			42726.31
16	OR	3612			10757			42416.7
16	WA	3575.31			10859.37			44772.43
15	AZ	3541.14			10675.30			43326.99
15	CA	3545.48			10654.18			43179.23
15	NV	3510.38			10538.49			42651.16
15	OR	3612			10757			42416.7
15	WA	3563			10821.66			44630.02
14	AZ	3535.10			10651.13			43154.16
14	CA	3536.84			10624.27			43068.84
14	NV	3509.66			10536.77			42639.88
14	OR	3612			10757			42416.7
14	WA	3563.70			10823.81			44638.14
13	AZ	3537.29			10654.82			43147.04
13	CA	3538.35			10629.01			43043.20
13	NV	3508.06			10532.93			42614.67
13	OR	3612			10757			42416.7
13	WA	3547.56			10774.42			44451.56
12	AZ	3538.32			10658.70			43172.99
12	CA	3527.21			10595.53			42932.12
12	NV	3505.09			10525.83			42568.05
12	OR	3612			10757			42416.7
12	WA	3552.96			10790.93			44513.96
11	AZ	3532.84			10637.38			43024.71
11	CA	3538.64			10631.57			43045.80
11	NV	3510.30			10538.30			42649.90
11	OR	3612			10757			42416.7
11	WA	3578.77			10869.95			44812.40
10	AZ	3533.25			10641.34			43068.32
10	CA	3537.66			10627.43			43045.64
10	NV	3509.4			10536.13			42635.69
10	OR	3612			10757			42416.7
10	WA	3576.8			10863.91			44789.61
09	AZ	3552.22			10699.25			43363.02
09	CA	3533.36			10615.39			43015.82
09	NV	3506			10528			42582.26
09	OR	3612			10757			42416.7
09	WA	3580.44			10875.08			44831.8
08	AZ	3535.70			10650.98			43136.18
08	CA	3540.18			10636.89			43115.42
08	NV	3507.85			10532.45			42611.48
08	OR	3612			10757			42416.7
08	WA	3555.17			10797.69			44539.48
07	AZ	3543.56			10679.03			43314.37
07	CA	3539.22			10631.00			43044.06
07	NV	3503.64			10522.35			42545.22
07	OR	3612			10757			42416.7
07	WA	3554.35			10795.20			44530.06
06	AZ	3539.13			10664.46			43231.00
06	CA	3538.93			10632.17			43043.12
06	NV	3504.38			10524.13			42556.88
06	OR	3612			10757			42416.7
06	WA	3550.80			10784.33			44489.02
05	AZ	3554.69			10722.75			43621.43
05	CA	3537.70			10629.25			43088.00
05	NV	3513.58			10546.15			42701.4
05	OR	3612			10757			42416.7
05	WA	3561			10815.54			44606.89
04	AZ	3526.18			10624.26			43020.59
04	CA	3537.11			10627.14			43026.25
04	NV	3509.16			10535.57			42631.99
04	OR	3612			10757			42416.7
04	WA	3580.95			10876.62			44837.61
03	AZ	3542.15			10671.15			43243.13
03	CA	3537.14			10624.49			43049.87
03	NV	3504.98			10525.56			42566.31
03	OR	3612			10757			42416.7
03	WA	3558.15			10806.84			44574.02
02	AZ	3537.65			10658.67			43190.23
02	CA	3541.43			10639.67			43073.58
02	NV	3512.11			10542.62			42678.29
02	OR	3612			10757			42416.7
02	WA	3563			10821.66			44630.02
01	AZ	3538.65			10660.05			43182.77
01	CA	3539.43			10634.72			43127.85
01	NV	3506.94			10530.25			42597.08
01	OR	3612			10757			42416.7
01	WA	3579.33			10871.68			44818.94
java TimeRollUp week zip 1 0 a 

Week , zip , Number of Sales , Total number of sold items , Total $$ made 
0 	94171	17			55			136.93
30 	94171	24			82			266.42
9 	94171	37			130			511.07
35 	94171	37			117			594.34
2 	94171	38			105			440.36
41 	94171	41			120			552.35
50 	94171	45			129			514.21
5 	94171	46			138			469.43
32 	94171	49			141			647.13
26 	94171	49			156			578.5
17 	94171	50			136			515.07
21 	94171	52			147			686.07
16 	94171	53			155			590.15
19 	94171	55			166			804.27
52 	94171	55			170			554.26
6 	94171	56			172			603.77
12 	94171	56			163			512.6
44 	94171	58			174			812.05
3 	94171	60			196			805.23
4 	94171	60			184			604.18
34 	94171	61			184			798.5
49 	94171	62			182			744.52
10 	94171	62			184			633.72
8 	94171	63			167			616.05
13 	94171	64			210			856.04
36 	94171	64			186			996.44
22 	94171	66			199			796.25
27 	94171	68			190			844.03
48 	94171	68			196			804.25
33 	94171	68			203			885.75
1 	94171	72			202			673.64
31 	94171	76			215			879.86
47 	94171	77			230			749.23
11 	94171	77			224			868.38
24 	94171	79			234			963.38
51 	94171	79			230			794.01
20 	94171	79			253			1121.23
15 	94171	79			227			879.04
29 	94171	80			253			1025.48
37 	94171	83			270			883.2
40 	94171	84			263			966.09
14 	94171	84			250			999.88
18 	94171	85			241			769.93
25 	94171	86			274			1275.61
23 	94171	87			273			977.62
43 	94171	88			272			1223.96
42 	94171	88			281			1184.39
39 	94171	89			252			960.95
7 	94171	94			262			992.04
46 	94171	95			285			1293.95
45 	94171	105			327			1258.41
28 	94171	106			297			1163.26
38 	94171	108			319			1501.73
0 	97209	308			898			3361.1
0 	93943	308			963			3731.59
0 	89101	312			924			3886.14
0 	89507	314			940			3780.58
0 	98111	323			996			4046.33
0 	92110	325			984			4069.73
0 	98512	328			963			3697.22
0 	85701	347			1002			3818.19
0 	95106	347			1057			4701.15
0 	93108	350			1073			4360.11
0 	90081	350			1079			4240.11
0 	95208	356			1048			4548.05
0 	93405	376			1138			5157.95
0 	86001	383			1152			4549.18
0 	85016	392			1195			4863.29
0 	93308	429			1283			5228.4
0 	94211	439			1330			6154.08
4 	92110	518			1512			6377.62
4 	85016	547			1613			6565.57
4 	85701	556			1663			6729.91
4 	97209	591			1752			6786.77
4 	89101	619			1848			7276.18
4 	98512	620			1907			7401.05
4 	90081	623			1836			7624.48
4 	93108	626			1875			7765.77
4 	95208	629			1872			7199.06
4 	93405	638			1905			8105.66
4 	95106	638			1874			7532.81
4 	93308	644			1957			8500.5
4 	93943	647			1998			7707.1
4 	89507	669			2031			7952.47
4 	86001	670			2015			8769.75
4 	98111	680			2055			8373.92
4 	94211	682			2007			8005.75
2 	95208	752			2261			9742.36
1 	93108	757			2311			9589.52
3 	85701	771			2317			9472.12
0 	90001	777			2366			10283.25
1 	92110	778			2316			8688.54
1 	89507	784			2357			10055.72
1 	85016	788			2437			10559.53
2 	98512	796			2488			10466.11
3 	92110	796			2356			9730.34
2 	94211	796			2396			8902.83
1 	85701	798			2427			9572.41
3 	89101	800			2485			10221.68
2 	92110	801			2458			9867.28
3 	95106	806			2410			9570.31
2 	93405	810			2441			9953.76
2 	85016	827			2522			10464.55
2 	89101	835			2498			10355.89
3 	93108	839			2501			10457.74
2 	95106	842			2536			9957.49
3 	98512	846			2564			10618.2
2 	93308	846			2552			10035.93
1 	95208	847			2505			10253.2
1 	93405	854			2450			10839.94
1 	90081	855			2566			10990.7
3 	93943	855			2564			10269.73
3 	90081	857			2545			10510.42
3 	85016	860			2628			10384.74
3 	93308	862			2578			9814.15
1 	93308	866			2610			10565.03
2 	90081	867			2667			10722.37
3 	93405	868			2598			10060.81
1 	93943	874			2603			10527.73
2 	98111	877			2646			10987.68
2 	93943	878			2612			10687.96
1 	98512	881			2618			11383.54
2 	89507	882			2611			10488.65
3 	89507	890			2668			10823.41
3 	97209	892			2662			10415.03
1 	95106	893			2738			10885.5
2 	97209	895			2722			11108.31
1 	94211	896			2688			10762.17
3 	95208	897			2758			11141.92
3 	94211	903			2804			11144.55
1 	89101	907			2694			10323.81
1 	86001	908			2743			11178.08
3 	86001	912			2762			11555
1 	98111	916			2777			11877.72
2 	86001	921			2772			11160.51
1 	97209	926			2723			10745.49
2 	93108	945			2860			11722.54
3 	98111	951			2911			11472.18
2 	85701	993			2964			11587.98
4 	90001	1281			3830			16554.77
3 	90001	1732			5214			21251.9
2 	90001	1741			5248			20378.96
1 	90001	1755			5212			20096.08
java EmployeeSlice Manager June June 

Employee Type, Month, Number of Sales, Total # of sold items, Total $$ made
Manager		06		339		1051		4199.71
java EmployeeSlice Full January May 

Employee Type, Month, Number of Sales, Total # of sold items, Total $$ made
Barista		01		3528		10680		44071.5
Cashier		01		7696		23081		91538.31
Manager		01		46989		141169		574188.16
Shift Manager	01		4862		14743		60420.1
Manager		02		262		747		2702.19
Manager		03		243		748		2712.92
Manager		04		309		905		3540.03
Manager		05		278		825		3473.6
java EmployeeSlice Barista January December 

Employee Type, Month, Number of Sales, Total # of sold items, Total $$ made
Barista		01		6517		19791		81753.13
java StoreRank 1 3 state Chocolate Cake 

Rank of location 1: 6 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: 7 out of 20