select
t2.item_code as CODE,
t3.item_name as NAME,
sum(t2.unitprice*t2.order_qty) as TOTAL_AMT
from orders as t1
left join orders_dtl as t2
on t1.order_no = t2.order_no
left join item as t3
on t2.item_code = t3.item_code
where t1.order_date between '2023-05-14' and '2023-05-20'
group by t2.item_code
order by 3 desc, 1 desc
limit 5