UPDATE SKU SET STD_COST_PRICE = T.STD_COST_PRICE,UPDATE_USER_NAME='MODIFY',USER_UPDATE_DATETIME='2024-08-31 00:00:00' 
from (
    select GOODS.GOODS_CODE,GOODS.STD_COST_PRICE,avg(SKU.STD_COST_PRICE) as av
    from SKU
        -- join (
        --     select GOODS_CODE,avg(STD_COST_PRICE) as av from SKU
        --     group by GOODS_CODE
        -- ) as T1 on SKU.GOODS_CODE = T1.GOODS_CODE
    join GOODS on GOODS.GOODS_CODE = SKU.GOODS_CODE
    -- where GOODS.STD_COST_PRICE < T1.av
    group by GOODS.GOODS_CODE
) as T
where T.GOODS_CODE = SKU.GOODS_CODE AND SKU.STD_COST_PRICE < T.av;