Use SQL and the StayWell Student Accommodation database (see Figures 1−4 through 1−9 in Module 1) to complete the follow

[answerhappygod]

Use Sql And The Staywell Student Accommodation Database See Figures 1 4 Through 1 9 In Module 1 To Complete The Follow 1 (104.89 KiB) Viewed 36 times

Use SQL and the StayWell Student Accommodation database (see Figures 1−4 through 1−9 in Module 1) to complete the following exercises. If directed to do so by your instructor, use the information provided with the Module 3 Exercises to print your output or save it to a document. 1. For every property, list the management office number, address, monthly rent, owner number, owner's first name, and owner's last name. 2. For every completed or open service request, list the property ID, description, and status. 3. For every service request for furniture replacement, list the property ID, management office number, address, estimated hours, spent hours, owner number, and owner's last name. 4. List the first and last names of all owners who own a two-bedroom property. Use the IN operator in your query. 5. Repeat Exercise 4, but this time use the EXISTS operator in your query. 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. 7. List the square footage, owner number, owner last name, and owner first name for each property managed by the Columbia City office. 8. Repeat Exercise 7, but this time include only those properties with three bedrooms. 9. List the office number, address, and monthly rent for properties whose owners live in Washington state or own two-bedroom properties. 10. List the office number, address, and monthly rent for properties whose owners live in Washington state and own a two-bedroom property. 11. List the office number, address, and monthly rent for properties whose owners live in Washington state but do not own two-bedroom properties. 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