Write sql queries for the books database discussed in


Assignment

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

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: Write sql queries for the books database discussed in
Reference No:- TGS01719142

Now Priced at $35 (50% Discount)

Recommended (90%)

Rated (4.3/5)