framework/resources/Functional/tpcds/impala/json/q42.q

select
  d.d_year,
  i.i_category_id,
  i.i_category,
  sum(ss.ss_ext_sales_price)
from
  date_dim as d,
  store_sales as ss,
  item as i
where
  d.d_date_sk = ss.ss_sold_date_sk
  and ss.ss_item_sk = i.i_item_sk
  and i.i_manager_id = 1
  and d.d_moy = 12
  and d.d_year = 1998
  and ss.ss_sold_date_sk between 2451149 and 2451179  -- partition key filter
group by
  d.d_year,
  i.i_category_id,
  i.i_category
order by
  sum(ss.ss_ext_sales_price) desc,
  d.d_year,
  i.i_category_id,
  i.i_category
limit 100;