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

limit 5