WITH T as (
SELECT
 I.ITEM_CODE
,SUM(D.UNITPRICE * D.ORDER_QTY) As TOTAL_AMT
FROM ORDERS O
JOIN ORDERS_DTL D ON O.ORDER_NO = D.ORDER_NO
JOIN ITEM I ON D.ITEM_CODE = I.ITEM_CODE
WHERE O.ORDER_DATE >= '2023-05-14' and O.ORDER_DATE <= '2023-05-20'
GROUP BY I.ITEM_CODE
)

SELECT
 T.ITEM_CODE as CODE
,I.ITEM_NAME as NAME
,TOTAL_AMT
FROM T
JOIN ITEM I ON T.ITEM_CODE = I.ITEM_CODE
ORDER BY 3 DESC, 1 DESC