Assignment #7

Assignment #7

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

Powered by