resources/tpcds-modifiedQueries/q42.sql

0001 -- start query 42 in stream 0 using template query42.tpl
0002 select
0003   dt.d_year,
0004   item.i_category_id,
0005   item.i_category,
0006   sum(ss_ext_sales_price)
0007 from
0008   date_dim dt,
0009   store_sales,
0010   item
0011 where
0012   dt.d_date_sk = store_sales.ss_sold_date_sk
0013   and store_sales.ss_item_sk = item.i_item_sk
0014   and item.i_manager_id = 1
0015   and dt.d_moy = 12
0016   and dt.d_year = 1998
0017   and ss_sold_date_sk between 2451149 and 2451179  -- partition key filter
0018 group by
0019   dt.d_year,
0020   item.i_category_id,
0021   item.i_category
0022 order by
0023   sum(ss_ext_sales_price) desc,
0024   dt.d_year,
0025   item.i_category_id,
0026   item.i_category
0027 limit 100
0028 -- end query 42 in stream 0 using template query42.tpl