UPDATE SKU AS S1
SET
    STD_COST_PRICE = G.STD_COST_PRICE
    , UPDATE_USER_NAME = 'MODIFY'
    , USER_UPDATE_DATETIME = '2024-08-31 00:00:00' 
FROM GOODS AS G
WHERE
    G.GOODS_CODE = S1.GOODS_CODE 
    AND S1.STD_COST_PRICE < (
        SELECT ROUND(AVG(STD_COST_PRICE))
        FROM SKU AS S2
        WHERE S1.GOODS_CODE = S2.GOODS_CODE
    );