db={"songs":[{"_id":{"$oid":"60debdaae7593406b682e45d"},"slug":"albins-test-artister-branches-11","title":"Branches","artistName":"My test artisters","songAdministrators":[],"agreements":{"songComposition":{"$oid":"612c8d394459ebd2483a0920"}}}],"agreements":[{"_id":{"$oid":"612c8d394459ebd2483a0920"},"agreementVersion":[{"version":1,"allHaveSigned":false,"_id":{"$oid":"612c8d394459ebd2483a0921"},"approvalStatus":[{"_id":{"$oid":"612c8d394459ebd2483a0922"},"publisherSignsFor":{"$oid":"60801bef03a9cd5f4a097e76"},"signingPerson":{"$oid":"60d06fc53a7fc65be3787df8"},"isSignedByPublisher":true},{"_id":{"$oid":"612c8d394459ebd2483a0923"},"publisherSignsFor":null,"signingPerson":{"$oid":"60d06fc53a7fc65be3787df8"},"isSignedByPublisher":false},{"_id":{"$oid":"612c8d394459ebd2483a0921"},"publisherSignsFor":{"$oid":"60801bef03a9cd5f4a097e76"},"signingPerson":{"$oid":"60d06fc53a7fc65be3787df9"},"isSignedByPublisher":true}],"isLatestVersion":true,"createdAt":{"$date":"2021-08-30T07:48:09.979Z"}}],"addedAt":{"$date":"2021-08-30T07:48:09.979Z"},"__v":0}]}

db.songs.aggregate([{"$lookup":{"from":"agreements","localField":"agreements.songComposition","foreignField":"_id","as":"agreements.songComposition"}},{"$unwind":{"path":"$agreements.songComposition","preserveNullAndEmptyArrays":false}},{"$unwind":{"path":"$agreements.songComposition.agreementVersion","preserveNullAndEmptyArrays":false}},{"$unwind":{"path":"$agreements.songComposition.agreementVersion.approvalStatus","preserveNullAndEmptyArrays":false}},{"$match":{"$and":[{"agreements.songComposition.agreementVersion.isLatestVersion":true},{"agreements.songComposition.agreementVersion.approvalStatus.signingPerson":ObjectId("60d06fc53a7fc65be3787df8")}],"$or":[{"agreements.songComposition.agreementVersion.approvalStatus.isApprovedByUser":false},{"agreements.songComposition.agreementVersion.approvalStatus.isApprovedByUser":{"$exists":false}}]}},{"$facet":{"songs":[{"$group":{"_id":"$_id","title":{"$first":"$title"},"artistName":{"$first":"$artistName"},"agreements":{"$push":"$agreements.songComposition"},"count":{"$sum":1}}}],"countAgreements":[{"$group":{"_id":null,"count":{"$sum":1}}}]}},{"$project":{"songs":1,"sumAgreements":{"$arrayElemAt":["$countAgreements.count",0]}}}])