Did anybody solve the "Apartmebts" code project in SQL course?!

Question

It gives me.back some.mistakes. i think i need your help :)

Answer 1

Thats because you cannot compare the value in a cell to that of an arbitrary value unless it is equal. For the price, for have to say:
WHERE price>(SELECT AVG(price) from Apartments)

That should work

Answer 2

select * from Apartments where price > AVG(price) and status = 'Not rented' order by price;

Answer 3

SELECT *
FROM Apartments
WHERE price >
(SELECT AVG(price) FROM Apartments)
ORDER BY price;

Answer 4

Please show your attempt. I have done it fine

Answer 5

select * from Apartments where price > AVG(price) and status = 'Not rented' order by price;

Answer 6

It worked mate. Thank you very much for clearance of it.

Answer 7

No problem

Answer 8

Also, slight rewording of the reason, it’s because the average is not a set value, its dependant on the table, and so a custom column have to be created for comparison

Answer 9

Hm i see. Thanks a lot friend. Thats lots of help

Answer 10

:D