Question: Task 6 : List the office number and address for every property with three bedrooms. Task 7 : List the property for every property with

Task 6: List the office number and address for every property with three bedrooms.
Task 7: List the property for every property with two bedrooms that is managed by the StayWell-Georgetown office.
Task 8: List the property ID for every property with a monthly rent that is between $1,350 and $1,750.
Task 9: List the property ID for every property managed by the StayWell-Columbia City office whose monthly rent is less than $1,500
Task 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.
 Task 6: List the office number and address for every property

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!