[{"_id":1,"name":"Product 1","status":"active","createdAt":ISODate("2023-01-01T10:00:00Z")},{"_id":2,"name":"Product 2","status":"reserved","createdAt":ISODate("2023-01-02T09:00:00Z")},{"_id":3,"name":"Product 3","status":"active","createdAt":ISODate("2023-01-03T12:00:00Z")},{"_id":4,"name":"Product 4","status":"pending","createdAt":ISODate("2023-01-04T11:00:00Z")},{"_id":5,"name":"Product 5","status":"sold","createdAt":ISODate("2023-01-05T14:00:00Z")},{"_id":6,"name":"Product 6","status":"active","createdAt":ISODate("2023-01-06T13:00:00Z")},{"_id":7,"name":"Product 7","status":"sold","createdAt":ISODate("2023-01-07T16:00:00Z")},{"_id":8,"name":"Product 8","status":"active","createdAt":ISODate("2023-01-08T15:00:00Z")}]

db.collection.aggregate([{$addFields:{sortBy:{$cond:[{$eq:["$status","active"]},0,1]}}},{$sort:{sortBy:1,createdAt:-1}},{$project:{sortBy:0}}])