如何在BigQuery中更新(乘以5，而不是简单地替换)嵌套的收入字段？

{
  "id": 1,
  "info": {
    "income": 100
  }
}

UPDATE my_dataset.my_table
SET info = JSON_SET(
  JSON_EXTRACT_SCALAR(info, '$'),
  '$.income',
  CAST(JSON_EXTRACT_SCALAR(info, '$.income') * 5 AS STRING)
)
WHERE id = 1;

UPDATE my_dataset.my_table
SET info = JSON_SET(
  JSON_EXTRACT_SCariant(info, '$'),
  '$.income',
  CAST(JSON_EXTRACT_SCALAR(info, '$.income') * 5 AS STRING)
);