Merge pull request #11788 from ydb-platform/mergelibs-241120-1113

Library import 241120-1113

1 files changed, 33 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/tpch/q13.sql b/yql/essentials/tests/sql/suites/tpch/q13.sql
new file mode 100644
index 0000000000..e94f36a545
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/tpch/q13.sql
@@ -0,0 +1,33 @@
+
+-- TPC-H/TPC-R Customer Distribution Query (Q13)
+-- TPC TPC-H Parameter Substitution (Version 2.17.2 build 0)
+-- using 1680793381 as a seed to the RNG
+
+$orders = (
+    select
+        o_orderkey,
+        o_custkey
+    from
+        plato.orders
+    where
+        o_comment NOT LIKE "%unusual%requests%"
+);
+select
+    c_count as c_count,
+    count(*) as custdist
+from
+    (
+        select
+            c.c_custkey as c_custkey,
+            count(o.o_orderkey) as c_count
+        from
+            plato.customer as c left outer join $orders as o on
+                c.c_custkey = o.o_custkey
+        group by
+            c.c_custkey
+    ) as c_orders
+group by
+    c_count
+order by
+    custdist desc,
+    c_count desc;