Structured Query Language A vehicle rental company has a database that includes the following tables and attributes within those tables:

Customer Table Customer number (PK); customer name, customer address, customer phone number, customer credit card number Inventory Table Inventory number (PK); item description;

item cost; item rental price; number of days for which an item can be rented Rental Form Table Rental Form number (PK); rental date;

customer number (FK)

Rental Line Item Table Rental Form number (PK); inventory number (PK); due date Required:

Using the SQL commands given in this chapter, write the code that would be necessary to generate a report of each customer with rented items that are past due. Customers can rent more than one item at a time, and items may have different rental periods, so this report should only include overdue items.

(You may use the word today to signify the current date.)