Write SQL queries for the books database (discussed in Section 18.3) that perform each

Assignment #7

Write SQL queries for the books database (discussed in Section 18.3) that perform each of the

following tasks:

a) Select all authors from the Authors table with the columns in the order lastName,

firstName and authorID.

b) Select a specific author and list all books for that author. Include the title, year and ISBN number. Order the information alphabetically by title.

c) Add a new author to the Authors table.

d) Add a new title for an author (remember that the book must have an entry in the

AuthorISBN table).