select
    od.ITEM_CODE as CODE
    ,MAX(i.ITEM_NAME) as NAME
    ,SUM(od.UNITPRICE * od.ORDER_QTY) as TOTAL_AMT
from
    ORDERS o
inner join
    ORDERS_DTL od
on
    o.ORDER_NO = od.ORDER_NO
inner join
    ITEM i
on
    od.ITEM_CODE = i.ITEM_CODE
where
    o.ORDER_DATE between '2023-05-14' and '2023-05-20'
group by
    od.ITEM_CODE
order by
    3 desc
    ,1 desc
limit 5
;