update
    SKU as sk
set
    STD_COST_PRICE = (
        select
            STD_COST_PRICE
        from
            GOODS
        WHERE
            GOODS_CODE = sk.GOODS_CODE
    )
    ,UPDATE_USER_NAME = 'MODIFY'
    ,USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
where
    STD_COST_PRICE
    < 
    ROUND(
    (
        select
            avg(STD_COST_PRICE)
        from
            SKU
        GROUP BY
            GOODS_CODE
        HAVING
            GOODS_CODE = sk.GOODS_CODE
    )
    ,1)