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