No output [Solved]

Question

I tried writing the sql Apartment code but it gives me no output,where could I be wrong.
Here is my code:
select from apartments
where price >= (select avg(price ) from apartments)
and status = 'not rented'

Answer 1

1) you don't primarly select anything
2) price must be greater than avg (not greater or equal)
3) status value must be capitalized
4) result must be sorted by price

Answer 2

Thank you, Brian "Bill"

Answer 3

Ok, I'll rectify it visph

Answer 4

Almost done. I see two issues:
1. Missing the fields between select and from.
2. The text for status comparison needs to have correct capitalization.