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

Question

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

Expected Output
id,city,address,price,status
2,Marlboro,985 Huntz Lane,800,Not rented
6,Great Neck,1927 Romines Mill Road,900,Not rented
1,Las Vegas,732 Hall Street,1000,Not rented

(id, name, adddress, price, status)
(1, 'las vegas', '732 hall street',1000, 'not rented'),
(2, 'marlboro', '985 hantz lane', 800, 'not rented'),
(3, 'moretown', '3757 wines lane', 700, 'not rented'),
(4, 'owatonna', '314 pritchard court', 500, 'rented'),
(5, 'grayslake', '3234 cunningham court', 600, 'rented'),
(6, 'great neck', '1927 romines mill road', 900, 'not rented')

Answer 1

https://www.sololearn.com/compiler-playground/cYsGY4y3pD71

Answer 2

https://code.sololearn.com/w12o4Ot5cb8V/?ref=app

Answer 3

and not or