Task 7: 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.

ru) 1 out of 1 checks passed. Great work! 1 CREATE VIEW MONTHLY_RENTS AS SELECT AVG(BDRMS) AS BEDROOMS, 2 AVG(SQR_FT) AS AVG_SQUARE_FEET, AVG(MONTHLY_RENT) AS AVG_MONTHLY_RENT Checks 3 FROM PROPERTY GROUP BY BDRMS ORDER BY BDRMS ; SQL Database Test complete Complete task 5 Task 6: Repeat Task 5 without using the PROPERTY_OMNERS > Task 7: 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. 1 out of 2 checks passed. Review the results below for more details. Checks SQL Database Test Complete > Query completed Complete task 7 - Create the MONTHLY_RENTS VIEW . SQL Database Test incomplete Complete task 7 - The MONTHLY_RENTS VIEW returns the correct data