select
  od.ITEM_CODE as CODE
 ,i.ITEM_NAME as NAME
 ,SUM(od.UNITPRICE * od.ORDER_QTY) as TOTAL_AMT
from
 ORDERS o
join
 ORDERS_DTL od
on
 o.ORDER_NO = od.ORDER_NO
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
 i.ITEM_CODE
order by
 TOTAL_AMT desc, CODE desc limit 5;