Figure 11: Complex query

SELECT	C.CUSTOMER,

	S.ORDERDATE,

	SUM(S.QUANTITY) AS TOTAL_QUANTITY

FROM	SALES S,

	CUSTOMERS C

WHERE	S.CUSTKEY = C.CUSTKEY

AND	S.ORDERDATE = Ô2005/06/30Õ

GROUP BY	C.CUSTOMER,

	S.ORDERDATE

ORDER BY	TOTAL_QUANTITY DESC,

	C.CUSTOMER;