WITH TMP_TABLE AS(
    SELECT
        ITEM.ITEM_CODE AS CODE,
        ITEM.ITEM_NAME AS NAME,
        SUM(UNITPRICE * ORDER_QTY) AS TOTAL_AMT,
        RANK() OVER(ORDER BY SUM(UNITPRICE * ORDER_QTY) DESC, ITEM.ITEM_CODE DESC) AS TOTAL_AMT_RANK
    FROM
        ORDERS_DTL
        INNER JOIN
            ITEM ON ITEM.ITEM_CODE = ORDERS_DTL.ITEM_CODE,
            ORDERS ON ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
    WHERE
        ORDERS.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
    GROUP BY
        ORDERS_DTL.ITEM_CODE
)
SELECT
    CODE,
    NAME,
    TOTAL_AMT
FROM
    TMP_TABLE
WHERE
    TOTAL_AMT_RANK <= 5
ORDER BY
    TOTAL_AMT DESC,
    CODE DESC