WITH TMP1 AS (
SELECT
GOODS_CODE,ROUND(AVG(STD_COST_PRICE),1) AS STD_COST_PRICE
FROM
SKU
GROUP BY
GOODS_CODE
)
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
 SKU.SKU_CODE IN (
 SELECT SKU_CODE FROM SKU INNER JOIN TMP1
        ON
              SKU.STD_COST_PRICE <  TMP1.STD_COST_PRICE
        AND   SKU.GOODS_CODE = TMP1.GOODS_CODE
 )