diff options
Diffstat (limited to 'src/s3select/TPCDS/sample-queries-tpcds/query48.sql')
-rw-r--r-- | src/s3select/TPCDS/sample-queries-tpcds/query48.sql | 67 |
1 files changed, 67 insertions, 0 deletions
diff --git a/src/s3select/TPCDS/sample-queries-tpcds/query48.sql b/src/s3select/TPCDS/sample-queries-tpcds/query48.sql new file mode 100644 index 000000000..da87862a3 --- /dev/null +++ b/src/s3select/TPCDS/sample-queries-tpcds/query48.sql @@ -0,0 +1,67 @@ +-- start query 1 in stream 0 using template query48.tpl and seed 622697896 +select sum (ss_quantity) + from store_sales, store, customer_demographics, customer_address, date_dim + where s_store_sk = ss_store_sk + and ss_sold_date_sk = d_date_sk and d_year = 1998 + and + ( + ( + cd_demo_sk = ss_cdemo_sk + and + cd_marital_status = 'M' + and + cd_education_status = 'Unknown' + and + ss_sales_price between 100.00 and 150.00 + ) + or + ( + cd_demo_sk = ss_cdemo_sk + and + cd_marital_status = 'W' + and + cd_education_status = 'College' + and + ss_sales_price between 50.00 and 100.00 + ) + or + ( + cd_demo_sk = ss_cdemo_sk + and + cd_marital_status = 'D' + and + cd_education_status = 'Primary' + and + ss_sales_price between 150.00 and 200.00 + ) + ) + and + ( + ( + ss_addr_sk = ca_address_sk + and + ca_country = 'United States' + and + ca_state in ('MI', 'GA', 'NH') + and ss_net_profit between 0 and 2000 + ) + or + (ss_addr_sk = ca_address_sk + and + ca_country = 'United States' + and + ca_state in ('TX', 'KY', 'SD') + and ss_net_profit between 150 and 3000 + ) + or + (ss_addr_sk = ca_address_sk + and + ca_country = 'United States' + and + ca_state in ('NY', 'OH', 'FL') + and ss_net_profit between 50 and 25000 + ) + ) +; + +-- end query 1 in stream 0 using template query48.tpl |