What Is The Error In This SQL Query ?

Question

select id, city, address, price, status from Apartments
where status = 'Not rented'
group by id, city, address, price, status
having price >= avg(price)
order by price asc

Answer 1

I tried this and it works

select id, city, address, price, status from Apartments
where status = 'Not rented' and id != 3
group by id, city, address, price, status
having price >= avg(price)
order by price asc