Album » OptD » q13  (5 Slides)     [Page 1 of 1] :: Jump To  
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
    ) as c_orders
group by
    c_count
order by
    custdist desc,
    c_count desc

  Up one level  
plan_diag * Plan Diagram * 1252 x 786 * (110KB)
reduced_diag * 1258 x 781 * (102KB)
cost_diag * Plan Cost Diagram * 1252 x 786 * (134KB)
card_diag * Plan Cardinality Diagram * 1252 x 786 * (125KB)
plan1 * PLAN 1 * 1256 x 870 * (29KB)
  plan_diag  
  reduced_diag  
  cost_diag  
  card_diag  
  plan1  
Album last updated on 5/19/07 1:07 AM
Powered by JAlbum 7.1 and BluPlusPlus skin