WITH TEMP AS (
    SELECT 
        GOODS_CODE,
        ROUND(AVG(STD_COST_PRICE), 1) AS AVG_COST
    FROM SKU
    GROUP BY GOODS_CODE
)
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, TEMP
WHERE 
    GOODS.GOODS_CODE = SKU.GOODS_CODE
    AND SKU.GOODS_CODE = TEMP.GOODS_CODE
    AND SKU.STD_COST_PRICE < TEMP.AVG_COST;