0

Apartments Project on SQL

Hi, did you guys know about the Apartments project on SQL on section 2 (filtering, functions, and subqueries)? I've written my code properly and I think it's correct but why my output of the program just "Id, city, address, price, status" ? please anyone could you tell me why my code doesn't give the output as the expected output? Thank you!

31st Mar 2021, 7:36 AM
Alia Mutia Mayanda
Alia Mutia Mayanda - avatar
5 Respuestas
+ 11
Alia Mutia Mayanda Try this: SELECT * FROM Apartments WHERE price>=(SELECT AVG(price)FROM Apartments) ORDER BY price;
1st Apr 2021, 9:52 PM
❤️😍Prerana😍❤️
❤️😍Prerana😍❤️ - avatar
+ 5
https://www.sololearn.com/Discuss/2699006/?ref=app See this May be this will help you
31st Mar 2021, 7:56 AM
Kǟrɨsɦmǟ ❥
Kǟrɨsɦmǟ ❥ - avatar
+ 1
SELECT * FROM Apartments WHERE price>=(SELECT AVG(price)FROM Apartments) ORDER BY price;
2nd Apr 2021, 5:04 AM
Joao Paulo Paiva
Joao Paulo Paiva - avatar
0
Try this one SELECT * FROM Apartments WHERE price>=(SELECT AVG(price)FROM Apartments) ORDER BY price;
28th Jun 2021, 6:36 AM
AMRJEET KUMAR
AMRJEET KUMAR - avatar
0
answer is, "SELECT * FROM Apartments WHERE price>=(SELECT AVG(price)FROM Apartments) ORDER BY price;" try this
1st Feb 2022, 6:25 AM
Bhashitha Kaveesh