WITH T as (
  SELECT GOODS_CODE, ROUND(AVG(STD_COST_PRICE), 0) COST
  FROM SKU
  GROUP BY GOODS_CODE
)

UPDATE SKU
SET STD_COST_PRICE = G.STD_COST_PRICE
   ,UPDATE_USER_NAME = 'MODIFY'
   ,USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
FROM T
JOIN GOODS G ON T.GOODS_CODE = G.GOODS_CODE
WHERE SKU.GOODS_CODE = T.GOODS_CODE
    AND SKU.STD_COST_PRICE < T.COST