Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 36 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/pg-tpch/q10.sql b/yql/essentials/tests/sql/suites/pg-tpch/q10.sql
new file mode 100644
index 0000000000..e331135e3b
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg-tpch/q10.sql
@@ -0,0 +1,36 @@
+--!syntax_pg
+--TPC-H Q10
+
+
+select
+c_custkey, 
+c_name, 
+sum(l_extendedprice * (1::numeric - l_discount)) as revenue,
+c_acctbal, 
+n_name, 
+c_address, 
+c_phone, 
+c_comment
+from 
+plato."customer", 
+plato."orders", 
+plato."lineitem", 
+plato."nation"
+where 
+c_custkey = o_custkey
+and l_orderkey = o_orderkey
+and o_orderdate >= date '1993-10-01'
+and o_orderdate < date '1993-10-01' + interval '3' month
+and l_returnflag = 'R'
+and c_nationkey = n_nationkey
+group by 
+c_custkey, 
+c_name, 
+c_acctbal, 
+c_phone, 
+n_name, 
+c_address, 
+c_comment
+order by 
+revenue desc
+limit 20;