TPC-D Q10
C_CUSTKEY, C_NAME, SUM(L_EXTENDEDPRICE *
(1 - L_DISCOUNT)) AS REVENUE,
C_ACCTBAL, N_NAME, C_ADDRESS, C_PHONE, C_COMMENT
CUSTOMER, ORDER, LINEITEM, NATION
AND L_ORDERKEY = O_ORDERKEY
AND O_ORDERDATE >= DATE '[date]'
AND O_ORDERDATE < DATE '[date]' + INTERVAL 3 MONTH
AND C_NATIONKEY = N_NATIONKEY
C_CUSTKEY, C_NAME, C_ACCTBAL, C_PHONE, N_NAME, C_ADDRESS,