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