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

Question

I'm finding it difficult to execute this task! Pls I need hint on this

Answer 1

So the secret is in subqueries. You will need to compare the price with the average of price.