WITH SUB AS (
 SELECT
  SKU.GOODS_CODE,
  ROUND(AVG(SKU.STD_COST_PRICE),0) AS AVG1
 FROM
  SKU AS SKU
 INNER JOIN GOODS AS G
  ON SKU.GOODS_CODE = G.GOODS_CODE
 
 GROUP BY
  GOODS_CODE
 )

UPDATE SKU
SET
STD_COST_PRICE = G.STD_COST_PRICE,
SKU.UPDATE_USER_NAME = 'MODIFY',
SKU.USER_UPDATE_DATETIME = '2024-08-31 00:00:00'



WHERE
  SKU.STD_COST_PRICE < SUB.AVG1;