select C.item_code as CODE,C.item_name as NAME,sum((B.unitprice * B.order_qty)) as TOTAL_AMT
from orders as A
inner join orders_dtl as B
on A.order_no = B.order_no
left join item as C
on B.item_code = C.item_code
where A.order_date >= date('2023-05-14')
and A.order_date <= date('2023-05-20')
group by C.item_code ,C.item_name
order by TOTAL_AMT desc, CODE desc
LIMIT 5
;