Write a query to display the author last name, author first name, and book number for each book written by that author. Sort the results by author last name, first name, and then book number (Figure P7.90).

Transcribed Image Text:

Figure P7.90 Books Written by Author AU_LNAME AU_FNAME BOOK NUM Aggerwal Manish 5242 Beatney Rachel 5240 Bruer 5243 Bruer 5246 Chiang 5244 Chiang 5249 Chiang 5252 Durante 5235 Hugo Hugo Xia Xia Xia Reba