UPDATE
	ITEM
SET
	ITEM_POPULAR_RANK = A.ORDER_RANK
FROM
	( SELECT
		I.ITEM_CODE
		,SUM(OD.ORDER_QTY) AS ORDER_QTY
		,RANK() OVER ( ORDER BY SUM(OD.ORDER_QTY) DESC,O.ORDER_DATE DESC,I.ITEM_CODE DESC ) AS ORDER_RANK
	FROM ORDERS O
		,ORDERS_DTL OD
		,ITEM I
	WHERE O.ORDER_NO = OD.ORDER_NO
	  AND OD.ITEM_CODE = I.ITEM_CODE
	  AND O.ORDER_DATE BETWEEN '2023-04-01' AND '2023-06-30'
	GROUP BY I.ITEM_CODE
	) A
WHERE A.ITEM_CODE = ITEM.ITEM_CODE
;