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.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

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
Transcribed Image Text: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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

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.

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education