UPDATE SKU
SET 
STD_COST_PRICE = (SELECT STD_COST_PRICE FROM GOODS WHERE GOODS_CODE = SKU.GOODS_CODE)
,UPDATE_USER_NAME = 'MODIFY'
,USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
WHERE 
SKU_CODE IN(
SELECT S.SKU_CODE
FROM SKU S
inner join 
(SELECT 
    GOODS_CODE ,
    ROUND(AVG(STD_COST_PRICE),0)AV_PRICE FROM SKU
GROUP BY GOODS_CODE) S2
ON 
S.GOODS_CODE = S2.GOODS_CODE
WHERE S.STD_COST_PRICE < S2.AV_PRICE
)
;