text: -- start query 42 in stream 0 using template query42.tpl
  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 = 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(ss_ext_sales_price) desc,
    dt.d_year,
    item.i_category_id,
    item.i_category
  limit 100;
  -- end query 42 in stream 0 using template query42.tpl
  