0

sql apartments

SELECT * FROM apartments WHERE price > (SELECT AVG (price) FROM apartments ) ORDER BY price ASC; this doesnt work, pls help me, 5/1/2021

3rd May 2021, 4:55 AM
Mark Joseph Guevarra
Mark Joseph Guevarra - avatar
3 odpowiedzi
+ 1
Try this SELECT * FROM Apartments WHERE price > 700 ORDER BY price LIMIT 3;
3rd May 2021, 1:33 PM
Antonette Laiza Pagal
Antonette Laiza Pagal - avatar
0
really app the problem?
3rd May 2021, 7:41 AM
Muhammad Helmi
Muhammad Helmi - avatar
0
Antonette Laiza Pagal i use this code and this code run perfectly and change price > 700 with avg function that's already work there is some mistake whenever i use of status='not rented' but thank you for your help 👍
31st May 2021, 5:52 PM
Dhaval R Rana
Dhaval R Rana - avatar