q16

select
    p_brand,
    p_type,
    p_size,
    count(distinct ps_suppkey) as supplier_cnt
from
    partsupp,
    part
where
    p_partkey = ps_partkey
    and p_retailprice :varies
    and ps_suppkey in (
        select
            s_suppkey
        from
            supplier
        where
            s_acctbal :varies
    )
group by
    p_brand,
    p_type,
    p_size
order by
    supplier_cnt desc,
    p_brand,
    p_type,
    p_size

Up one level

plan_diag * Plan Diagram * 1252 x 777 * (231KB)

reduced_diag * 1249 x 778 * (198KB)

cost_diag * Plan Cost Diagram * 1252 x 777 * (252KB)

card_diag * Plan Cardinality Diagram * 1252 x 777 * (261KB)

plan1 * PLAN 1 * 1250 x 870 * (42KB)

plan2 * PLAN 2 * 1250 x 870 * (41KB)

plan3 * PLAN 3 * 1250 x 870 * (42KB)

plan4 * PLAN 4 * 1250 x 870 * (41KB)

plan5 * PLAN 5 * 1250 x 870 * (41KB)

plan6 * PLAN 6 * 1250 x 870 * (41KB)

plan7 * PLAN 7 * 1248 x 869 * (41KB)

plan8 * PLAN 8 * 1248 x 869 * (41KB)

plan9 * PLAN 9 * 1252 x 869 * (41KB)

plan10 * PLAN 10 * 1250 x 870 * (35KB)

plan11 * PLAN 11 * 1250 x 870 * (35KB)

plan12 * PLAN 12 * 1250 x 870 * (42KB)

plan13 * PLAN 13 * 1250 x 870 * (40KB)

plan14 * PLAN 14 * 1250 x 870 * (42KB)

plan15 * PLAN 15 * 1250 x 870 * (40KB)

plan16 * PLAN 16 * 1250 x 870 * (40KB)

plan17 * PLAN 17 * 1250 x 870 * (42KB)

plan18 * PLAN 18 * 1250 x 870 * (40KB)

plan19 * PLAN 19 * 1250 x 870 * (42KB)

plan20 * PLAN 20 * 1250 x 870 * (41KB)

plan21 * PLAN 21 * 1250 x 870 * (43KB)

plan22 * PLAN 22 * 1250 x 870 * (46KB)

plan23 * PLAN 23 * 1250 x 870 * (39KB)

plan24 * PLAN 24 * 1250 x 870 * (40KB)

plan25 * PLAN 25 * 1250 x 870 * (42KB)

plan26 * PLAN 26 * 1250 x 870 * (42KB)

plan27 * PLAN 27 * 1250 x 870 * (39KB)

plan28 * PLAN 28 * 1250 x 870 * (42KB)

plan29 * PLAN 29 * 1250 x 870 * (43KB)

plan30 * PLAN 30 * 1250 x 870 * (38KB)

plan31 * PLAN 31 * 1250 x 870 * (42KB)

plan32 * PLAN 32 * 1250 x 870 * (42KB)

Album last updated on 5/19/07 1:01 AM

Powered by and skin