[{"_id":1,"email":"amrit@gmail.com","status":"ACTIVE"},{"_id":2,"email":"abc@gmail.com","status":"INACTIVE"},{"_id":3,"email":"tut@gmail.com","status":"ACTIVE"},{"_id":4,"email":"amrit@gmail.com","status":"INACTIVE"},{"_id":5,"email":"tut@gmail.com","status":"ACTIVE"},{"_id":6,"email":"cat@gmail.com","status":"ACTIVE"},]

db.collection.aggregate([{$group:{_id:{email:"$email"},uniqueIds:{$addToSet:"$_id"},status:{$addToSet:"$status"}}},{$match:{status:{"$all":["ACTIVE","INACTIVE"]}}},{$project:{status:0}}])