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