update sku
set
    std_cost_price = T.gs
    ,update_user_name = 'MODIFY'
    ,user_update_datetime = '2024-08-31 00:00:00'
from(
    --商品コードごとの標準原価平均算出サブクエリ
    select
        sku.goods_code
        ,round(avg(sku.std_cost_price),0) as std
        ,g.std_cost_price as gs
    from sku
    inner join goods as g
    on g.goods_code = sku.goods_code
    group by sku.goods_code,g.std_cost_price
) as T
where sku.goods_code = T.goods_code
and sku.std_cost_price < T.std