SELECT 
B.ITEM_CODE CODE
,C.ITEM_NAME NAME
,SUM(UNITPRICE * ORDER_QTY) TOTAL_AMT
FROM ORDERS A
INNER JOIN ORDERS_DTL B
ON A.ORDER_NO = B.ORDER_NO
INNER JOIN ITEM C
ON B.ITEM_CODE = C.ITEM_CODE
WHERE ORDER_DATE >= '2023-05-14'
AND ORDER_DATE <= '2023-05-20'
GROUP BY B.ITEM_CODE,C.ITEM_NAME
ORDER BY SUM(UNITPRICE * ORDER_QTY) DESC,B.ITEM_CODE DESC