Task 7: List the square 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. Task 9: List the office number, address, and monthly rent for properties whose owners live in Washington State or own two-bedroom properties. Task 10: List the office number, address, and monthly rent for properties whose owners live in Washington State and own a two-bedroom property.
Task 7: List the square 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.
Task 9: List the office number, address, and monthly rent for properties whose owners live in Washington State or own two-bedroom properties.
Task 10: List the office number, address, and monthly rent for properties whose owners live in Washington State and own a two-bedroom property.
![PROPERTY_ID
OFFICE_NUM
ADDRESS
SQR_FT
BDRMS
FLOORS
MONTHLY_RENT
OWNER_NUM
1
1
30 West Thomas Rd.
1600
3
1
1400
BU106
2
1
782 Queen Ln.
2100
4
2
1900
AK102
3
1
9800 Sunbeam Ave.
1005
2
1
1200
BI109
4
1
105 North Illinois Rd.
1750
3
1
1650
кО104
5
1
887 Vine Rd.
1125
2
1
1160
S1105
6
1
8 Laurel Dr.
2125
4
2
2050
MO100
7
2
447 Goldfield St.
1675
3
2
1700
Co103
8
2
594 Leatherwood Dr.
2700
2
2750
ко104
2
504 Windsor Ave.
700
2
1050
PA101
10
891 Alton Dr.
1300
3
1
1600
LO108
11
9531 Sherwood Rd.
1075
2
1
1100
J0110
12
2
2 Bow Ridge Ave.
1400
3
2
1700
RE107](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F41e4660d-a2b3-452c-b840-6ca128ad9286%2Fa445334b-1df9-4ad2-80c5-90fa2bb11da4%2Fbvozmu_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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 have four bedrooms.
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)