Use the SQL Workbench. Module 4 StayWell Student Accommodation.

2. List the complete PROPERTY table (all rows and all columns)

4. List the last name and first name of every owner who does not live in Seattle.

6. List the office number and address for every property with three bedrooms.

8. List the property ID for every property with a monthly rent that is between $1,350 and $1,750.

10. Labor is billed at the rate of $35 per hour. List the property ID, category number, estimated hours, and estimated labor cost for every service request. To obtain the estimated labor cost, multiply the estimated hours by 35. Use the column name ESTIMATED_COST for the estimated labor cost.

12. List the office number, property ID, square footage, and monthly rent for all properties. Sort the results by monthly rent within the square footage.

14. Calculate the total value of monthly rents for all properties.