sql apartments

Question

SELECT * FROM apartments
WHERE price > (SELECT AVG (price) FROM apartments )
ORDER BY price ASC;

this doesnt work, pls help me, 5/1/2021

Answer 1

Try this
SELECT * FROM Apartments
WHERE price > 700
ORDER BY price
LIMIT 3;

Answer 2

really app the problem?

Answer 3

Antonette Laiza Pagal i use this code and this code run perfectly and change price > 700 with avg function that's already work there is some mistake whenever i use of
status='not rented' but thank you for your help 👍