Azure Cosmos Db Group By with Select statement

[ssghoda]

Our Cosmos Db Container for Doctors is partitioned by networkId. Each Doctor document has id, fullName, npi, providerType, gender and then there is an array of offices the doctor is working for that networkId.

{
"id": "",
"fullName": "",
"npi": "",
"providerType": "",
"gender": "",
"networkId": "",
"offices": [
  {
  "officeId": "",
  "officeName": "",
  "address": ""
  },
  {
  "officeId": "",
  "officeName": "",
  "address": ""
  }
]
}

I want to write a query using Group By clause where I want to gather all offices under all networkId partitions for a given doctor's npi.

I am trying something like this and need help writing something which can help my goal:

SELECT DISTINCT c.fullName, c.providerType, c.gender, c.npi, [c.offices] as offices
FROM c
WHERE c.npi = 'something'
GROUP BY c.fullName, c.providerType, c.gender, c.npi