Boarding Week 2 Practical Workouts- Mongodb

Sample document:

{
  "_id": "6551bd811f1795355ba843ed",
  "index": 14,
  "name": "Wendy Sampson",
  "isActive": true,
  "registered": {
    "$date": "2017-03-28T04:46:20.000Z"
  },
  "age": 18,
  "gender": "female",
  "eyeColor": "blue",
  "favoriteFruit": "strawberry",
  "company": {
    "title": "BUGSALL",
    "email": "[email protected]",
    "phone": "+1 (822) 433-3614",
    "location": {
      "country": "France",
      "address": "864 Times Placez"
    }
  },
  "tags": [
    "non",
    "sunt",
    "officia"
  ]
}


db.people.updateMany({},{ $inc:{ age: -2 }})

db.people.aggregate([ {$group: {  _id: '$eyeColor', count: { $sum: 1 }      }}       ]  )


Sample document - ordersl collection:
{
  "_id": "64b59a5e2c8e7e9c5b8b4567",
  "orderNumber": "A123",
  "customerId": {
    "$oid": "64b59a5e2c8e7e9c5b8b4568"
  },
  "orderDate": {
    "$date": "2024-08-20T14:00:00.000Z"
  },
  "totalAmount": 1500
}

Sample document - customers collection:
{
  "_id": 64b59a5e2c8e7e9c5b8b4569",
  "name": "Bob Smith",
  "email": "[email protected]",
  "phone": "+0987654321"
}


db.ordersl.aggregate([{$lookup:{ from: 'customers' , localField: 'customerId', foreignField: '_id', as: 'CustomerData'    }}])