select 
 dtl.item_code as code
 , itm.item_name as name
 , sum(dtl.unitprice * dtl.order_qty) as total_amt
from orders ord
inner join orders_dtl dtl
on ord.order_no = dtl.order_no
inner join item itm
on dtl.item_code = itm.item_code
where 
 ord.order_date between '2023-05-14' and '2023-05-20'
group by dtl.item_code
order by total_amt desc, dtl.item_code desc
limit 5;