ydb/yt/yql/tests/sql/suites/pg-tpch/q04.sql

--!syntax_pg
--ignore runonopt plan diff
--TPC-H Q4


select
o_orderpriority, 
count(*) as order_count
from 
plato."orders"
where 
o_orderdate >= date '1993-07-01'
and o_orderdate < date '1993-07-01' + interval '3' month
and exists (
select 
*
from 
plato."lineitem"
where 
l_orderkey = o_orderkey
and l_commitdate < l_receiptdate
)
group by 
o_orderpriority
order by 
o_orderpriority;