(Turn in word document, including SQL commands and Screen shots from mySQL)
Write SQL queries for the books database that perform each ofthe 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
Some suggestions on installing Apache and setting up database file in mySQL are attached.