WITH tmp AS(
    SELECT
        *
    FROM
        ORDERS_DTL AS D
    JOIN
        ORDERS AS O ON D.ORDER_NO = O.ORDER_NO
    JOIN
        ITEM AS I ON D.ITEM_CODE = I.ITEM_CODE
)
SELECT
    ITEM_CODE AS CODE,
    ITEM_NAME AS NAME,
    UNITPRICE*SUM(ORDER_QTY) AS TOTAL_AMT
FROM
    tmp
WHERE
    ORDER_DATE BETWEEN '2023-05-14 00:00:00' AND '2023-05-20 23:59:59'
GROUP BY
    ITEM_CODE, ITEM_NAME
ORDER BY
    TOTAL_AMT DESC, ITEM_CODE DESC
LIMIT
    5
;