db.Borrowing.aggregate([
    {
        $lookup: {
            from: "Member",
            localField: "memberID",
            foreignField: "memberID",
            as: "memberDetails"
        }
    },
    {
        $unwind: "$memberDetails"
    },
    {
        $lookup: {
            from: "Book",
            localField: "ISBN",
            foreignField: "ISBN",
            as: "bookDetails"
        }
    },
    {
        $unwind: "$bookDetails"
    },
    {
        $project: {
            _id: 0,
            MemberID: "$memberID",
            FirstName: "$memberDetails.firstName",
            LastName: "$memberDetails.lastName",
            BookTitle: "$bookDetails.title",
            BorrowedDate: "$borrowedDate",
            DueDate: "$dueDate",
            ReturnDate: "$returnDate",
            FineAmount: "$fineAmount"
        }
    },
    {
        $sort: { MemberID: 1 }
    }
]);