UPDATE SKU
SET STD_COST_PRICE = GOODS.STD_COST_PRICE
    ,UPDATE_USER_NAME = 'MODIFY'
    ,USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
FROM (
    SELECT GOODS_CODE
        ,ROUND(AVG(STD_COST_PRICE), 0) AS AVG_STD_COST_PRICE
    FROM SKU
    GROUP BY GOODS_CODE
) AS AVG_STD_COST_PRICE
INNER JOIN SKU AS SKU2
ON SKU2.GOODS_CODE = AVG_STD_COST_PRICE.GOODS_CODE
INNER JOIN GOODS
ON GOODS.GOODS_CODE = SKU2.GOODS_CODE
WHERE SKU.STD_COST_PRICE < AVG_STD_COST_PRICE.AVG_STD_COST_PRICE
AND SKU2.SKU_CODE = SKU.SKU_CODE
;