SQL

With the LIBRARY relational database schema used in week 1's homework, implement the following requests:

1. Find the number of copies of a given book that exists at a given branch
2. Find the name of the book with the largest number of copies on any branch (not the total across all branches)
3. List all the books that are out rented at the moment
4. List the books borrowed by a given person in the last month
5. List the books borrowed at the moment to customers living in a given city
6. Set the due date to the day after tomorrow, for a certain book borrowed from a specific branch by a particular customer

Notes:

- In the above requests, a given book will be specified by its title, a given branch is specified by its branch name and a customer (borrower) is specified by his/her name.

- You will need to find how to get the current date in Oracle and add or subtract days to/from it.

Submit the SQL statements as a text file (Notepad) following the document naming convention FirstnameLastnameHW2.txt. 

Grading: this homework is awarded 100 points (16 points for each of the first 5 requests and 20 points for the last).