Database
[{BookDate:"BOOKA-2010",Price:"1",BookName:"BOOKA"},{BookDate:"BOOKA-2011",Price:"2",BookName:"BOOKA"},{BookDate:"BOOKA-2012",Price:"3",BookName:"BOOKA"},{BookDate:"BOOKA-2013",Price:"4",BookName:"BOOKA"},{BookDate:"BOOKA-2014",Price:"5",BookName:"BOOKA"},{BookDate:"BOOKB-2010",Price:"6",BookName:"BOOKB"},{BookDate:"BOOKB-2011",Price:"7",BookName:"BOOKB"},{BookDate:"BOOKB-2012",Price:"8",BookName:"BOOKB"},{BookDate:"BOOKB-2013",Price:"9",BookName:"BOOKB"},{BookDate:"BOOKB-2014",Price:"10",BookName:"BOOKB"}]
Query
db.collection.aggregate([{$group:{_id:"$BookName","PriceSum2010-2011":{$sum:{$cond:[{$regexMatch:{input:"$BookDate",regex:"201[0-1]"}},{"$toInt":"$Price"},0]}},"PriceSum2013-2014":{$sum:{$cond:[{$regexMatch:{input:"$BookDate",regex:"201[3-4]"}},{"$toInt":"$Price"},0]}},},}])