Book Borrowing History

Write a SQL query to show book titles with borrower names.

Expected Columns

• book_title
• borrower_name
• borrow_date
• status

Example Output

| book_title | borrower_name | borrow_date | status | |------------|---------------|-------------|--------| | The Guide | Ashok Banerjee | 2024-01-05 | Returned | | Wings of Fire | Vidya Lakshmi | 2024-01-08 | Returned | | ... | ... | ... | ... |