-- 更新用の一時テーブル作成
WITH Ave AS (
    SELECT 
        GOODS_CODE,
        ROUND(AVG(STD_COST_PRICE), 1) AS AVG_STD
    FROM SKU
    GROUP BY GOODS_CODE
)


UPDATE SKU
SET 
    STD_COST_PRICE = (SELECT STD_COST_PRICE FROM GOODS WHERE SKU.GOODS_CODE = GOODS.GOODS_CODE),
    UPDATE_USER_NAME = 'MODIFY',
    USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
WHERE 
    STD_COST_PRICE < (SELECT AVG_STD FROM Ave WHERE SKU.GOODS_CODE = Ave.GOODS_CODE);