WITH
 TEMP AS
(
 SELECT
  GOODS_CODE,
  ROUND(AVG(STD_COST_PRICE), 1) AS COST
 FROM
  SKU
 GROUP BY GOODS_CODE
)
UPDATE
 SKU
SET
 STD_COST_PRICE = GOODS.STD_COST_PRICE
 ,UPDATE_USER_NAME = 'MODIFY'
,USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
FROM
 TEMP
INNER JOIN GOODS
ON
 GOODS.GOODS_CODE = TEMP.GOODS_CODE
WHERE
 SKU.GOODS_CODE = TEMP.GOODS_CODE
AND
 SKU.STD_COST_PRICE > TEMP.COST