WRITE A QUERY TO OUTPUT THE APARTMENTS WHOSE PRICES ARE GREATER THAN THE AVERAGE AND ARE ALSO NOT RENTED ,SORTED BY PRICE COLUMN 

WRITE A QUERY TO OUTPUT THE APARTMENTS WHOSE PRICES ARE GREATER THAN THE AVERAGE AND ARE ALSO NOT RENTED ,SORTED BY PRICE COLUMN 

Select * from apartments
Where price > ( select avg(price) from apartments )
And status =‘Not rented’
Order by price