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

   1 -- start query 1 in stream 0 using template query98.tpl and seed 345591136
   2 select i_item_id
   3       ,i_item_desc
   4       ,i_category
   5       ,i_class
   6       ,i_current_price
   7       ,sum(ss_ext_sales_price) as itemrevenue
   8       ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over
   9           (partition by i_class) as revenueratio
  10 from
  11         store_sales
  12         ,item
  13         ,date_dim
  14 where
  15         ss_item_sk = i_item_sk
  16         and i_category in ('Home', 'Sports', 'Men')
  17         and ss_sold_date_sk = d_date_sk
  18         and d_date between cast('2002-01-05' as date)
  19                                 and (cast('2002-01-05' as date) + interval '30' day)
  20 group by
  21         i_item_id
  22         ,i_item_desc
  23         ,i_category
  24         ,i_class
  25         ,i_current_price
  26 order by
  27         i_category
  28         ,i_class
  29         ,i_item_id
  30         ,i_item_desc
  31         ,revenueratio;
  32
  33 -- end query 1 in stream 0 using template query98.tpl