select
    od.ITEM_CODE as 'CODE'
    ,i.ITEM_NAME as 'NAME'
    ,SUM(od.UNITPRICE * od.ORDER_QTY) as 'TOTAL_AMT'
from
    ORDERS_DTL od
inner join
    ORDERS o
on
    od.ORDER_NO  = o.ORDER_NO
inner join
    ITEM i
on
    od.ITEM_CODE  = i.ITEM_CODE
where
    o.ORDER_DATE >= '2023-05-14'
and
    o.ORDER_DATE <= '2023-05-20'
GROUP BY
    NAME
order by
    TOTAL_AMT desc
    ,od.ITEM_CODE desc
LIMIT
    5
;