Change "devtools/contrib/piglet/projects/ydblib/config.yaml"

commit_hash:bf8be6eaf53bc3065d37ec3eeb7b664ca9d6b76d

1 files changed, 25 insertions, 0 deletions

diff --git a/yt/yql/tests/sql/suites/pg-tpch/q13.sql b/yt/yql/tests/sql/suites/pg-tpch/q13.sql
new file mode 100644
index 0000000000..97848f0b9b
--- /dev/null
+++ b/yt/yql/tests/sql/suites/pg-tpch/q13.sql
@@ -0,0 +1,25 @@
+--!syntax_pg
+--TPC-H Q13
+
+
+select 
+c_count, count(*) as custdist 
+from (
+select 
+c_custkey,
+count(o_orderkey) 
+from 
+plato."customer"
+left outer join 
+plato."orders"
+on 
+c_custkey = o_custkey
+and o_comment not like '%special%requests%'
+group by 
+c_custkey
+)as c_orders (c_custkey, c_count)
+group by 
+c_count
+order by 
+custdist desc, 
+c_count desc;