SELECT
    ODT.ITEM_CODE AS 'CODE'
    ,(SELECt ITEM_NAME FROM ITEM WHERE ITEM_CODE = ODT.ITEM_CODE) AS 'NAME'
    ,ODT.UNITPRICE * ODT.ORDER_QTY AS 'TOTAL_AMT'
FROM
    ORDERS_DTL ODT
INNER JOIN ORDERS O
ON ODT.ORDER_NO = O.ORDER_NO
WHERE
    O.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
ORDER BY
    TOTAL_AMT desc
    ,CODE desc 
LIMIT 5