Course: Database Management System (DBMS) Please write/provide correct sql queries in solution.

Consider the tables; Library User (first name, last name, card number) and Library Book (title, author, bookID, card number). Page 4 of 6 Card number is the unique library card number for a user and is used in the LibraryBook table to tell who has checked out that book. If a book is not checked out, this value is NULL. Write a query that selects all the user last names, card numbers and titles of books they have checked out, include a user even if they have no books checked out. Users with more than one book checked out will have a record returned for each book. HINT: Can be solved by using left outer join