Template
single collection
multiple collections
mgodatagen
update
indexe
explain
Stage
Database
bson
mgodatagen
[{"key":1,"A":50},{"key":2,"A":100},{"key":2,"A":150}]
Query
db.collection.aggregate([{"$match":{"A":{"$gt":100}}},{"$facet":{"list":[],"average":[{"$group":{"_id":null,"value":{"$avg":"$A"}}}]}}])
Result