Project 2
Ans 2
AND Ans3
db.order.aggregate([
{ "$match": { "0rd_date": { "$exists": true } } },
{
"$redact": {
"$cond": [
{ "$eq": [{ "$month": "$currentDate" }, 9] },
"$$KEEP",
"$$PRUNE"
]
}
}
])
Sorry i dont have date in customer ?? seem que differce according to table i create