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