with avgPrice as
(
select
    GOODS_CODE,
    round(avg(STD_COST_PRICE), 0) as AVG_PRICE
from
    SKU
group by
    GOODS_CODE
)
update
    SKU
set
    STD_COST_PRICE = (select STD_COST_PRICE from GOODS where GOODS.GOODS_CODE = SKU.GOODS_CODE),
    UPDATE_USER_NAME = 'MODIFY',
    USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
where exists
     (
      select 'X'
      from avgPrice
      where
           SKU.GOODS_CODE = avgPrice.GOODS_CODE
      and  SKU.STD_COST_PRICE < avgPrice.AVG_PRICE
     )