WITH update_target AS (
SELECT
    *
FROM
    SKU
GROUP BY
    GOODS_CODE
HAVING
    STD_COST_PRICE < ROUND(AVG(STD_COST_PRICE),1)
)

UPDATE SKU 
    SET
        STD_COST_PRICE = GOODS.STD_COST_PRICE,
        UPDATE_USER_NAME = 'MODIFY',
        USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
FROM
    GOODS
WHERE
    SKU.GOODS_CODE = GOODS.GOODS_CODE AND
    SKU.SKU_CODE IN (
        SELECT
            update_target.SKU_CODE
        FROM
            update_target
    );