From e6918187568dbd01842d8d1d2c808ce16a894239 Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Sun, 21 Apr 2024 13:54:28 +0200
Subject: Adding upstream version 18.2.2.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 .../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

