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