[{"email":"one@gmail.com","companyRegNo":105,"event":{"created":ISODate("2022-09-16T06:42:04.387Z"),"desc":"COMPLETED_APPLICATIONS","note":"Direct apply"}},{"email":"one@gmail.com","companyRegNo":105,"event":{"created":ISODate("2022-09-20T06:42:42.761Z"),"desc":"ASKED_TO_REVIEW",}},{"email":"two@gmail.com","companyRegNo":227,"event":{"created":ISODate("2022-09-16T06:42:04.387Z"),"desc":"COMPLETED_APPLICATIONS","note":"Direct apply",}},{"email":"two@gmail.com","companyRegNo":227,"event":{"created":ISODate("2022-09-28T06:42:42.761Z"),"desc":"ASKED_TO_REVIEW",}},{"email":"three@gmail.com","companyRegNo":157,"event":{"created":ISODate("2022-09-16T06:42:04.387Z"),"desc":"COMPLETED_APPLICATIONS","note":"Direct apply",}},{"email":"four@gmail.com","companyRegNo":201,"deleted":true,"event":{"created":ISODate("2022-09-15T06:42:42.761Z"),"desc":"COMPLETED_APPLICATIONS",}},]

db.collection.aggregate([{"$group":{"_id":"$email","field":{"$push":"$$ROOT"}}},{"$match":{$expr:{"$eq":[0,{"$size":{"$filter":{"input":"$field","as":"item","cond":{"$or":[{"$and":[{"$eq":[{"$getField":{"field":"desc","input":"$$item.event"}},"ASKED_TO_REVIEW"]},{"$lt":[{"$getField":{"field":"created","input":"$$item.event"}},ISODate("2022-09-25")]}]},{"$eq":[{"$getField":{"field":"deleted","input":"$$item"}},true]}]}}}}]}}},{"$project":{email:"$_id","_id":0}}])