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