blob: 4d2e71760d8701c2235ff85471c3953188e97f95 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
SELECT
dt.d_year,
item.i_category_id,
item.i_category,
sum(ss_ext_sales_price)
FROM date_dim dt, store_sales, item
WHERE dt.d_date_sk = store_sales.ss_sold_date_sk
AND store_sales.ss_item_sk = item.i_item_sk
AND item.i_manager_id = 1
AND dt.d_moy = 11
AND dt.d_year = 2000
GROUP BY dt.d_year
, item.i_category_id
, item.i_category
ORDER BY sum(ss_ext_sales_price) DESC, dt.d_year
, item.i_category_id
, item.i_category
LIMIT 100
|