Write a query to display the patron ID, book number, patron first name and last name, and

Question:

Write a query to display the patron ID, book number, patron first name and last name, and book title for all currently checked out books. (Remember to use the redundant relationship described in the assignment instructions for current checkouts.) Sort the output by patron last name and book title (Figure P7.93).

Figure P7.93 Currently Checked Out Books PAT_ID BOOK_NUM PAT_FNAME 1229 1229 1228 1212 1172 1207 5252 Gerald