summaryrefslogtreecommitdiffstats
path: root/src/s3select/TPCDS/sample-queries-tpcds/query38.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/s3select/TPCDS/sample-queries-tpcds/query38.sql')
-rw-r--r--src/s3select/TPCDS/sample-queries-tpcds/query38.sql23
1 files changed, 23 insertions, 0 deletions
diff --git a/src/s3select/TPCDS/sample-queries-tpcds/query38.sql b/src/s3select/TPCDS/sample-queries-tpcds/query38.sql
new file mode 100644
index 000000000..5570ae202
--- /dev/null
+++ b/src/s3select/TPCDS/sample-queries-tpcds/query38.sql
@@ -0,0 +1,23 @@
+-- start query 1 in stream 0 using template query38.tpl and seed 1819994127
+select count(*) from (
+ select distinct c_last_name, c_first_name, d_date
+ from store_sales, date_dim, customer
+ where store_sales.ss_sold_date_sk = date_dim.d_date_sk
+ and store_sales.ss_customer_sk = customer.c_customer_sk
+ and d_month_seq between 1186 and 1186 + 11
+ intersect
+ select distinct c_last_name, c_first_name, d_date
+ from catalog_sales, date_dim, customer
+ where catalog_sales.cs_sold_date_sk = date_dim.d_date_sk
+ and catalog_sales.cs_bill_customer_sk = customer.c_customer_sk
+ and d_month_seq between 1186 and 1186 + 11
+ intersect
+ select distinct c_last_name, c_first_name, d_date
+ from web_sales, date_dim, customer
+ where web_sales.ws_sold_date_sk = date_dim.d_date_sk
+ and web_sales.ws_bill_customer_sk = customer.c_customer_sk
+ and d_month_seq between 1186 and 1186 + 11
+) hot_cust
+limit 100;
+
+-- end query 1 in stream 0 using template query38.tpl