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