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