Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 34 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/pg-tpch/q16.sql b/yql/essentials/tests/sql/suites/pg-tpch/q16.sql
new file mode 100644
index 0000000000..7df4f54439
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg-tpch/q16.sql
@@ -0,0 +1,34 @@
+--!syntax_pg
+--TPC-H Q16
+
+
+select
+p_brand, 
+p_type, 
+p_size, 
+count(distinct ps_suppkey) as supplier_cnt
+from 
+plato."partsupp", 
+plato."part"
+where 
+p_partkey = ps_partkey
+and p_brand <> 'Brand#45'
+and p_type not like 'MEDIUM POLISHED%'
+and p_size in (49, 14, 23, 45, 19, 3, 36, 9)
+and ps_suppkey not in (
+select 
+s_suppkey
+from 
+plato."supplier"
+where 
+s_comment like '%Customer%Complaints%'
+)
+group by 
+p_brand, 
+p_type, 
+p_size
+order by 
+supplier_cnt desc, 
+p_brand, 
+p_type, 
+p_size;