Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
30 lines (28 sloc) 703 Bytes
use tpcds_orc_3000; --use this db
-- start query 1 in stream 0 using template query42.tpl
select
dt.d_year,
item.i_category_id,
item.i_category,
sum(store_sales.ss_ext_sales_price) --added the store_sales
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 = 12
and dt.d_year = 1998
and ss_sold_date_sk between 2451149 and 2451179 -- partition key filter
group by
dt.d_year,
item.i_category_id,
item.i_category
order by
sum(store_sales.ss_ext_sales_price) desc, --added the store_sales
dt.d_year,
item.i_category_id,
item.i_category
limit 100;