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