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>
---
 src/s3select/TPCDS/sample-queries-tpcds/query15.sql | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 src/s3select/TPCDS/sample-queries-tpcds/query15.sql

(limited to 'src/s3select/TPCDS/sample-queries-tpcds/query15.sql')

diff --git a/src/s3select/TPCDS/sample-queries-tpcds/query15.sql b/src/s3select/TPCDS/sample-queries-tpcds/query15.sql
new file mode 100644
index 000000000..cb489cf33
--- /dev/null
+++ b/src/s3select/TPCDS/sample-queries-tpcds/query15.sql
@@ -0,0 +1,20 @@
+-- start query 1 in stream 0 using template query15.tpl and seed 1819994127
+select  ca_zip
+       ,sum(cs_sales_price)
+ from catalog_sales
+     ,customer
+     ,customer_address
+     ,date_dim
+ where cs_bill_customer_sk = c_customer_sk
+ 	and c_current_addr_sk = ca_address_sk 
+ 	and ( substr(ca_zip,1,5) in ('85669', '86197','88274','83405','86475',
+                                   '85392', '85460', '80348', '81792')
+ 	      or ca_state in ('CA','WA','GA')
+ 	      or cs_sales_price > 500)
+ 	and cs_sold_date_sk = d_date_sk
+ 	and d_qoy = 2 and d_year = 1998
+ group by ca_zip
+ order by ca_zip
+ limit 100;
+
+-- end query 1 in stream 0 using template query15.tpl
-- 
cgit v1.2.3

