[{"_id":ObjectId("64c8de6e10f1e5f6958033d7"),"address":"nowhere","city":"NY","name":"ABD","count":NumberInt(19),"timestamp":ISODate("2023-08-01T05:30:42.956Z")},{"_id":ObjectId("64c8de6e10f1e5f6958033d6"),"address":"somewhere","city":"NY","name":"WBE","count":NumberInt(4),"timestamp":ISODate("2023-08-01T05:29:02.956Z")},{"_id":ObjectId("64c8de6e10f1e5f6958033da"),"address":"somewhere","city":"NY","name":"WBE","count":NumberInt(18),"timestamp":ISODate("2023-08-01T08:30:42.956Z")}]

db.collection.aggregate([{$match:{timestamp:{$gte:ISODate("2023-08-01T03:36:38.059Z")}}},{$group:{_id:"$name",count24:{$sum:"$count"},count12:{$sum:{$cond:[{$gte:["$timestamp",ISODate("2023-08-01T07:36:38.059Z")]},"$count",0]}},city:{$first:"$city"}}},{$facet:{last24Hours:[{$sort:{count24:-1}},{$limit:5},{$project:{_id:0,name:"$_id",city:1,count:"$count24"}}],last12Hours:[{$sort:{count12:-1}},{$limit:5},{$match:{count12:{$ne:0}}},{$project:{_id:0,name:"$_id",city:1,count:"$count12"}}]}}])