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 as i
on i.item_code = od.item_code
where 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