Database Schema

You have a database with tables

users

books

books$\_$issued

The users table has the following columns:

integer column user$\_$id $($primary key$)$

text column name

text column email

integer column phone$\_$number

The books table has the following columns:

integer column book$\_$id $($primary key$)$

text column book$\_$name

The books$\_$issued table has the following columns:

integer column issue$\_$id $($primary key$)$

integer column book$\_$id references the book$\_$id column of the books table $($foreign key$)$

integer column user$\_$id references the user$\_$id column of the users table $($foreign key$)$

text column return$\_$status

date column date$\_$of$\_$issue

User Task

Your task is to return the list of issued book names along with the name of the user who has taken that book ordered by user id

Tacteacac