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

Library import 241120-1113

1 files changed, 25 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/pg-tpch/q01.sql b/yql/essentials/tests/sql/suites/pg-tpch/q01.sql
new file mode 100644
index 0000000000..7198f496bc
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg-tpch/q01.sql
@@ -0,0 +1,25 @@
+--!syntax_pg
+--TPC-H Q1
+
+
+select
+l_returnflag, 
+l_linestatus, 
+sum(l_quantity) as sum_qty,
+sum(l_extendedprice) as sum_base_price,
+sum(l_extendedprice*(1::numeric-l_discount)) as sum_disc_price,
+sum(l_extendedprice*(1::numeric-l_discount)*(1::numeric+l_tax)) as sum_charge,
+avg(l_quantity) as avg_qty, 
+avg(l_extendedprice) as avg_price,
+avg(l_discount) as avg_disc, 
+count(*) as count_order
+from 
+plato."lineitem"
+where 
+l_shipdate <= date '1998-12-01' - interval '90' day
+group by 
+l_returnflag, 
+l_linestatus
+order by 
+l_returnflag, 
+l_linestatus;