Database

[{_id:"post10",featured:true,created_at:ISODate("2022-11-29T18:09:47.367Z")},{_id:"post9",featured:false,created_at:ISODate("2022-11-29T18:09:54.387Z")},{_id:"post8",featured:false,created_at:ISODate("2022-11-29T18:09:57.537Z")},{_id:"post7",featured:true,created_at:ISODate("2022-11-29T18:10:12.927Z")},{_id:"post6",featured:false,created_at:ISODate("2022-11-29T18:10:22.129Z")},{_id:"post5",featured:false,created_at:ISODate("2022-11-29T18:10:26.809Z")},{_id:"post4",featured:false,created_at:ISODate("2022-11-29T18:10:30.230Z")},{_id:"post3",featured:false,created_at:ISODate("2022-11-29T18:10:32.930Z")},{_id:"post2",featured:false,created_at:ISODate("2022-11-29T18:10:35.427Z")},{_id:"post1",featured:false,created_at:ISODate("2022-11-29T18:10:38.262Z")}]

Query

db.collection.aggregate([{"$sort":{created_at:-1}},{"$limit":3},{"$unionWith":{coll:"collection",pipeline:[{"$match":{featured:true}}]}},{"$facet":{latest:[{"$match":{featured:false}}],featured:[{"$match":{featured:true}}]}}])

Result