(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
AuthorISBN table).
Some suggestions on installing Apache and setting up database file in mySQL are attached.