How to i make an average in WHERE

Question

SELECT *
FROM Apartments
WHERE price > 750 AND status = 'Not rented'
Order By price ASC

Answer 1

Perhaps the AVG() function helps

SELECT AVG(price)
FROM Apartments
WHERE price > 750
AND status = 'Not rented'

I'm not really sure what kind of result you wanted, but this only calculates the average of the price, it'll only return a row

Answer 2

This appears to be a challenge. If you need help, please share the challenge and your attempt