UPDATE SKU SET
     STD_COST_PRICE = TARGET.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 GOODS
         GROUP BY GOODS_CODE
     ) AS TARGET
WHERE SKU.GOODS_CODE = TARGET.GOODS_CODE
  AND SKU.STD_COST_PRICE <= TARGET.PRICE
;