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

Question

You have to find out the apartments whose price are above the average price and are not rented using the AVG keyword.

Answer 1

SQL commands are easy, try to think that what you will say in easy words!