update sku as S
    set std_cost_price=(
        select std_cost_price from goods
        where S.goods_code=goods.goods_code),
    update_user_name='MODIFY',
    user_update_datetime='2024-08-31 00:00:00'
where S.sku_code in 
    (select 
        sku.sku_code
    from sku
    inner join (
        select 
            goods_code,
            std_cost_price,
            round(avg(std_cost_price*1.0) over(partition by goods_code),0) as avgcost
        from sku) as A
    on sku.goods_code=a.goods_code
    and sku.std_cost_price=a.std_cost_price
    where sku.std_cost_price<A.avgcost
    );