with 
average as (
  select
      GOODS_CODE
    , round(avg(STD_COST_PRICE), 2) as AVG_STD_COST_PRICE
  from
      SKU
  group by
      GOODS_CODE
),
targets as (
  select
      s.SKU_CODE
  from
      average a
      inner join SKU s using(GOODS_CODE)
  where
      s.STD_COST_PRICE < a.AVG_STD_COST_PRICE
)
update
    SKU
set
    STD_COST_PRICE       = (select g.STD_COST_PRICE from GOODS g where g.GOODS_CODE = GOODS_CODE)
  , UPDATE_USER_NAME     = 'MODIFY'
  , USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
where
    SKU_CODE in (select SKU_CODE from targets)
;