db={product:[{"_id":"61cad304ba727b75f4d5bbcc","name":"ac",postedBy:"61bf14984c9593325c96c01b"}],profile:[{"_id":"61bf14984c9593325c96c01b","name":"lalwani ji","reviews":[{"_id":"61cc6e544607e3ea649c5f35","rating":5,"item":"61cad304ba727b75f4d5bbcc","updatedAt":"2021-12-29T14:19:00.567Z","createdAt":"2021-12-29T14:19:00.567Z"},{"_id":"61cc6e624607e3ea649c5f38","rating":2,"item":"61cad304ba727b75f4d5bbcc","updatedAt":"2021-12-29T14:19:14.305Z","createdAt":"2021-12-29T14:19:14.305Z"},{"_id":"61cc6e784607e3ea649c5f3b","rating":2,"item":"61cad304ba727b75f4d5bbcc","updatedAt":"2021-12-29T14:19:36.115Z","createdAt":"2021-12-29T14:19:36.115Z"}]},]}

db.product.aggregate([{$lookup:{from:"profile",let:{postedBy:"$postedBy",id:"$_id"},pipeline:[{$match:{$expr:{$eq:["$$postedBy","$_id"]}}},{$project:{_id:0,rating:{$avg:{$reduce:{input:"$reviews",initialValue:[],in:{$concatArrays:["$$value",{$cond:[{$eq:["$$this.item","$$id"]},["$$this.rating"],[]]}]}}}}}}],as:"avgRating"}},{$set:{avgRating:{$first:"$avgRating.rating"}}}])