UPDATE SKU SET
     STD_COST_PRICE = TARGET.PRICE
    ,UPDATE_USER_NAME = 'MODIFY'
    ,USER_UPDATE_DATETIME = '2024-08-31 00:00:00'
FROM (
     SELECT
          SKU_SUB.GOODS_CODE
         ,MIN(TARGET_SUB.PRICE) AS PRICE
     FROM SKU AS SKU_SUB INNER JOIN (
              SELECT
                   GOODS_CODE
                  ,ROUND(AVG(STD_COST_PRICE), 0) AS PRICE
              FROM GOODS
              GROUP BY GOODS_CODE
          ) AS TARGET_SUB
     WHERE SKU_SUB.GOODS_CODE = TARGET_SUB.GOODS_CODE
       AND SKU_SUB.STD_COST_PRICE < TARGET_SUB.PRICE
     GROUP BY SKU_SUB.GOODS_CODE
     ) AS TARGET
WHERE SKU.GOODS_CODE = TARGET.GOODS_CODE
;