diff options
Diffstat (limited to 'src/s3select/TPCDS/sample-queries-tpcds/query46.sql')
| -rw-r--r-- | src/s3select/TPCDS/sample-queries-tpcds/query46.sql | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/src/s3select/TPCDS/sample-queries-tpcds/query46.sql b/src/s3select/TPCDS/sample-queries-tpcds/query46.sql new file mode 100644 index 000000000..1adf55dd9 --- /dev/null +++ b/src/s3select/TPCDS/sample-queries-tpcds/query46.sql @@ -0,0 +1,35 @@ +-- start query 1 in stream 0 using template query46.tpl and seed 803547492 +select c_last_name + ,c_first_name + ,ca_city + ,bought_city + ,ss_ticket_number + ,amt,profit + from + (select ss_ticket_number + ,ss_customer_sk + ,ca_city bought_city + ,sum(ss_coupon_amt) amt + ,sum(ss_net_profit) profit + from store_sales,date_dim,store,household_demographics,customer_address + where store_sales.ss_sold_date_sk = date_dim.d_date_sk + and store_sales.ss_store_sk = store.s_store_sk + and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk + and store_sales.ss_addr_sk = customer_address.ca_address_sk + and (household_demographics.hd_dep_count = 0 or + household_demographics.hd_vehicle_count= 1) + and date_dim.d_dow in (6,0) + and date_dim.d_year in (2000,2000+1,2000+2) + and store.s_city in ('Five Forks','Oakland','Fairview','Winchester','Farmington') + group by ss_ticket_number,ss_customer_sk,ss_addr_sk,ca_city) dn,customer,customer_address current_addr + where ss_customer_sk = c_customer_sk + and customer.c_current_addr_sk = current_addr.ca_address_sk + and current_addr.ca_city <> bought_city + order by c_last_name + ,c_first_name + ,ca_city + ,bought_city + ,ss_ticket_number + limit 100; + +-- end query 1 in stream 0 using template query46.tpl |