SELECT 
    L.ITEM_CODE AS CODE
    ,R1.ITEM_NAME AS NAME
    ,SUM(L.UNITPRICE * L.ORDER_QTY) AS TOTAL_AMT
FROM ORDERS_DTL L
INNER JOIN ITEM R1
ON L.ITEM_CODE = R1.ITEM_CODE
INNER JOIN ORDERS R2
ON L.ORDER_NO = R2.ORDER_NO
WHERE R2.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
GROUP BY 1,2 ORDER BY 3 DESC,1 DESC;