WITH AvgCost AS(SELECT GOODS_CODE, ROUND (AVG(STD_COST_PRICE),0) AS AVG_COST_PRICE
FROM SKU
GROUP BY GOODS_CODE)

UPDATE SKU
SET STD_COST_PRICE = (SELECT STD_COST_PRICE FROM GOODS WHERE GOODS.GOODS_CODE = SKU.GOODS_CODE),
    UPDATE_USER_NAME = 'MODIFY',
    USER_UPDATE_DATETIME =  '2024-08-31 00:00:00'
WHERE SKU.GOODS_CODE IN (SELECT GOODS_CODE FROM AvgCost)
AND SKU.STD_COST_PRICE < (SELECT AVG_COST_PRICE FROM AvgCost WHERE AvgCost.GOODS_CODE = SKU.GOODS_CODE);