Issued Books and Borrowers

Problem Statement

Problem Description Write a SQL query to retrieve a list of issued book names along with the names of the users who borrowed them. Schema users Table user_id (INTEGER) - Primary Key name (TEXT) - The name of the user email (TEXT) - The email address of the user phone_number (VARCHAR(20)) - The user's phone number books Table book_id (INTEGER) - Primary Key book_name (TEXT) - The name of the book books_issued Table issue_id (INTEGER) - Primary Key book_id (INTEGER) - Foreign Key referencing books.book_id user_id (INTEGER) - Foreign Key referencing users.user_id return_status (TEXT) - The current status of the issued book (e.g., 'Issued', 'Returned') date_of_issue (DATE) - The date the book was borrowed Required Output Your query should return a result set with exactly two columns in the following order: book_name name (the user's name) The final results must be ordered primarily by user_id in ascending order, and secondarily by issue_id in ascending order. Constraints or Notes All insta