SQL APARTMENT'S

Question

@sololearn I have been working on this project and it's not working. My code is correct:
SELECT * FROM Apartments
WHERE price > ( SELECT AVG (price) FROM Apartments)
AND status = 'Not rented'
ORDER BY price;

I saw a discussion on updating my sololearn but it's still not working.

Answer 1

Thank you