3. [CO5] Consider the following relational database schema for a library management system. Rorrower BookLoan [Foreign Key: copyNo references Book (copyNo) and borrowerNo references Borrower (borrowerNo)] The primary keys are underlined and foreign keys are mentioned in bold under each table that has any foreign keys. Write appropriate SQL statements for the following questions (for each question write a single query): a. Retrieve all the Book title, ISBN, edition and year sorted by descending order of year. If the book is published in the same year, then sort based on the title alphabetically. b. Retrieve the number of books that have been published each year if more than 1 book was published in that year. Print the year and the number of books. c. List all the book titles starting with letter 'T', whose price is more than all the books published in 2014. d. Calculate the total price of the books borrowed by borrower 'John