Considering the books database (as shown in figure) Get a list of all the authors grouped by title, sorted by title; for a given title sort the author names alphabetically by last name then first name. Get a list of all the titles and the authors who wrote them. Sort the results by title.

1 Authors AuthorID FirstName LastName Author ISBN AuthorID ISBN Titles ISBN Title EditionNumber Copyright