q4

SELECT
    O_ORDERPRIORITY,
    COUNT(*) AS ORDER_COUNT
FROM
    ORDERS
WHERE
    O_TOTALPRICE :varies
    AND EXISTS (
        SELECT
            *
        FROM
            LINEITEM
        WHERE
            L_ORDERKEY = ORDERS.O_ORDERKEY
            AND L_EXTENDEDPRICE :varies
    )
GROUP BY
    O_ORDERPRIORITY
ORDER BY
    O_ORDERPRIORITY

Up one level

plan_diag * Plan Diagram * 1251 x 771 * (139KB)

reduced_diag * 1253 x 778 * (140KB)

cost_diag * Plan Cost Diagram * 1251 x 771 * (176KB)

card_diag * Plan Cardinality Diagram * 1251 x 771 * (165KB)

plan1 * PLAN 1 * 1253 x 868 * (28KB)

plan2 * PLAN 2 * 1253 x 868 * (30KB)

plan3 * PLAN 3 * 1253 x 868 * (29KB)

plan4 * PLAN 4 * 1253 x 868 * (29KB)

plan5 * PLAN 5 * 1253 x 868 * (29KB)

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

Powered by and skin