update sku 
    set std_cost_price = 
        (
            select  goods_code,
                    std_cost_price, 
                    goods_code
                    std_cost_price, 
            case    
                when    std_cost_price < round(AVG(std_cost_price)) 
                    and 
                        sku.goods_code = goods_code
                    then    std_cost_price
                when    std_cost_price >= round(AVG(sku.std_cost_price))
                    and 
                            sku.goods_code = goods_code
                    then    sku.std_cost_price
            from    goods
            where   sku.goods_code = goods_code
            order by sku.goods_code
            
            ;
        ),
        update_user_name = 'MODIFY'
        user_update_datetime = '2024-08-31 00:00:00'
    
;


select sku.goods_code as 'SKU_商品コード(goods_code)',
       round(AVG(sku.std_cost_price)) as 'SKU_標準原価の平均値(平均標準原価)' ,
       goods.std_cost_price as 'G_標準原価'
       from sku 
       inner join goods on sku.goods_code = goods.GOODS_CODE
       group by sku.goods_code
       
;