Description
This assignment explores aggregate functions. Those are functions that operate on more than one row at a time.
To Do
Provide the SQL to get the answer for each of the following. Also give me the answer to the question unless I specify otherwise.
1. How many rents have been paid by lease 10106202?
2. What is the total of all the rents paid?
3. What is the average payment amount in Rent History?
4. What is the distinct average lease montly rent
5. What is the maximum lease monthly rent?
6. What is the minumum lease montly rent?
7. What is the total rent amount paid for each lease?
8. What is the total rent amount paid for each month. (Don't forget your last assignment)
9. Get the same information, but only for those months with a total greater than $9000.
10. What is the total rent paid on each date where the total rent paid is greater than 10,000?
To turn in
Turn in the code