Query Template
SELECT
C_CUSTKEY,
C_NAME,
SUM(L_EXTENDEDPRICE * (1 - L_DISCOUNT)) AS REVENUE,
C_ACCTBAL,
N_NAME,
C_ADDRESS,
C_PHONE,
C_COMMENT
FROM
CUSTOMER,
ORDERS,
LINEITEM,
NATION
WHERE
C_CUSTKEY = O_CUSTKEY
AND L_ORDERKEY = O_ORDERKEY
AND O_ORDERDATE >= '1993-10-01'
AND O_ORDERDATE < '1994-01-01'
AND C_NATIONKEY = N_NATIONKEY
AND C_ACCTBAL :varies
AND L_EXTENDEDPRICE :varies
GROUP BY
C_CUSTKEY,
C_NAME,
C_ACCTBAL,
C_PHONE,
N_NAME,
C_ADDRESS,
C_COMMENT
ORDER BY
REVENUE DESC
Optimizer Diagrams
|