UPDATE sku
SET std_cost_price = sub.std_cost_price,
    update_user_name = 'MODIFY',
    user_update_datetime = '2024-08-31 00:00:00'
FROM
     (SELECT 
        sk1.goods_code, 
        gd.std_cost_price,
        ROUND(AVG(sk1.std_cost_price)) AS scp
      FROM sku as sk1
        INNER JOIN goods as gd
          ON gd.goods_code = sk1.goods_code
      GROUP BY sk1.goods_code, gd.std_cost_price) AS sub
WHERE 
  sku.goods_code = sub.goods_code AND
  sku.std_cost_price < sub.scp;