SELECT
    CODE
    ,NAME
    ,SUM(AMT) as TOTAL_AMT
From
    (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 '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')
GROUP BY
    CODE
ORDER BY
    TOTAL_AMT desc
    ,CODE desc
LIMIT 5