with AVG_SKU AS (
    select  SUB_SKU.GOODS_CODE
    ,       ROUND(AVG(SUB_SKU.STD_COST_PRICE), 1) AS AVG_COST_PRICE
    from SKU as SUB_SKU
    group by SUB_SKU.GOODS_CODE 
)
update SKU
set STD_COST_PRICE          = GOODS.STD_COST_PRICE
,   UPDATE_USER_NAME        = 'MODIFY'
,   USER_UPDATE_DATETIME    = '2024-08-31 00:00:00'
from GOODS
where exists(
    select 1
      from AVG_SKU
     where AVG_SKU.AVG_COST_PRICE > SKU.STD_COST_PRICE
       and AVG_SKU.GOODS_CODE = SKU.GOODS_CODE
)
  and GOODS.GOODS_CODE = SKU.GOODS_CODE;