[{"id":1,"score":1,created_at:ISODate("2022-11-19T01:00:00+01:00")},{"id":1,"score":2,created_at:ISODate("2022-11-19T02:00:00+01:00")},{"id":1,"score":3,created_at:ISODate("2021-11-19T03:00:00+01:00")},{"id":2,"score":1,created_at:ISODate("2022-11-19T01:00:00+01:00")},{"id":2,"score":20,created_at:ISODate("2022-11-19T02:00:00+01:00")},{"id":2,"score":22,created_at:ISODate("2022-11-19T03:00:00+01:00")}]

db.collection.aggregate([{$match:{$expr:{$gte:["$created_at",{$subtract:["$$NOW",86400000]}]}}},{"$sort":{"created_at":-1}},{"$group":{"_id":"$id","score":{"$push":"$score"}}},{"$project":{"score":{"$sum":{"$firstN":{"n":2,"input":"$score"}}}}},{"$match":{"score":{"$lt":5}}}])