UPDATE
    SKU
SET
    STD_COST_PRICE = A.STD_COST_PRICE,
    UPDATE_USER_NAME = 'MODIFY',
    USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
FROM
    (
        SELECT
            S.GOODS_CODE,
            GD.STD_COST_PRICE,
            ROUND(AVG(S.STD_COST_PRICE)) AS SCP
        FROM
            SKU AS S
            INNER JOIN GOODS AS GD ON GD.GOODS_CODE = S.GOODS_CODE
        GROUP BY
            S.GOODS_CODE,
            GD.STD_COST_PRICE
    ) AS A
WHERE
    A.GOODS_CODE = SKU.GOODS_CODE
    AND SKU.STD_COST_PRICE < A.SCP;