Query Template
select
c_count,
count(*) as custdist
from
(
select
c_custkey,
count(o_orderkey) as c_count
from
customer left outer join orders on
c_custkey = o_custkey
and o_totalprice :varies
group by
c_custkey
)
group by
c_count
order by
custdist desc,
c_count desc
Optimizer Diagrams
|