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

--!syntax_pg
--TPC-H Q13


select 
c_count, count(*) as custdist 
from (
select 
c_custkey,
count(o_orderkey) 
from 
plato."customer"
left outer join 
plato."orders"
on 
c_custkey = o_custkey
and o_comment not like '%special%requests%'
group by 
c_custkey
)as c_orders (c_custkey, c_count)
group by 
c_count
order by 
custdist desc, 
c_count desc;