BT
Size: a a a
BT
С
RS
VT
А
RS
RS
VT
VT
OS
RS
RS
RS
А
AK
BT
VT
С
db.sales.aggregate(SQL:
[
// First Stage
{
$group :
{
_id : "$item",
totalSaleAmount: { $sum: { $multiply: [ "$price", "$quantity" ] } }
}
},
// Second Stage
{
$match: { "totalSaleAmount": { $gte: 100 } }
}
]
)
SELECT item,
Sum(( price * quantity )) AS totalSaleAmount
FROM sales
GROUP BY item
HAVING totalSaleAmount >= 100