Description
This assignment introduces one table selects
To Do
Write an SQL statement for each question that would return the requested rows.
1. What is the first name, last name and phone number of each tenant?
2. List all the lease records.
3. Sort the lease records by the rent amount.
4. List only the rent amounts, one of each, sorted highest to lowest.
5. List all the rents paid by lease number 20106204
6. List all the apartments with a view.
7. What apartments have a rent higher than 1150?
8. Who are all the tenants whose last name begins with "S"?
9. Who are all the tenants whose last name begins with "M" or "T"?
10. List all the tenants who have the letters "ar" somewhere in their Last Name
11. List all the rents that were paid between 3/1/2006 and 3/15/2006
12. Which maintenance tasks don't have a description?
13. Which maintenance requests have not been resolved?
14. Which ones have?
15. Which leases have a rent greater that 1450 or less than 1000?
16. Which leases are for the second floor? (use in)
To turn in
Turn in the SQL for each question