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