[{_id:1,query:"A",createdAt:1660610671},{_id:2,query:"A",createdAt:1660610672},{_id:3,query:"A",createdAt:1660610673},{_id:4,query:"A",createdAt:1660610674},{_id:5,query:"B",createdAt:1660610675},{_id:6,query:"C",createdAt:1660610676},{_id:7,query:"C",createdAt:1660610677},{_id:8,query:"C",createdAt:1660610678},{_id:9,query:"D",createdAt:1660610680},{_id:10,query:"D",createdAt:1660610681},]

db.collection.aggregate([{"$group":{"_id":"$query","frequency":{"$sum":1}}},{"$project":{"query":"$_id","frequency":1,"_id":0}},{"$sort":{frequency:-1}},{"$group":{"_id":null,"array":{"$push":"$$ROOT"}}},{"$unwind":{path:"$array","includeArrayIndex":"rank"}},{"$project":{_id:0,rank:{"$add":["$rank",1]},frequency:"$array.frequency",query:"$array.query"}}])