with t as (
    select GOODS_CODE, round(avg(STD_COST_PRICE)) as a
    from sku
    group by 1
)
update sku as s
set STD_COST_PRICE = (select g.STD_COST_PRICE from goods as g where g.GOODS_CODE = s.GOODS_CODE),
UPDATE_USER_NAME = 'MODIFY',
USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
where s.STD_COST_PRICE < (select a from t where t.GOODS_CODE = s.GOODS_CODE);

select * from sku;