UPDATE SKU
SET
	STD_COST_PRICE = (SELECT STD_COST_PRICE FROM GOODS WHERE SKU.GOODS_CODE = GOODS.GOODS_CODE)
	, UPDATE_USER_NAME = 'MODIFY'
	, USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
WHERE
	SKU_CODE IN (
		SELECT SKU_CODE
		FROM SKU
		INNER JOIN (
			SELECT
				GOODS_CODE
				, ROUND(AVG(STD_COST_PRICE), 1) AVG_STD_COST_PRICE
			FROM
				SKU
			GROUP BY
				GOODS_CODE
			) SKU_AVG
			ON SKU.GOODS_CODE = SKU_AVG.GOODS_CODE
			AND SKU.STD_COST_PRICE < AVG_STD_COST_PRICE
	)
;