ceph/src/s3select/TPCDS/sample-queries-tpcds/query22.sql

   1 -- start query 1 in stream 0 using template query22.tpl and seed 1819994127
   2 select  i_product_name
   3              ,i_brand
   4              ,i_class
   5              ,i_category
   6              ,avg(inv_quantity_on_hand) qoh
   7        from inventory
   8            ,date_dim
   9            ,item
  10        where inv_date_sk=d_date_sk
  11               and inv_item_sk=i_item_sk
  12               and d_month_seq between 1186 and 1186 + 11
  13        group by rollup(i_product_name
  14                        ,i_brand
  15                        ,i_class
  16                        ,i_category)
  17 order by qoh, i_product_name, i_brand, i_class, i_category
  18 limit 100;
  19
  20 -- end query 1 in stream 0 using template query22.tpl