diff options
Diffstat (limited to 'src/s3select/TPCDS/sample-queries-tpcds/query67.sql')
-rw-r--r-- | src/s3select/TPCDS/sample-queries-tpcds/query67.sql | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/src/s3select/TPCDS/sample-queries-tpcds/query67.sql b/src/s3select/TPCDS/sample-queries-tpcds/query67.sql new file mode 100644 index 000000000..df485b9ce --- /dev/null +++ b/src/s3select/TPCDS/sample-queries-tpcds/query67.sql @@ -0,0 +1,44 @@ +-- start query 1 in stream 0 using template query67.tpl and seed 1819994127 +select * +from (select i_category + ,i_class + ,i_brand + ,i_product_name + ,d_year + ,d_qoy + ,d_moy + ,s_store_id + ,sumsales + ,rank() over (partition by i_category order by sumsales desc) rk + from (select i_category + ,i_class + ,i_brand + ,i_product_name + ,d_year + ,d_qoy + ,d_moy + ,s_store_id + ,sum(coalesce(ss_sales_price*ss_quantity,0)) sumsales + from store_sales + ,date_dim + ,store + ,item + where ss_sold_date_sk=d_date_sk + and ss_item_sk=i_item_sk + and ss_store_sk = s_store_sk + and d_month_seq between 1185 and 1185+11 + group by rollup(i_category, i_class, i_brand, i_product_name, d_year, d_qoy, d_moy,s_store_id))dw1) dw2 +where rk <= 100 +order by i_category + ,i_class + ,i_brand + ,i_product_name + ,d_year + ,d_qoy + ,d_moy + ,s_store_id + ,sumsales + ,rk +limit 100; + +-- end query 1 in stream 0 using template query67.tpl |