--【問題9】
SELECT
	B.ITEM_CODE AS CODE
,	C.ITEM_NAME AS NAME
,	SUM(B.UNITPRICE * B.ORDER_QTY) AS TOTAL_AMT
FROM
	ORDERS A
,	ORDERS_DTL B
,	ITEM C
WHERE
	A.ORDER_NO = B.ORDER_NO
AND	B.ITEM_CODE = C.ITEM_CODE
AND	A.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
GROUP BY
	CODE
,	NAME
ORDER BY
	TOTAL_AMT DESC
,	C.ITEM_CODE DESC
LIMIT 5