UPDATE ITEM 
SET
    ITEM_POPULAR_RANK = 0;

WITH QTY AS (
    SELECT
        ORDERS_DTL.ITEM_CODE AS ITEM_CODE
        ,SUM(ORDERS_DTL.ORDER_QTY) AS ORDER_QTY
        ,MAX(ORDER_DATE) AS ORDER_DATE
    FROM
        ORDERS_DTL
            LEFT OUTER JOIN ORDERS
                ON ORDERS_DTL.ORDER_NO = ORDERS.ORDER_NO
    WHERE
        DATE(ORDERS.ORDER_DATE) BETWEEN '2023-04-01' AND '2023-06-30'
    GROUP BY
        ORDERS_DTL.ITEM_CODE
), ITEM_RANK AS(
SELECT
    ITEM_CODE
    ,RANK() OVER(ORDER BY ORDER_QTY DESC, ORDER_DATE DESC, ITEM_CODE DESC) AS POPULAR_RANK
FROM
    QTY
)
UPDATE
    ITEM
SET
    ITEM_POPULAR_RANK = ITEM_RANK.POPULAR_RANK
FROM
    ITEM_RANK
WHERE
    ITEM.ITEM_CODE = ITEM_RANK.ITEM_CODE