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