Write a query to output the apartments whose prices are greater than the average and are also not rented, sorted by the 'Price'

Question

Question

Answer 1

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

Answer 2

And your question is❓