jq:根据group by计算嵌套对象值

[
  {
    "name": "Alice",
    "age": 25,
    "department": "Sales",
    "salary": 5000
  },
  {
    "name": "Bob",
    "age": 30,
    "department": "Sales",
    "salary": 6000
  },
  {
    "name": "Charlie",
    "age": 35,
    "department": "Marketing",
    "salary": 7000
  },
  {
    "name": "Dave",
    "age": 40,
    "department": "Marketing",
    "salary": 8000
  }
]

cat data.json | jq 'group_by(.department) | map({department: .[0].department, totalSalary: map(.salary) | add})'

[
  {
    "department": "Sales",
    "totalSalary": 11000
  },
  {
    "department": "Marketing",
    "totalSalary": 15000
  }
]