WITH
AVG_GOODS_CODE AS
(
SELECT
GOODS_CODE,
ROUND(AVG(STD_COST_PRICE),1) AS AVG_STD_COST_PRICE
FROM SKU
GROUP BY GOODS_CODE
)
UPDATE SKU
SET
STD_COST_PRICE = (
 SELECT STD_COST_PRICE FROM GOODS T2 WHERE GOODS_CODE = SKU.GOODS_CODE
),
UPDATE_USER_NAME = 'MODIFY',
USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
FROM AVG_GOODS_CODE
WHERE
AVG_GOODS_CODE.GOODS_CODE = SKU.GOODS_CODE
AND SKU.STD_COST_PRICE < AVG_GOODS_CODE.AVG_STD_COST_PRICE