SQL APARTMENTS

Question

How make question with apartments?

Answer 1

My code

SELECT * FROM Apartments
WHERE price > (SELECT AVG(price) FROM Apartments
AND status != ‘Rented’
ORDER BY price;

Answer 2

You mean houses that sql lives in?

Answer 3

Copy this and like check thank you

Answer 4

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