[{"_id":"123456","name":"StudentB","subject":[{"_id":"78901","subjectName":"Politics 101","prerequisite":[]},{"_id":"10987","subjectName":"Geography 500","prerequisite":[]},{"_id":"78901","subjectName":"Science 500","prerequisite":["Science 204","Math 100"]},{"_id":"54321","subjectName":"Maths 600","prerequisite":["Science 400","Math 400"]}]},{"_id":"654321","name":"StudentA","subject":[{"_id":"78901","subjectName":"Music 101","prerequisite":[]},{"_id":"78901","subjectName":"History 500","prerequisite":["History 200"]},{"_id":"54321","subjectName":"Maths 600","prerequisite":["Science 400","Math 400"]},{"_id":"10987","subjectName":"Geography 500","prerequisite":[]}]}]

db.collection.aggregate([{$project:{"_id":1,"name":1,"subject._id":1,"subject.subjectName":1,"subject.prerequisite":1}},{$unwind:"$subject"},{$sort:{"subject.subjectName":1}},{$addFields:{"subject.viewOrder":{$cond:{if:{$size:"$subject.prerequisite"},then:1,else:0}}}},{$sort:{"subject.viewOrder":-1}},{$project:{"subject.viewOrder":0}},{$group:{_id:"$_id",subject:{$push:"$subject"},name:{$first:"$name"}}},{$sort:{name:1}}])