UPDATE ITEM
SET ITEM_POPULAR_RANK = C.RANK
FROM (
	SELECT B.ITEM_CODE,RANK() OVER(ORDER BY COUNT(B.ITEM_CODE) DESC,C.MAX_DATE DESC,B.ITEM_CODE DESC) RANK
	FROM ORDERS A
		,ORDERS_DTL B
		,(SELECT ORDER_NO,MAX(ORDER_DATE) MAX_DATE FROM ORDERS GROUP BY ORDER_NO) C
	WHERE A.ORDER_DATE BETWEEN '2023-04-01' AND '2023-06-30'
	AND A.ORDER_NO = B.ORDER_NO
	AND A.ORDER_NO = C.ORDER_NO
	GROUP BY ITEM_CODE
) C
WHERE ITEM.ITEM_CODE = C.ITEM_CODE