From e6918187568dbd01842d8d1d2c808ce16a894239 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 21 Apr 2024 13:54:28 +0200 Subject: Adding upstream version 18.2.2. Signed-off-by: Daniel Baumann --- .../TPCDS/sample-queries-tpcds/query87.sql | 23 ++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 src/s3select/TPCDS/sample-queries-tpcds/query87.sql (limited to 'src/s3select/TPCDS/sample-queries-tpcds/query87.sql') diff --git a/src/s3select/TPCDS/sample-queries-tpcds/query87.sql b/src/s3select/TPCDS/sample-queries-tpcds/query87.sql new file mode 100644 index 000000000..161e46443 --- /dev/null +++ b/src/s3select/TPCDS/sample-queries-tpcds/query87.sql @@ -0,0 +1,23 @@ +-- start query 1 in stream 0 using template query87.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 1221 and 1221+11) + except + (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 1221 and 1221+11) + except + (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 1221 and 1221+11) +) cool_cust +; + +-- end query 1 in stream 0 using template query87.tpl -- cgit v1.2.3