SELECt 
i.item_code as CCODE,
i.item_name as NAME,
sum(od.unitprice * od.order_qty) as TOTAL_AMT

from orders o inner join orders_dtl od on o.order_no=od.order_no
inner join item i on od.item_code=i.item_code

where o.order_date between '2023-05-14' and '2023-05-20'
group by 1
order by 3 desc,1 desc