| 1234567891011121314151617181920212223242526 |
- -- start query 1 in stream 0 using template query86.tpl and seed 1819994127
- select
- sum(ws_net_paid) as total_sum
- ,i_category
- ,i_class
- ,grouping(i_category)+grouping(i_class) as lochierarchy
- ,rank() over (
- partition by grouping(i_category)+grouping(i_class),
- case when grouping(i_class) = 0 then i_category end
- order by sum(ws_net_paid) desc) as rank_within_parent
- from
- web_sales
- ,date_dim d1
- ,item
- where
- d1.d_month_seq between 1215 and 1215+11
- and d1.d_date_sk = ws_sold_date_sk
- and i_item_sk = ws_item_sk
- group by rollup(i_category,i_class)
- order by
- lochierarchy desc,
- case when lochierarchy = 0 then i_category end,
- rank_within_parent
- limit 100;
- -- end query 1 in stream 0 using template query86.tpl
|
