Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 27 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/pg-tpch/q03.sql b/yql/essentials/tests/sql/suites/pg-tpch/q03.sql
new file mode 100644
index 0000000000..fd34b86d2b
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg-tpch/q03.sql
@@ -0,0 +1,27 @@
+--!syntax_pg
+--TPC-H Q3
+
+
+select
+l_orderkey, 
+sum(l_extendedprice*(1::numeric-l_discount)) as revenue,
+o_orderdate, 
+o_shippriority
+from 
+plato."customer", 
+plato."orders", 
+plato."lineitem"
+where 
+c_mktsegment = 'BUILDING'
+and c_custkey = o_custkey
+and l_orderkey = o_orderkey
+and o_orderdate < date '1995-03-15'
+and l_shipdate > date '1995-03-15'
+group by 
+l_orderkey, 
+o_orderdate, 
+o_shippriority
+order by 
+revenue desc, 
+o_orderdate
+limit 10;