Write a query to output the apartments whose prices are greater than the average and are also not rented, sorted by the 'Price' | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 3

Write a query to output the apartments whose prices are greater than the average and are also not rented, sorted by the 'Price'

I'm finding it difficult to execute this task! Pls I need hint on this

sql
27th Apr 2021, 5:46 PM
Kebiru Idakwo
Kebiru Idakwo - avatar
1 Answer
0
So the secret is in subqueries. You will need to compare the price with the average of price.
28th Apr 2021, 6:08 PM
Kail Galestorm
Kail Galestorm - avatar

Often have questions like this?

Learn more efficiently, for free:

See all courses
Hot today
Python Question
3 Votes
How to learn fast C?
0 Votes
Initials of name
1 Votes
Hi everyone! I want change div with name "cd" to text(how to add url here)when I click button. No my code not worked. help me.
1 Votes
Hello, please help me understand how to solve
0 Votes
Why are the outputs appeared different?
1 Votes
How to synchronize android studio
0 Votes
Forever loop pls help
0 Votes
I want these three dots to jump inside that box..please help
1 Votes
Css In python
0 Votes