QUESTION 5 Consider the following relational schema for a book database, the primary keys are underlined. Author(AuthorID, AuthorName, Address, TelephoneNo, PublisherCode) Book (BookID, Name, ReleaseDate, Price, AuthorID) Publisher(PublisherID, Name, Address, AuthorID) Write SQL queries to answer the following: (a) Write queries to show all the book information of all Books in the Book table which includes the name Harry Potter. Sort Descending in Price. (5 marks) (b) Write a query to pick out and show all the details of Authors who released books last year. (6 marks) (c) Write a query to show the number of authors who have written a book. (5 marks) (d) Write a query that will illustrate books and their various Publishers. Group by PublisherID. (5 marks) (e) Write a query to delete the Telephone Number column from the Author table. (4 marks)