q12

SELECT
    L_SHIPMODE,
    SUM(CASE
        WHEN O_ORDERPRIORITY = '1-URGENT'
            OR O_ORDERPRIORITY = '2-HIGH'
            THEN 1
        ELSE 0
    END) AS HIGH_LINE_COUNT,
    SUM(CASE
        WHEN O_ORDERPRIORITY <> '1-URGENT'
            AND O_ORDERPRIORITY <> '2-HIGH'
            THEN 1
        ELSE 0
    END) AS LOW_LINE_COUNT
FROM
    ORDERS,
    LINEITEM
WHERE
    O_ORDERKEY = L_ORDERKEY
    AND O_TOTALPRICE :varies
AND L_EXTENDEDPRICE :varies
GROUP BY
    L_SHIPMODE
ORDER BY
    L_SHIPMODE

plan_diag

reduced_diag

cost_diag

card_diag

plan1

plan2

plan3

plan4

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