select CODE,item_name as NAME,TOTAL_AMT 
from item 
inner join 
(select odtl.item_code as CODE,sum(odtl.unitprice*odtl.order_qty) as TOTAL_AMT 
from orders_dtl as odtl 
inner join orders as od 
on odtl.order_no=od.order_no 
where order_date between '2023-05-14' and '2023-05-20' 
group by code) as tmp
on tmp.code=item.item_code 
order by total_amt desc,code desc;