Write sql queries for the books database


Write SQL queries for the books database (discussed in Section 22.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

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Write sql queries for the books database
Reference No:- TGS0117777

Expected delivery within 24 Hours