db.borrowings.aggregate([
{
    $lookup: {
        from: "members",
        localField: "member_id",
        foreignField: "member_id",
        as: "member_details"
    }
},
{
    $lookup: {
        from: "books",
        localField: "ISBN",
        foreignField: "ISBN",
        as: "book_details"
    }
},
{
    $project: {
        _id: 0,
        member_id: 1,
        first_name: { $arrayElemAt: ["$member_details.first_name", 0] },
        last_name: { $arrayElemAt: ["$member_details.last_name", 0] },
        book_title: { $arrayElemAt: ["$book_details.title", 0] },
        date_borrowed: 1,
        due_date: 1,
        return_date: 1,
        fine_amount: 1
    }
}
])