diff options
Diffstat (limited to 'src/s3select/TPCDS/sample-queries-tpcds/query61.sql')
| -rw-r--r-- | src/s3select/TPCDS/sample-queries-tpcds/query61.sql | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/src/s3select/TPCDS/sample-queries-tpcds/query61.sql b/src/s3select/TPCDS/sample-queries-tpcds/query61.sql new file mode 100644 index 000000000..4be762663 --- /dev/null +++ b/src/s3select/TPCDS/sample-queries-tpcds/query61.sql @@ -0,0 +1,44 @@ +-- start query 1 in stream 0 using template query61.tpl and seed 1930872976 +select promotions,total,cast(promotions as decimal(15,4))/cast(total as decimal(15,4))*100 +from + (select sum(ss_ext_sales_price) promotions + from store_sales + ,store + ,promotion + ,date_dim + ,customer + ,customer_address + ,item + where ss_sold_date_sk = d_date_sk + and ss_store_sk = s_store_sk + and ss_promo_sk = p_promo_sk + and ss_customer_sk= c_customer_sk + and ca_address_sk = c_current_addr_sk + and ss_item_sk = i_item_sk + and ca_gmt_offset = -6 + and i_category = 'Sports' + and (p_channel_dmail = 'Y' or p_channel_email = 'Y' or p_channel_tv = 'Y') + and s_gmt_offset = -6 + and d_year = 2001 + and d_moy = 12) promotional_sales, + (select sum(ss_ext_sales_price) total + from store_sales + ,store + ,date_dim + ,customer + ,customer_address + ,item + where ss_sold_date_sk = d_date_sk + and ss_store_sk = s_store_sk + and ss_customer_sk= c_customer_sk + and ca_address_sk = c_current_addr_sk + and ss_item_sk = i_item_sk + and ca_gmt_offset = -6 + and i_category = 'Sports' + and s_gmt_offset = -6 + and d_year = 2001 + and d_moy = 12) all_sales +order by promotions, total +limit 100; + +-- end query 1 in stream 0 using template query61.tpl |