I am having problems finding the answers to this assignment ( Lab 5:2 StayWell Student Accommodation). Please explain how to solve (tasks 5-8) and the sql code needed to get the desired results. Task 5 - Repeat task four, but this time use the EXISTS operator in your query. Task 6 - List the property IDs of any pair of properties that have the same number of bedrooms. For example, one pair would be ID 2 and property ID 6, because they both have 4 bedrooms. The first property ID listed should be the major sort key and the second property ID should be the minor sort key. Task 7 - List the sq footage, owner number, owner last name and owner
I am having problems finding the answers to this assignment ( Lab 5:2 StayWell Student Accommodation). Please explain how to solve (tasks 5-8) and the sql code needed to get the desired results.
Task 5 - Repeat task four, but this time use the EXISTS operator in your query.
Task 6 - List the property IDs of any pair of properties that have the same number of bedrooms. For example, one pair would be ID 2 and property ID 6, because they both have 4 bedrooms. The first property ID listed should be the major sort key and the second property ID should be the minor sort key.
Task 7 - List the sq footage, owner number, owner last name and owner first name for each property managed by the StayWell-Columbia City Office.
Task 8 - Repeat task 7, but this time include only those properties with three bedrooms.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
