Write a query to display the author last name, first name, book title, and replacement cost for each book. Sort the results by book number and then author ID (Figure P7.92). (25 rows)

Transcribed Image Text:

Figure P7.92 Author Name and Book Title AU_LNAME AU_FNAME Reba Durante Walsh Neal Reeves Benson Palca Julia Salvadore Carmine Paulsen Connie Sheel Lawrence Rachel Connie Rachel Aggerwal Manish Beatney Paulsen McGill BOOK TITLE Beginner's Guide to JAVA Database in the Cloud Mastering the database environment Conceptual Programming J++ in Mobile Apps J++ in Mobile Apps J++ in Mobile Apps iOS Programming JAVA First Steps JAVA First Steps C# in Middleware Deployment BOOK_COST 59.95 79.95 89.95 59.95 49.95 49.95 49.95 79.95 49.95 49.95 59.95