SELECT
    item.ITEM_CODE as CODE
    , item.ITEM_NAME as NAME
    , SUM(dtl.ORDER_QTY) * dtl.UNITPRICE as TOTAL_AMT
FROM
    ORDERS o
JOIN
    ORDERS_DTL dtl
        ON dtl.ORDER_NO = o.ORDER_NO
JOIN
    ITEM item
        ON item.ITEM_CODE = dtl.ITEM_CODE
WHERE
    o.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
GROUP BY
    item.ITEM_CODE
ORDER BY
    TOTAL_AMT desc, CODE desc
LIMIT
    5