db={notes:[{"_id":{"$oid":"60a8f82df06d8601849b2a01"},"isbn":9789401466097,"chapter":2,"notes":[{"note":"a note","dt":2374238742345,},{"note":"another note about the same book and chapter","dt":2345234234,}]},{"_id":{"$oid":"60a8f82df06d8601849b2a02"},"isbn":9789401466097,"chapter":1,"notes":[{"note":"A note about the same book but another chapter","dt":23742387423},]},{"_id":{"$oid":"60a8f82df06d8601849b2a03"},"isbn":9789401488088,"chapter":1,"notes":[{"note":"something about another book","dt":23742384555},{"note":"something else","dt":23452333333}]}],books:[{"_id":{"$oid":"60a8f82df06d8601849b2a04"},"isbn":9789401488088,"title":"a",},{"_id":{"$oid":"60a8f82df06d8601849b2a05"},"isbn":9789401466097,"title":"b",}]}

db.notes.aggregate([{$group:{_id:"$isbn",the_notes:{$sum:{$size:"$notes"}}}},{$lookup:{from:"books",localField:"_id",foreignField:"isbn",as:"the_book",pipeline:[{$project:{_id:"$_id",isbn:"$isbn",title:"$title"}}]}},{$project:{the_book:{$first:"$the_book"},the_notes:1,_id:0}}])