Question: 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

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).

Figure P7.90 Books Written by Author AU_LNAME AU_FNAME BOOK NUM Aggerwal Manish 5242 Beatney Rachel 5240

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

Step by Step Solution

3.49 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Here is an SQL query to display the author last name author first name and book ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Database Systems Design Implementation Questions!