Database
[{"_id":ObjectId("62304f3a53b273b7a6ea0eca"),"name":"Ankita","subject":"English","marks":70},{"_id":ObjectId("62304f3a53b273b7a6ea0ecb"),"name":"Ritwik","subject":"Maths","marks":80},{"_id":ObjectId("6232c4b8c2f3cc1a0e9fa107"),"name":"Mayank","subject":"Science","marks":85},{"_id":ObjectId("6232c4b8c2f3cc1a0e9fa108"),"name":"Ankita","subject":"History","marks":90},{"_id":ObjectId("6232c4b8c2f3cc1a0e9fa109"),"name":"Ritwik","subject":"Economics","marks":75},{"_id":ObjectId("6232fa5fc2f3cc1a0e9fa10a"),"name":"Mayank","subject":"Polity","marks":60}]
Query
db.collection.aggregate([{"$match":{"name":{"$in":["Mayank","Ankita"]}}},{"$facet":{"less":[{"$match":{"marks":{"$lte":65}}}],"near":[{"$match":{"marks":{"$gt":65}}},{"$sort":{"marks":1}},{"$group":{"_id":"$name","result":{"$first":"$$ROOT"}}}]}},{"$project":{"result":{"$concatArrays":["$less",{"$map":{"input":{"$filter":{"input":"$near","cond":{"$not":{"$in":["$$this.result.name","$less.name"]}}}},"in":"$$this.result"}}]}}},{"$unwind":"$result"},{"$replaceRoot":{"newRoot":"$result"}}])