1 files changed, 30 insertions, 0 deletions
diff --git a/src/s3select/TPCDS/sample-queries-tpcds/query92.sql b/src/s3select/TPCDS/sample-queries-tpcds/query92.sql
new file mode 100644
index 000000000..547599f4c
--- /dev/null
+++ b/src/s3select/TPCDS/sample-queries-tpcds/query92.sql
@@ -0,0 +1,30 @@
+-- start query 1 in stream 0 using template query92.tpl and seed 2031708268
+select  
+   sum(ws_ext_discount_amt)  as "Excess Discount Amount" 
+from 
+    web_sales 
+   ,item 
+   ,date_dim
+where
+i_manufact_id = 356
+and i_item_sk = ws_item_sk 
+and d_date between cast('2001-03-12' as date) and 
+        (cast('2001-03-12' as date) + interval '90' day)
+and d_date_sk = ws_sold_date_sk 
+and ws_ext_discount_amt  
+     > ( 
+         SELECT 
+            1.3 * avg(ws_ext_discount_amt) 
+         FROM 
+            web_sales 
+           ,date_dim
+         WHERE 
+              ws_item_sk = i_item_sk 
+          and d_date between cast('2001-03-12' as date) and
+                             (cast('2001-03-12' as date) + interval '90' day)
+          and d_date_sk = ws_sold_date_sk 
+      ) 
+order by sum(ws_ext_discount_amt)
+limit 100;
+
+-- end query 1 in stream 0 using template query92.tpl