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