Issued Books and Borrowers

Problem Statement

Issued Books and Borrowers A library database has three tables: users , books and books_issued . Every row of books_issued records one occasion on which a user borrowed a book. Write an SQL query that returns the list of issued book names along with the name of the user who took each book, ordered by user_id . Table: users Column Data Type Description user_id INT Primary key name TEXT Name of the user email TEXT Email address of the user phone_number INT Phone number of the user Table: books Column Data Type Description book_id INT Primary key book_name TEXT Name of the book Table: books_issued Column Data Type Description issue_id INT Primary key book_id INT References books.book_id user_id INT References users.user_id return_status TEXT 'Issued' or 'Returned' date_of_issue DATE Date the book was issued, as text YYYY-MM-DD Expected Output Return the following columns, in this order: Column Description book_name Name of the issued book name Name of the user who took it Rules Every row