WITH TAG_DATA AS (
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 INNER 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
)
UPDATE SKU
   SET STD_COST_PRICE = WK3.STD_COST_PRICE,
       UPDATE_USER_NAME = 'MODIFY',
       USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
  FROM TAG_DATA WK3
 WHERE SKU.GOODS_CODE = WK3.GOODS_CODE