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