Database

[{"_id":"61cab7361f1c58e1555b1cbb","userId":"user1","matchType":"tournament","scoreHoles":[{"hole":"hole1","put":2,"_id":"61cab86e0f765cd9428de547"},{"holeId":"hole2","put":3,"_id":"61cab86e0f765cd9428de548"}],},{"_id":"61cab6361f1c58e1555b1c93","userId":"user 2","matchType":"tournament","scoreHoles":[{"holeId":"hole1","put":4,},{"holeId":"hole2","put":4,}],}]

Query

db.collection.aggregate([{$project:{_id:0,userId:1,scoreHoles:1,totalPuts:{"$reduce":{"input":"$scoreHoles","initialValue":0,"in":{$sum:["$$value","$$this.put"]}}}}},{"$sort":{totalPuts:-1}}])

Result