select 
    od.ITEM_CODE as CODE
    ,max(ITEM_NAME) as NAME
    ,sum(UNITPRICE*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 date(ORDER_DATE) between '2023-05-14' and '2023-05-20'
group by 1
order by 3 desc, 1 desc
limit 5;