UPDATE SKU
SET STD_COST_PRICE = (
    SELECT ROUND(AVG(STD_COST_PRICE), 1)
    FROM SKU
    WHERE GOODS_CODE = SKU.GOODS_CODE
)
WHERE STD_COST_PRICE < (
    SELECT ROUND(AVG(STD_COST_PRICE), 1)
    FROM SKU
    WHERE GOODS_CODE = SKU.GOODS_CODE
);

UPDATE GOODS
SET STD_COST_PRICE = (
    SELECT ROUND(AVG(STD_COST_PRICE), 1)
    FROM SKU
    WHERE GOODS_CODE = GOODS.GOODS_CODE
),
UPDATE_USER_NAME = 'MODIFY',
USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
WHERE GOODS_CODE IN (
    SELECT DISTINCT GOODS_CODE
    FROM SKU
);