db.member.aggregate([
  {
    $lookup: {
      from: "borrowedbooks",
      localField: "memberID",
      foreignField: "memberID",
      as: "borrowed"
    }
  },
  { $unwind: "$borrowed" },
  {
    $lookup: {
      from: "book",
      localField: "borrowed.ISBN",
      foreignField: "ISBN",
      as: "bookInfo"
    }
  },
  { $unwind: "$bookInfo" },
  {
    $project: {
      _id: 0,
      memberID: 1,
      firstName: 1,
      lastName: 1,
      bookTitle: "$bookInfo.title",
      dateBorrowed: "$borrowed.dateBorrowed",
      dueDate: "$borrowed.dueDate",
      returnDate: "$borrowed.returnDate",
      fineAmount: "$borrowed.fineAmount"
    }
  }
]);