SLECT* FROM apartments WHERE price(SELECT AVG(price) FROM apartment) AND status="not rented" 👈I'm wrong. Someone correct this | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

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

SQL number 2 project

19th Jun 2021, 8:05 AM
Piyumi Nadeesha Weerarathna
Piyumi Nadeesha Weerarathna - avatar
4 Answers
0
Hi
11th Nov 2021, 11:07 AM
Asraul Sk
Asraul Sk - avatar
+ 1
19th Jun 2021, 8:26 AM
Piyumi Nadeesha Weerarathna
Piyumi Nadeesha Weerarathna - avatar
0
Hi
11th Nov 2021, 11:07 AM
Asraul Sk
Asraul Sk - avatar
0
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
4th Apr 2022, 12:58 AM
JJ K