WITH SubQuery AS (
    SELECT GOODS_CODE FROM SKU 
    GROUP BY GOODS_CODE
    HAVING STD_COST_PRICE<ROUND(AVG(STD_COST_PRICE),1)
    )

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