WITH avg_stdcost as(
    SELECT round(AVG(STD_COST_PRICE),1) as avgcost, GOODS_CODE avggd
    FROM SKU
    GROUP BY GOODS_CODE
),
hikui as(
    SELECT DISTINCT SKU_CODE as hikuicd,GD.STD_COST_PRICE AS hj
    FROM SKU,avg_stdcost,GOODS GD
    WHERE SKU.STD_COST_PRICE < avgcost
    AND SKU.GOODS_CODE = GD.GOODS_CODE
    AND SKU.GOODS_CODE = avggd
)

UPDATE SKU
SET STD_COST_PRICE = h.hj,UPDATE_USER_NAME = 'MODIFY',USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
FROM (SELECT hj,hikuicd FROM hikui) as h
WHERE SKU_CODE = h.hikuicd;