I need SQL query for these problems.

Thank you for your help.

1. Average time that a book is checked out and round by one decimal & maximum time a book has been checked out.

2. Displaying all books that are currently checked out

3. Display all books that are OVERDUE (Include Book Title, Patron L name, due date, and days overdue

4. Display of authors that have written more than 2 books. (Include first name, last name, # of books written)

CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book Num FK2 Pat _ID Check Out Date Check Due Date Check_ In_Date Pat FName Pat LName Pat_Type BOOK AUTHOR PK Book Num PK Au ID Book Title Book Year Book Cost Book Subject Au FName Au LName Au BirthYear FK1 Pat ID WRITES PK,FK1 Book Num PK,FK2 Au ID