WITH
X AS (
  SELECT
    A.GOODS_CODE
  , ROUND(AVG(A.STD_COST_PRICE)) AS AVG_STD_COST_PRICE
  , B.STD_COST_PRICE             AS GOODS_STD_COST_PRICE
  FROM
    SKU A
    INNER JOIN GOODS B ON A.GOODS_CODE = B.GOODS_CODE
  GROUP BY
    A.GOODS_CODE  
)
UPDATE
  SKU
SET
  STD_COST_PRICE       = X.GOODS_STD_COST_PRICE
, UPDATE_USER_NAME     = 'MODIFY'
, USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
FROM
  SKU AS A
  INNER JOIN X ON A.GOODS_CODE = X.GOODS_CODE
WHERE
  A.STD_COST_PRICE < X.AVG_STD_COST_PRICE
;