Book(bookID, ISBN, title, author, publish-year, category) Member(memberID, lastname, firstname, address, phone-number, limit) CurrentLoan(memberID, bookID, loan-date, due-date) History(memberID, bookID, loan-date, return-date)

Write SQL queries for the questions below (1) Find the name of the author(s) that has the largest number of different books owned by the library (multiple copies of the same book only count as one book).

(2) For each member (using both member ID, last name, and first name), list the number of books he/she has currently checked out, and the number of books he/she checked out in the past. If a person checked out the same book multiple times, it will be counted multiple times. Zero count should also be listed as 0.

* No views should be created for any SQL query.