我在 Cosmos DB 中创建了一些文档,如下所示:
[
{
"class": "class01",
"student": {
"lastReport": [
{
"Name": "st01",
"score": "C"
},
{
"Name": "st02",
"score": "B"
}
],
"lastTime": "2018-05-10"
}
},
{
"class": "class02",
"student": {
"lastReport": [
{
"Name": "st03",
"score": "C"
},
{
"Name": "st01",
"score": "A"
}
],
"lastTime": "2018-05-10"
}
},
{
"class": "class01",
"student": {
"lastReport": [
{
"Name": "st01",
"score": "C"
},
{
"Name": "st02",
"score": "A"
},
{
"Name": "st03",
"score": "B"
}
],
"lastTime": "2018-05-10"
}
}
]
你能帮助我如何计算所有数据中的分数值吗?我的期望是这样的结果:
[
{
"score": "C",
"Num" : 3
},
{
"score": "B",
"Num" : 2
},
{
"score": "A",
"Num" : 2
}
]