SLECT* FROM apartments WHERE price(SELECT AVG(price) FROM apartment) AND status="not rented" 👈I'm wrong. Someone correct this

Question

SQL number 2 project

Answer 1

Hi

Answer 2

Shehara Punchihewa Thanq dear

Answer 3

Hi

Answer 4

Yeah i dont know why the code runs okay without the status = “Not Rented” part, given that was one of the conditions of the question