Question: Write a query to display the author ID and first and last name of all authors whose year of birth is unknown. Sort the results

Write a query to display the author ID and first and last name of all authors whose year of birth is unknown. Sort the results by author ID (Figure P7.74). 

Figure P7.74 Authors with Unknown Birth Year AU_ID AU_FNAME 229 Carmine 262 Xia 559 Rachel AU_LNAME Salvadore

Figure P7.74 Authors with Unknown Birth Year AU_ID AU_FNAME 229 Carmine 262 Xia 559 Rachel AU_LNAME Salvadore Chiang McGill

Step by Step Solution

3.53 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To retrieve the author ID first name and last name of all authors whose year ... 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!