List the names of anyone who has co-authored a book, along with the name of the co-author. Your list may contain two rows for two authors, e.g. Smith co-authored book XYZ with Jones, and Jones co-authored book XYZ with Smith. Order the list by the authors name. Do NOT include single-authored books. Could this be a time to use a self-join?

Example: "Harry Potter" was written by 3 co-authors: David, James, and Tom.

The report may look like this:

Title Author Co-Author

"Harry Potter" David James

"Harry Potter" David Tom

"Harry Potter" James David

"Harry Potter" James Tom

"Harry Potter" Tom David

"Harry Potter" Tom James

Thank you.

CUSTOMERS Customer Lastname Firstname Email Address City State Zip Referred Region ORDERS Order# Customer Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost ORDERITEMS Order# Item# ISBN Quantity Paideach BOOKAUTHOR AUTHOR BOOKS ISBN Authord ISBN AuthorID Lname Title Fname Pubdate PubID Cost Retail Discount PUBLISHER Category PublD Name PROMOTION Contact Phone Gift Minretall Maxretail FIGURE 1-5 JustLee Books's table structures after normalization