select 
od.ITEM_CODE as  CODE,
ITEM_NAME as NAME,
sum(UNITPRICE*ORDER_QTY) as TOTAL_AMT
from ORDERS as o
inner join ORDERS_DTL as od
 on o.ORDER_NO = od.ORDER_NO
inner join ITEM
on ITEM.ITEM_CODE  = od.ITEM_CODE

where o.ORDER_DATE between '2023-05-14' and  '2023-05-20'
group by od.ITEM_CODE
order by 
TOTAL_AMT desc
,od.ITEM_CODE desc

limit 5;