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));

UPDATE SKU
    SET STD_COST_PRICE=(SELECT STD_COST_PRICE FROM GOODS WHERE GOODS_CODE IN 
    (SELECT GOODS_CODE FROM SKU GROUP BY GOODS_CODE
    HAVING STD_COST_PRICE<ROUND(AVG(STD_COST_PRICE),1)))
    WHERE GOODS_CODE IN (SELECT GOODS_CODE FROM SKU GROUP BY GOODS_CODE
    HAVING STD_COST_PRICE<ROUND(AVG(STD_COST_PRICE),1));