with a as(
    select 
    SKU.GOODS_CODE,
    round(avg(SKU.STD_COST_PRICE)) as avg_STD_COST_PRICE
    from SKU
    inner join GOODS on GOODS.GOODS_CODE = SKU.GOODS_CODE
    group by SKU.GOODS_CODE
)
update SKU
set
STD_COST_PRICE = a.avg_STD_COST_PRICE,
UPDATE_USER_NAME = 'MODIFY',
USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
from a
where a.GOODS_CODE = SKU.GOODS_CODE
and a.avg_STD_COST_PRICE > SKU.STD_COST_PRICE