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!
5 Respuestas
+ 11
Alia Mutia Mayanda
Try this:
SELECT * FROM Apartments
WHERE price>=(SELECT AVG(price)FROM Apartments)
ORDER BY price;
+ 5
https://www.sololearn.com/Discuss/2699006/?ref=app
See this
May be this will help you
+ 1
SELECT * FROM Apartments
WHERE price>=(SELECT AVG(price)FROM Apartments)
ORDER BY price;
0
Try this one
SELECT * FROM Apartments
WHERE price>=(SELECT AVG(price)FROM Apartments)
ORDER BY price;
0
answer is,
"SELECT * FROM Apartments
WHERE price>=(SELECT AVG(price)FROM Apartments)
ORDER BY price;"
try this