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  ORDER_DATE between "2023-05-14" and "2023-05-20"
group by NAME
order by TOTAL_AMT desc,
         CODE desc
limit 5