---
# System prepended metadata

title: Untitled

---

```
db.rooms.aggregate([
    {
       $lookup: {
           from: "reservations",
           localField: "_id",
           foreignField: "room_id",
           as: "reservation"
       }
     },
     {
       $match: {
            $and: [
                {"reservation.start_date": { $lte: ISODate("2023-01-05")}},
                {"reservation.end_date": { $lte: ISODate("2022-12-24") }},
            ],
       }
     },
     { "$project" : { "reservation" : 0, } }
 ])
```