q3

select
    l_orderkey,
    sum(l_extendedprice * (1 - l_discount)) as revenue,
    o_orderdate,
    o_shippriority
from
    customer,
    orders,
    lineitem
where
    c_mktsegment = 'BUILDING'
    and c_custkey = o_custkey
    and l_orderkey = o_orderkey
    and o_totalprice :varies
    and l_extendedprice :varies
group by
    l_orderkey,
    o_orderdate,
    o_shippriority
order by
    revenue desc,
    o_orderdate

Up one level

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

reduced_diag * 1249 x 778 * (151KB)

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

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

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

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

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

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

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

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

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

plan8 * PLAN 8 * 1252 x 869 * (40KB)

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

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

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

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

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

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

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

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

Album last updated on 5/19/07 12:57 AM

Powered by and skin