- 
    Type:
Task
 - 
    Resolution: Incomplete
 - 
    Priority:
Major - P3
 - 
    None
 - 
    Affects Version/s: None
 - 
    Component/s: None
 - 
    None
 
- 
        None
 
- 
        None
 - 
        None
 - 
        None
 - 
        None
 - 
        None
 - 
        None
 
db.order_lineitem.aggregate([
    {
        $match: {
            $and: [
                { "order.o_orderdate": { $gte: ISODate("1992-01-01") } },
                { "order.o_orderdate": { $lte: ISODate("1996-01-01") } },
            ]
        },
    },
    {
        $group: {
                _id: "$order.o_orderkey",
                priority: { $last: "$order"},
                someSum: {
                    $sum: "$l_extendedprice"
                },
                anotherSum1: {
                    $sum: "$l_discount"
                },
                anotherSum2: {
                    $sum: "$l_tax"
                },
                anotherSum3: {
                    $sum: "$l_quantity"
                },
                count: { $sum: 1 }
            }
        }
    ]
)  
- Investigate perf, see if there's any low-hanging fruit
 - if no low hanging fruit, I'd still like to understand where all the time is spent in this query
 
- depends on
 - 
                    
SERVER-70726 Support pushing down as per-path filters AND of supported expressions on the same path
-         
 - Closed
 
 -