Database

[{name:"eggplant",price:3.42,quantity:1},{name:"eggplant",price:3.17,quantity:3},{name:"potato",price:2.12,quantity:5},{name:"potato",price:1.99,quantity:10},{name:"eggplant",price:3.33,quantity:3},{name:"cucumber",price:5.02,quantity:4},{name:"lettuce",price:3.42,quantity:1.5},{name:"cucumber",price:4.45,quantity:4},]

Query

db.collection.aggregate([{$group:{_id:"$name",averagePrice:{$avg:"$price"},quantitySum:{$sum:"$quantity"}}}])

Result