with vOd as
(select 
 	 od.ITEM_CODE CODE
	,i.ITEM_NAME NAME
	,sum(UNITPRICE * ORDER_QTY) TOTAL_AMT
	from ORDERS o
	inner join ORDERS_DTL od
		on o.ORDER_NO = od.ORDER_NO
	inner join ITEM i
		on od.ITEM_CODE = i.ITEM_CODE
	where ORDER_DATE between '2023-05-14' and '2023-05-20'
	group by 
	 od.ITEM_CODE 
	,i.ITEM_NAME)
select 
	 CODE
	,NAME
	,TOTAL_AMT
from(select 
	 CODE
	,NAME
	,TOTAL_AMT
	,rank() over(order by TOTAL_AMT desc,CODE desc) rnk
	from vOd ) od
where od.rnk<=5
order by
 TOTAL_AMT desc
,CODE desc