Apartments Project on SQL

Question

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!

Answer 1

Alia Mutia Mayanda
Try this:
SELECT * FROM Apartments
WHERE price>=(SELECT AVG(price)FROM Apartments)
ORDER BY price;

Answer 2

https://www.sololearn.com/Discuss/2699006/?ref=app

See this
May be this will help you

Answer 3

SELECT * FROM Apartments
WHERE price>=(SELECT AVG(price)FROM Apartments)
ORDER BY price;

Answer 4

Try this one

SELECT * FROM Apartments
WHERE price>=(SELECT AVG(price)FROM Apartments)
ORDER BY price;

Answer 5

answer is,
"SELECT * FROM Apartments
WHERE price>=(SELECT AVG(price)FROM Apartments)
ORDER BY price;"
try this