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.SKU_CODE as SKU_CODE
        ,G.STD_COST_PRICE as GSTD_COST_PRICE
        ,S.STD_COST_PRICE as SSTD_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
    )
--select * from sub

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