UPDATE SKU
SET 
STD_COST_PRICE = (SELECT STD_COST_PRICE FROM GOODS),
UPDATE_USER_NAME = 'MODIFY',
USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
WHERE GOODS_CODE =
(SELECT s.GOODS_CODE
FROM SKU s
INNER JOIN GOODS g
on s.GOODS_CODE = g.GOODS_CODE 
GROUP BY s.GOODS_CODE
HAVING g.STD_COST_PRICE > ROUND(AVG(s.STD_COST_PRICE), 1));