Command
db.orders.aggregate([{$match:{status:'pending'}}, {$group:{_id:'$item', total:{$sum:'$qty'}}}])
Explanation
Performs aggregation pipeline operations like grouping and summing. Useful for analytics, reporting, and metrics.
Examples
Sum sales by region
db.sales.aggregate([{$group:{_id:'$region', total:{$sum:'$amount'}}}])