SQL Apartments

Question

Hello,

I tried this query:
https://pastebin.com/1AjhN55R

The output is:
id,city,address,price,status

Where is my mistake?

Answer 1

Here is my code
You can try it.
It surely help you.

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

Answer 2

Anis Ali Khan

Problem is with SQL Compiler not your script.

https://www.sololearn.com/post/935054/?ref=app

Answer 3

My code

SELECT * FROM Apartments
WHERE price > (SELECT AVG(price) FROM Apartments
AND status != ‘Rented’
ORDER BY price;

Answer 4

Happy coding

Answer 5

Most welcome 👍

Answer 6

❤️😍Prerana😍❤️ It tells you to also account for status being "Not Rented". I know it turns out that you don't need to include it but if I had to what would it look like?

Answer 7

thank you. I also had to delete the second subcondition.

Answer 8

Most welcome 👍

Answer 9

Thank you Sathe Prerana Satish