UPDATE
	ITEM
SET
	ITEM_POPULAR_RANK = 0
;

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