with calc as  (
select
  GOODS_CODE,
  round(avg(STD_COST_PRICE)) avg_price
from
    SKU as main
group  by
  GOODS_CODE
)
update SKU
set
  STD_COST_PRICE = g.STD_COST_PRICE
 ,UPDATE_USER_NAME = 'MODIFY'
 ,USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
from
calc as c
inner join
    GOODS as g using(GOODS_CODE)
where
  -- 算出した平均標準原価よりも小さい標準原価の商品の標準原価に、品目データ(GOODS)の標準原価を設定
      c.avg_price > SKU.STD_COST_PRICE
      and SKU.GOODS_CODE = c.GOODS_CODE
    ;
      
select * from SKU
order by 1,2,3,4
;