[{"name":"AKL to DUD Via CHC","rates":[{"container_id":"abc","buyRate":380},{"container_id":"def","buyRate":410}]},{"name":"AKL to DUD","rates":[{"container_id":"abc","buyRate":400},{"container_id":"def","buyRate":420}]},{"name":"AKL to DUD Via CHC","rates":[{"container_id":"abc","buyRate":405},{"container_id":"def","buyRate":500}]},{"name":"AKL to DUD Via CHC","rates":[{"container_id":"abc","buyRate":300},{"container_id":"def","buyRate":700}]},{"name":"AKL to DUD Via CHC","rates":[{"container_id":"def","buyRate":1000},{"container_id":"abc","buyRate":100}]}]

db.collection.aggregate([{$addFields:{containerBuyRate:{$arrayElemAt:["$rates",{$indexOfArray:["$rates.container_id","abc"]}]}}},{$sort:{"containerBuyRate.buyRate":-1}}])