update  sku
   set  STD_COST_PRICE =
    (select  g.STD_COST_PRICE
      from  (select  GOODS_CODE g_code
            ,round(avg(STD_COST_PRICE),1) avg_cost
              from  SKU s
               group by GOODS_CODE)s
               ,GOODS g
     where  s.g_code = g.GOODS_CODE
       and  s.avg_cost > g.STD_COST_PRICE
       and  sku.GOODS_CODE = g.GOODS_CODE
    )
    ,UPDATE_USER_NAME = 'MODIFY'
   ,USER_UPDATE_DATETIME = '2024-08-31 00:00:00'

 where  exists (
 select  g.STD_COST_PRICE
  from  (select  GOODS_CODE g_code
        ,round(avg(STD_COST_PRICE),1) avg_cost
          from  SKU s
           group by GOODS_CODE)s
           ,GOODS g
 where  s.g_code = g.GOODS_CODE
   and  s.avg_cost > g.STD_COST_PRICE
   and  sku.GOODS_CODE = g.GOODS_CODE
)