ABCDEFG
1
40180120a_Tiendaa_CentroAcum_Px
2
Tienda
GéneroAcum_PHSCOXM Zona Centro$1,584,355
3
ALibros - Novela$854,599HSCOXM Zona Sur$1,469,522
4
BLibros - Ciencia Ficción$348,857HSCOXM Zona Poniente$101,610
5
AVideo - Aventura$320,693
6
BVideo - Serie$143,870
7
ALibros - Ciencia$137,636
8
Otros$977,879
9
SELECT
Tienda,
Departamento,
sum(FLOAT(Pesos)) as Acum_P
FROM
[my-tests-project-161016:170330_AFC.Sales]
WHERE
Tienda = "HSCO"
GROUP BY
Tienda,
Departamento
ORDER BY
Acum_P desc
10
Tienda
DepartamentoAcum_P
11
AAAA$854,599
12
AAAB$348,857
13
AAAA$320,693
14
AAAB$143,870
15
AAAA$137,636
16
AAAB$119,950
17
AAAA$74,742
18
AAAB$65,621
19
AAAA$61,086
20
AAAB$58,419
21
AAAA$56,517
22
AAAB$55,105
23
AAAA$51,977
24
AAAB$44,870
25
AAAA$43,416
26
AAAB$35,977
27
AAAA$30,706
28
AAAB$27,362
29
AAAA$27,142
30
AAAB$24,174
31
AAAA$23,951
32
AAAB$19,594
33
AAAA$18,097
34
AAAB$14,361
35
AAAA$13,517
36
AAAB$12,278
37
AAAA$11,717
38
AAAB$10,616
39
AAAA$10,197
40
AAAB$9,661
41
AAAA$7,236
42
AAAB$6,324
43
AAAA$6,117
44
AAAB$4,409
45
AAAA$4,273
46
AAAB$4,218
47
AAAA$3,819
48
AAAB$2,974
49
AAAA$2,893
50
AAAB$2,714
51
AAAA$2,454
52
AAAB$2,153
53
AAAA$1,206
54
AAAB$1,085
55
AAAA$1,077
56
AAAB$784
57
AAAA$775
58
AAAB$633
59
AAAA559.48276
60
AAAB516.37931
61
AAAA361.46552
62
AAAB240.77586
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100