q18

select
    c_name,
    c_custkey,
    o_orderkey,
    o_orderdate,
    o_totalprice,
    sum(l_quantity)
from
    customer,
    orders,
    lineitem
where
    o_orderkey in (
        select
            l_orderkey
        from
            lineitem
        where l_extendedprice :varies
        group by
            l_orderkey having
                sum(l_quantity) > 300
    )
    and c_custkey = o_custkey
    and o_orderkey = l_orderkey
    and c_acctbal :varies
group by
    c_name,
    c_custkey,
    o_orderkey,
    o_orderdate,
    o_totalprice
order by
    o_totalprice desc,
    o_orderdate

Up one level

plan_diag * Plan Diagram * 1252 x 786 * (214KB)

reduced_diag * 1258 x 781 * (163KB)

cost_diag * Plan Cost Diagram * 1252 x 786 * (228KB)

card_diag * Plan Cardinality Diagram * 1252 x 786 * (231KB)

plan1 * PLAN 1 * 1256 x 870 * (35KB)

plan2 * PLAN 2 * 1256 x 870 * (35KB)

plan3 * PLAN 3 * 1256 x 870 * (36KB)

plan4 * PLAN 4 * 1256 x 870 * (37KB)

plan5 * PLAN 5 * 1256 x 870 * (35KB)

plan6 * PLAN 6 * 1256 x 870 * (35KB)

plan7 * PLAN 7 * 1256 x 870 * (37KB)

plan8 * PLAN 8 * 1256 x 870 * (36KB)

plan9 * PLAN 9 * 1256 x 870 * (36KB)

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

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

plan12 * PLAN 12 * 1256 x 870 * (35KB)

plan13 * PLAN 13 * 1256 x 870 * (35KB)

plan14 * PLAN 14 * 1256 x 870 * (36KB)

plan15 * PLAN 15 * 1256 x 870 * (37KB)

plan16 * PLAN 16 * 1256 x 870 * (37KB)

plan17 * PLAN 17 * 1256 x 870 * (36KB)

plan18 * PLAN 18 * 1256 x 870 * (35KB)

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

Powered by and skin