SELECT od.ITEM_CODE AS CODE
        ,i.ITEM_NAME AS NAME
        ,SUM(od.UNITPRICE * od.ORDER_QTY) AS TOTAL_AMT


FROM ORDERS_DTL od JOIN ORDERS o
    ON od.ORDER_NO = o.ORDER_NO
    JOIN ITEM i ON od.ITEM_CODE = i.ITEM_CODE
WHERE o.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
GROUP BY od.ITEM_CODE
ORDER BY TOTAL_AMT DESC,od.ITEM_CODE DESC LIMIT 5