Write a query to display the book number, title, author last name, author first name, patron ID, last name, and patron type for all books currently checked out to a patron. Sort the results by book title (Figure P7.97).

Transcribed Image Text:

Figure P7.97 Currently Checked Out Books with Authors BOOK TITLE 5252 Beyond the Database Veil 5242 C# in Middleware Deployment 5246 Capture the Cloud 5238 Conceptual Programming 5240 iOS Programming 5249 Starlight Applications BOOK NUM AU LNAME AU_FNAME PAT_ID PAT_LNAME Chiang Aggerwal Bruer Palca Beatney Chiang Xia Manish Hugo Julia Rachel Xia 1229 Burke 1228 Goodman 1172 Miles 1229 Burke 1212 McClain 1207 Ramos PAT_TYPE Student Student STUDENT Student Student Student