UPDATE SKU
   SET STD_COST_PRICE = WK3.STD_COST_PRICE,
       UPDATE_USER_NAME = 'MODIFY',
       USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
  FROM ( 
SELECT GS.GOODS_CODE,GS.STD_COST_PRICE
  FROM GOODS GS INNER JOIN (SELECT A.GOODS_CODE,A.STD_COST_PRICE AS G_DATE,WK.STD_COST_PRICE
                              FROM SKU A LEFT JOIN (SELECT GOODS_CODE,
                                                           ROUND(AVG(STD_COST_PRICE),0) AS STD_COST_PRICE
                                                      FROM SKU
                                                     GROUP BY GOODS_CODE
                                                   ) WK
                                           ON A.GOODS_CODE = WK.GOODS_CODE 
                             WHERE A.STD_COST_PRICE < WK.STD_COST_PRICE
                           ) WK2
                   ON GS.GOODS_CODE = WK2.GOODS_CODE
        ) WK3
 WHERE SKU.GOODS_CODE = WK3.GOODS_CODE