Details
-
Task
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
None
-
None
Description
Here is the query:
db.order_lineitem.aggregate(
|
[
|
{
|
$match: {
|
$and: [
|
{ "order.o_orderdate": { $gte: ISODate("1992-01-01") } }, |
{ "order.o_orderdate": { $lte: ISODate("1996-01-01") } }, |
{ l_discount: { $gte: 0.1 } }, |
{ l_discount: { $lte: 0.3 } } |
],
|
l_quantity: {
|
$lte: 25 |
}
|
},
|
},
|
{
|
$group: {
|
_id: 1, |
revenue: {
|
$sum: {
|
$multiply: [
|
"$l_extendedprice", |
"$l_discount" |
]
|
}
|
}
|
}
|
}
|
]
|
)
|