update sku as base
set STD_COST_PRICE=(select ROUND(avg(ex.STD_COST_PRICE))
                    from sku as ex
                    where base.GOODS_CODE = ex.GOODS_CODE)
  , UPDATE_USER_NAME='MODIFY'
  , USER_UPDATE_DATETIME='2024-08-31 00:00:00'
where base.STD_COST_PRICE
          > (select ROUND(avg(ex.STD_COST_PRICE))
             from sku as ex
             where base.GOODS_CODE = ex.GOODS_CODE);