UPDATE SKU
SET
	STD_COST_PRICE = SKU_AVG.STD_AVG
FROM
(
	SELECT
		GOODS_CODE	AS STD_GOODS_CODE
	,	ROUND(AVG(STD_COST_PRICE),0) AS STD_AVG
	FROM
		SKU
	GROUP BY
		GOODS_CODE
) SKU_AVG
WHERE
	STD_COST_PRICE < SKU_AVG.STD_AVG