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