Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of bedrooms, the second is the average square feet, and the third is the average monthly rent for all properties in the PROPERTY table that have that number of bedrooms. Use BEDROOMS, AVG_SQUARE_FEET, and AVG_MONTHLY_RENT as the column names. Group and order the rows by number of bedrooms.

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
icon
Concept explainers
Question
100%

Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of bedrooms, the second is the average square feet, and the third is the average monthly rent for all properties in the PROPERTY table that have that number of bedrooms. Use BEDROOMSAVG_SQUARE_FEET, and AVG_MONTHLY_RENT as the column names. Group and order the rows by number of bedrooms.

2
 
PROPERTY ID
OFFICE_NUM
SQR FT
BDRMS
FLOORS
ADDRESS
MONTHLY_RENT
OWNER_NUM
30 West Thomas Rd.
1600
1400
BU106
1
782 Queen Ln.
2100
4
2
1900
AK102
9800 Sunbeam Ave.
1005
2
1200
B1109
1.
105 North Illinois Rd.
1750
3
1650
ко104
1
887 Vine Rd.
1125
2
1160
S1105
8 Laurel Dr.
2125
2050
MO100
4
447 Goldfield St.
1675
3.
2
1700
co103
2.
594 Leatherwood Dr.
2700
5
2
2750
KO104
9.
2
504 Windsor Ave.
700
1050
PA101
10
2.
891 Alton Dr.
1300
3
1600
LO108
11
2
9531 Sherwood Rd.
1075
1100
J0110
12
2
2 Bow Ridge Ave.
1400
3
2
1700
RE107
2.
2)
2.
3.
Transcribed Image Text:PROPERTY ID OFFICE_NUM SQR FT BDRMS FLOORS ADDRESS MONTHLY_RENT OWNER_NUM 30 West Thomas Rd. 1600 1400 BU106 1 782 Queen Ln. 2100 4 2 1900 AK102 9800 Sunbeam Ave. 1005 2 1200 B1109 1. 105 North Illinois Rd. 1750 3 1650 ко104 1 887 Vine Rd. 1125 2 1160 S1105 8 Laurel Dr. 2125 2050 MO100 4 447 Goldfield St. 1675 3. 2 1700 co103 2. 594 Leatherwood Dr. 2700 5 2 2750 KO104 9. 2 504 Windsor Ave. 700 1050 PA101 10 2. 891 Alton Dr. 1300 3 1600 LO108 11 2 9531 Sherwood Rd. 1075 1100 J0110 12 2 2 Bow Ridge Ave. 1400 3 2 1700 RE107 2. 2) 2. 3.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
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
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