SELECT
	ITEM.ITEM_CODE AS [CODE]
	,ITEM.ITEM_NAME AS [NAME]
	,SUM(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) AS [TOTAL_AMT]
FROM ORDERS
INNER JOIN ORDERS_DTL
	ON ORDERS_DTL.ORDER_NO = ORDERS.ORDER_NO
INNER JOIN ITEM
	ON ITEM.ITEM_CODE = ORDERS_DTL.ITEM_CODE
WHERE ORDERS.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
GROUP BY
	ITEM.ITEM_CODE
	,ITEM.ITEM_NAME
ORDER BY
    SUM(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) DESC
    ,ITEM.ITEM_CODE DESC
LIMIT 5
;