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

   1 -- start query 1 in stream 0 using template query20.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(cs_ext_sales_price) as itemrevenue
   8        ,sum(cs_ext_sales_price)*100/sum(sum(cs_ext_sales_price)) over
   9            (partition by i_class) as revenueratio
  10  from   catalog_sales
  11      ,item
  12      ,date_dim
  13  where cs_item_sk = i_item_sk
  14    and i_category in ('Shoes', 'Electronics', 'Children')
  15    and cs_sold_date_sk = d_date_sk
  16  and d_date between cast('2001-03-14' as date)
  17                                 and (cast('2001-03-14' as date) + interval '30' day)
  18  group by i_item_id
  19          ,i_item_desc
  20          ,i_category
  21          ,i_class
  22          ,i_current_price
  23  order by i_category
  24          ,i_class
  25          ,i_item_id
  26          ,i_item_desc
  27          ,revenueratio
  28 limit 100;
  29
  30 -- end query 1 in stream 0 using template query20.tpl