with
	o as (
		select
			order_no
		from
			orders
		where
			order_date >= '2023-05-14'
			and order_date < '2023-05-21'
	)
	,od as (
		select
			item_code
			,unitprice * order_qty as amt
		from
			orders_dtl
		where
			order_no in (select order_no from o)
	)
	,i as (
		select
			item_code
			,item_name
		from
			item
		where
			item_code in (select item_code from od)
	)

select
	i.item_code as CODE
	,i.item_name as NAME
	,sum(amt) as TOTAL_AMT
from
	od
join
	i
on
	od.item_code = i.item_code
group by
	1, 2
order by
	3 desc, 1 desc
limit
	5