Use SQL Workbench. Module 5 StayWell Student Accommodation

6. List the property IDs of any pair of properties that have the same number of bedrooms. For example, one pair would be property ID 2 and property ID 6, because they both have four bedrooms. The first property ID listed should be the major sort key and the second property Id should be the minor sort key.

8. List the square footage, owner number, owner last name, and owner first name for each three-bedroom property managed by the Columbia City office.

10. List the office number, address, and monthly rent for properties whose owners live in Washington state and own a two-bedroom property.

12. Find the service ID and property ID for each service request whose estimated hours are greater than the number of estimated hours of at least one service request on which the category number is 5.

14. List the address, square footage, owner number, service ID, number of estimated hours, and number of spent hours for each service request on which the category number is 4.

15. Repeat Exercise 14, but this time be sure each property is included regardless of whether the property currently has any service requests for category 4.

16. Repeat Exercise 15 using a different SQL command to obtain the same result. What is the difference between the two commands?