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