UPDATE
	ITEM AS ITEM1
SET
	ITEM_POPULAR_RANK = IFNULL((
		SELECT
			ROW_NUMBER() OVER (ORDER BY SUM(ORDERS_DTL.ORDER_QTY) DESC, MAX(ORDERS.ORDER_DATE) DESC, ITEM.ITEM_CODE DESC) AS RANK
		FROM
			ORDERS
				INNER JOIN ORDERS_DTL
					ON ORDERS_DTL.ORDER_NO = ORDERS.ORDER_NO
				INNER JOIN ITEM
					ON ITEM.ITEM_CODE = ORDERS_DTL.ITEM_CODE
		WHERE
			ORDERS.ORDER_DATE BETWEEN '2023-04-01' AND '2023-06-30'
		AND	ITEM.ITEM_CODE = ITEM1.ITEM_CODE
		GROUP BY
			ITEM.ITEM_CODE
		), 0)