My SQL practice 18

Question

Please help me to solve this solution in SQL
Last i tried:

SELECT* From Apartments;
SELECT AVG(price) FROM Apartments WHERE Price > 800;

Answer 1

SELECT* FROM Apartments ( FROM upper case letters) and I remember : status = 'Not rented' should be used.

Answer 2

Thanks