with avg_cost as (select GOODS_CODE                 as GOODS_CODE
                       , ROUND(avg(STD_COST_PRICE)) as AVG_STD_COST_PRICE
                  from SKU
                  group by GOODS_CODE)
update sku
set STD_COST_PRICE=min(sku.GOODS_CODE, b.GOODS_CODE)
  , UPDATE_USER_NAME='MODIFY'
  , USER_UPDATE_DATETIME='2024-08-31 00:00:00'
from  avg_cost b
where sku.GOODS_CODE=b.GOODS_CODE;