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.
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)