with avg_price_by_goods as (
    select goods_code, round(avg(std_cost_price), 1) avg_std_cost_price
    from sku
    group by goods_code
),
extended_sku as (
    select sku_code, sku.goods_code, goods.std_cost_price goods_price
    from sku
    join avg_price_by_goods a
    on sku.goods_code = a.goods_code
    join goods
    on sku.goods_code = goods.goods_code
    where sku.std_cost_price < avg_std_cost_price
)
update sku
set std_cost_price = e.goods_price,
    update_user_name = 'MODIFY',
    user_update_datetime = '2024-08-31 00:00:00'
from extended_sku e
where sku.sku_code = e.sku_code