WITH tmp AS (
    SELECT
        ODD.ITEM_CODE AS CODE,
        IT.ITEM_NAME AS NAME,
        ODD.UNITPRICE * ODD.ORDER_QTY AS AMOUNT
    FROM
        ORDERS AS OD
    INNER JOIN ORDERS_DTL AS ODD ON OD.ORDER_NO = ODD.ORDER_NO
    INNER JOIN ITEM AS IT ON ODD.ITEM_CODE = IT.ITEM_CODE
    WHERE
        OD.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
)
SELECT
    CODE,
    NAME,
    SUM(AMOUNT) AS TOTAL_AMT
FROM
    tmp
GROUP BY
    CODE, NAME
ORDER BY
    TOTAL_AMT DESC, CODE DESC
LIMIT
    5;