Database
db={expense:[{accountId:ObjectId("61f4f357624d000ad053d745"),currency:"1",expenseType:"1",amount:"20000",itemname:"salary",date:ISODate("2022-02-01")}],account:[{_id:ObjectId("61f4f357624d000ad053d745"),accountName:"BOI"}]}
Query
db.expense.aggregate([{$match:{$and:[{currency:"1",expenseType:"1"},{date:{$gte:new Date("2022-02-01"),$lte:new Date("2022-02-10")},},{$expr:{$and:[{$gt:[{"$toDecimal":"$amount"},1]},{$lt:[{"$toDecimal":"$amount"},100000]}]}}]}},{$lookup:{from:"accounts",localField:"accountId",foreignField:"_id",as:"account"}}])