Computer scienceFundamentalsSQL and DatabasesDBMSMongoDBOperations and operators

Aggregate operations

Aggregation pipeline

Report a typo

Suppose we have a collection called orders that contains documents with the following fields: _id, customer, date, total.

We want to group the orders by customer and calculate the total amount spent by each customer.

Chose the box with correct aggregation pipeline:

Select one option from the list

db.orders.aggregate([ { $group: { _id: "$customer", totalSpent: { $avg: "$total" } } } ])

db.orders.aggregate([ { $group: { _id: "$customer", totalSpent: { $sum: "$total" } } } ])

db.orders.aggregate([ { $sort: { _id: "$total", totalSpent: { $sum: "$customer" } } } ])

db.orders.aggregate([ { $match: { _id: "$customer", totalSpent: { $sum: "$total" } } } ])

___

Create a free account to access the full topic