db={"players":[{"_id":{"$oid":"652f3470729e8d8a59b221dd"},"creator":{"$oid":"652af415729e8d8a59b2202f"},"name":"Player 1","email":"player1@email.com"},{"_id":{"$oid":"652f36c9f6ad40c3aedf0cdf"},"creator":{"$oid":"652af415729e8d8a59b2202f"},"name":"Player 2","email":"player2@email.com"}],"scores":[{"_id":{"$oid":"65386103b5e6b094e0980f2a"},"creator":{"$oid":"652af415729e8d8a59b2202f"},"tournament":{"$oid":"652f2515729e8d8a59b221b6"},"date":{"$date":{"$numberLong":"1698192000000"}},"scores":[{"player":{"$oid":"652f3470729e8d8a59b221dd"},"score":{"$numberInt":"10"},"_id":{"$oid":"65386103b5e6b094e0980f2b"}},{"player":{"$oid":"652f36c9f6ad40c3aedf0cdf"},"score":{"$numberInt":"20"},"_id":{"$oid":"65386103b5e6b094e0980f2c"}}]},{"_id":{"$oid":"6538611bb5e6b094e0980f59"},"creator":{"$oid":"652af415729e8d8a59b2202f"},"tournament":{"$oid":"652f2515729e8d8a59b221b6"},"date":{"$date":{"$numberLong":"1698192000000"}},"scores":[{"player":{"$oid":"652f3470729e8d8a59b221dd"},"score":{"$numberInt":"11"},"_id":{"$oid":"6538611bb5e6b094e0980f5a"}},{"player":{"$oid":"652f36c9f6ad40c3aedf0cdf"},"score":{"$numberInt":"21"},"_id":{"$oid":"6538611bb5e6b094e0980f5b"}}]}]}

db.scores.aggregate([{$unwind:{path:"$scores"}},{$group:{_id:"$scores.player",totalScore:{$sum:"$scores.score"}}},{$lookup:{from:"players",localField:"_id",foreignField:"_id",as:"fromPlayers"}},{$replaceRoot:{newRoot:{$mergeObjects:[{$arrayElemAt:["$fromPlayers",0]},"$$ROOT"]}}},{$project:{fromPlayers:0,creator:0}}])