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