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