select t2.item_code "CODE",item_name "NAME" ,sum(UNITPRICE * ORDER_QTY) "TOTAL_AMT"
from orders t1
inner join orders_dtl t2
on t1.order_no = t2.order_no
inner join item t3
on t2.item_code = t3.item_code
group by t2.item_code,item_name
having t1.order_date >= '2023-05-14 00:00:00' and t1.order_date < '2023-05-21 00:00:00' 
order by 3 desc,t2.item_code desc limit 5