with A as (
    select
        GOODS_CODE,
        round(avg(STD_COST_PRICE), 0) as avg
    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.STD_COST_PRICE < (select avg from A where A.GOODS_CODE = SKU.GOODS_CODE)
;