Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 47 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/pg-tpcds/q67.sql b/yql/essentials/tests/sql/suites/pg-tpcds/q67.sql
new file mode 100644
index 0000000000..8f3f7a868a
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg-tpcds/q67.sql
@@ -0,0 +1,47 @@
+--!syntax_pg
+--TPC-DS Q67
+
+-- start query 1 in stream 0 using template ../query_templates/query67.tpl
+select  *
+from (select i_category
+            ,i_class
+            ,i_brand
+            ,i_product_name
+            ,d_year
+            ,d_qoy
+            ,d_moy
+            ,s_store_id
+            ,sumsales
+            ,rank() over (partition by i_category order by sumsales desc) rk
+      from (select i_category
+                  ,i_class
+                  ,i_brand
+                  ,i_product_name
+                  ,d_year
+                  ,d_qoy
+                  ,d_moy
+                  ,s_store_id
+                  ,sum(coalesce(ss_sales_price*ss_quantity::numeric,0::numeric)) sumsales
+            from plato.store_sales
+                ,plato.date_dim
+                ,plato.store
+                ,plato.item
+       where  ss_sold_date_sk=d_date_sk
+          and ss_item_sk=i_item_sk
+          and ss_store_sk = s_store_sk
+          and d_month_seq between 1212 and 1212+11
+       group by  rollup(i_category, i_class, i_brand, i_product_name, d_year, d_qoy, d_moy,s_store_id))dw1) dw2
+where rk <= 100
+order by i_category
+        ,i_class
+        ,i_brand
+        ,i_product_name
+        ,d_year
+        ,d_qoy
+        ,d_moy
+        ,s_store_id
+        ,sumsales
+        ,rk
+limit 100;
+
+-- end query 1 in stream 0 using template ../query_templates/query67.tpl