[{"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":{"$and":[{"field.deleted":{"$ne":true}},{"$or":[{"field":{"$elemMatch":{"event.desc":"ASKED_TO_REVIEW","event.created":{"$lt":ISODate("2022-09-25")}}}},{"field.event.desc":{"$ne":"ASKED_TO_REVIEW"}}]}]}},{"$project":{email:"$_id","_id":0}}])