Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
executable file 33 lines (32 sloc) 814 Bytes
-- start query 98 in stream 0 using template query98.tpl
select
i_item_desc,
i_category,
i_class,
i_current_price,
sum(ss_ext_sales_price) as itemrevenue,
sum(ss_ext_sales_price) * 100 / sum(sum(ss_ext_sales_price)) over (partition by i_class) as revenueratio
from
store_sales,
item,
date_dim
where
ss_item_sk = i_item_sk
and i_category in ('Jewelry', 'Sports', 'Books')
and ss_sold_date_sk = d_date_sk
and ss_sold_date_sk between 2451911 and 2451941 -- partition key filter (1 calendar month)
and d_date between '2001-01-01' and '2001-01-31'
group by
i_item_id,
i_item_desc,
i_category,
i_class,
i_current_price
order by
i_category,
i_class,
i_item_id,
i_item_desc,
revenueratio;
--limit 1000; -- added limit
-- end query 98 in stream 0 using template query98.tpl