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!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
+ 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 Réponse
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

Vous avez souvent des questions comme celle-ci ?

Apprenez de manière plus efficace, gratuitement :

Voir tous les cours
Aujourd'hui en vedette
Is the AI course worth the $49?
0 Votes
Can anyone please help with this below code for python files
1 Votes
How private are "private" code snippets in Sololearn really?
1 Votes
Should I always mention name attribute inside <input type="" id="" name="" > ??
0 Votes
Where to use
0 Votes
Coding path
0 Votes
Scroll to bottom of page in Selenium with browser minimized
0 Votes
Blank screen when trying to but AI course on Apple 15 I phone,
0 Votes
How to win bits
1 Votes
Question on code instructionn course. Update: anwsered
1 Votes