with AverageCost as (
    select 
        GOODS_CODE,
        ROUND(AVG(STD_COST_PRICE), 1) AS AVG_STD_COST_PRICE
    from SKU
    group by GOODS_CODE
),
TargetSKU as (
    select 
        s.SKU_CODE,
        s.GOODS_CODE,
        s.STD_COST_PRICE CURRENT_STD_COST_PRICE,
        g.STD_COST_PRICE NEW_STD_COST_PRICE
    from SKU s
    join AverageCost a on s.GOODS_CODE = a.GOODS_CODE
    join GOODS g on s.GOODS_CODE = g.GOODS_CODE
    where s.STD_COST_PRICE < a.AVG_STD_COST_PRICE
)
update SKU
set 
    STD_COST_PRICE = b.NEW_STD_COST_PRICE,
    UPDATE_USER_NAME = 'MODIFY',
    USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
from TargetSKU b
where SKU.SKU_CODE = b.SKU_CODE
;