- 1

SQL APARTMENTS

How make question with apartments?

27th Jan 2021, 6:21 PM
Bogdan
Bogdan - avatar
4 odpowiedzi
+ 3
My code SELECT * FROM Apartments WHERE price > (SELECT AVG(price) FROM Apartments AND status != ‘Rented’ ORDER BY price;
5th May 2021, 9:17 PM
Łukasz Śmietanka
Łukasz Śmietanka - avatar
+ 2
You mean houses that sql lives in?
27th Jan 2021, 9:37 PM
Sonic
Sonic - avatar
0
Copy this and like check thank you
14th Sep 2021, 7:53 AM
Brigido bergado jr
Brigido bergado jr - avatar
- 1
SELECT * FROM Apartments WHERE price>=(SELECT AVG(price)FROM Apartments) ORDER BY price;
14th Sep 2021, 7:53 AM
Brigido bergado jr
Brigido bergado jr - avatar