Answered You can hire a professional tutor to get the answer.
Using the SQL script below, how can I do the following?
Using the SQL script below, how can I do the following?
a. Modify the database to reflect that two new properties (property # 7 and 8) were added by the
renting company and two new renters (renter # 5 and 6) rented these new properties from Nov 1, 2010
[You can make up property and renter details]
b. Show property number, property rent, and renters' name for all the properties that were rented in
any part of year 2010.
c. Show rental history (renter number, renter name, and rent start date, end date) of the properties
that are currently in rent.
Drop