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 
GOODS_CODE IN(

SELECT G.GOODS_CODE FROM GOODS G
inner join 
(SELECT GOODS_CODE ,ROUND(AVG(STD_COST_PRICE),0)AV_PRICE FROM SKU
GROUP BY goods_code) S
ON 
G.GOODS_CODE = S.GOODS_CODE
WHERE G.STD_COST_PRICE > S.AV_PRICE
)