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