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 DISTINCT 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 GOODS_CODE = WK3.GOODS_CODE