WITH AvgCost AS (
    SELECT GOODS_CODE, ROUND(AVG(STD_COST_PRICE), 0) AS ave_cost
    FROM SKU
    GROUP BY GOODS_CODE
)
UPDATE SKU
SET STD_COST_PRICE = T1.STD_COST_PRICE,
    UPDATE_USER_NAME = 'MODIFY',
    USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
FROM SKU T
LEFT JOIN GOODS T1 ON T.GOODS_CODE = T1.GOODS_CODE
LEFT JOIN AvgCost A ON T.GOODS_CODE = A.GOODS_CODE
WHERE T.STD_COST_PRICE < A.ave_cost;