q5

SELECT
    N_NAME,
    SUM(L_EXTENDEDPRICE * (1 - L_DISCOUNT)) AS REVENUE
FROM
    CUSTOMER,
    ORDERS,
    LINEITEM,
    SUPPLIER,
    NATION,
    REGION
WHERE
    C_CUSTKEY = O_CUSTKEY
    AND L_ORDERKEY = O_ORDERKEY
    AND L_SUPPKEY = S_SUPPKEY
    AND C_NATIONKEY = S_NATIONKEY
    AND S_NATIONKEY = N_NATIONKEY
    AND N_REGIONKEY = R_REGIONKEY
    AND R_NAME = 'ASIA'
    AND O_ORDERDATE >= '1994-01-01'
    AND O_ORDERDATE < '1995-01-01'
    AND C_ACCTBAL :varies
    AND S_ACCTBAL :varies
GROUP BY
    N_NAME
ORDER BY
    REVENUE DESC

plan_diag

reduced_diag

cost_diag

card_diag

plan1

plan2

plan3

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