D_YEAR I_CATEGORY_ID I_CATEGORY SUM(SS_EXT_SALES_PRICE) | |
---------- ------------- -------------------------------------------------- ----------------------- | |
2000 7 Home 458017.85 | |
2000 3 Children 370261.29 | |
2000 2 Men 368718.95 | |
2000 1 Women 320132.43 | |
2000 10 Electronics 281421.74 | |
2000 5 Music 223420.7 | |
2000 4 Shoes 221242.25 | |
2000 8 Sports 200806.45 | |
2000 6 Jewelry 167920.91 | |
2000 9 Books 161721.11 | |
10 rows selected. | |