with AVe as (
        select 
            GOODS_CODE,
            ROUND(AVG(coalesce(STD_COST_PRICE,0)),1) as Average
        from SKU
        group by GOODS_CODE
)
,sub as (
    select S.GOODS_CODE,G.STD_COST_PRICE as STD_COST_PRICE
    ,Average
    from SKU as S
    left outer join AVe  
      on S.GOODS_CODE=AVe.GOODS_CODE
    inner join GOODS as G
      on S.GOODS_CODE=G.GOODS_CODE
    where S.STD_COST_PRICE < AVe.Average
    )

update SKU
set 
    STD_COST_PRICE = sub.STD_COST_PRICE,
    UPDATE_USER_NAME = 'MODIFY',
    USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
from sub
where 
    SKU.GOODS_CODE = sub.GOODS_CODE;
--select * from SKU