WITH GoodsData AS (
    SELECT
        S.GOODS_CODE,
        S.STD_COST_PRICE,
        G.STD_COST_PRICE AS GOODS_STD_COST_PRICE,
        ROUND(AVG(S.STD_COST_PRICE) OVER(PARTITION BY S.GOODS_CODE), 1) AS AVG_STD_COST_PRICE
    FROM
        SKU S
    INNER JOIN GOODS G ON S.GOODS_CODE = G.GOODS_CODE
)
UPDATE SKU
SET
    STD_COST_PRICE = G.GOODS_STD_COST_PRICE,
    UPDATE_USER_NAME = 'MODIFY',
    USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
FROM
    SKU AS S
    INNER JOIN GoodsData AS G ON S.GOODS_CODE = G.GOODS_CODE
WHERE
    S.STD_COST_PRICE < G.AVG_STD_COST_PRICE;