SQL challenge question: anybody to help ?

Question

I need help on this challenge

The question goes like this

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

Answer 1

Here is a code you can use :
SELECT apartments from Apartments_table WHERE (price > AVG(price) AND status = "not rented") ORDER BY price ;