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