- 1
SQL APARTMENTS
How make question with apartments?
4 Réponses
+ 3
My code
SELECT * FROM Apartments
WHERE price > (SELECT AVG(price) FROM Apartments
AND status != ‘Rented’
ORDER BY price;
+ 2
You mean houses that sql lives in?
0
Copy this and like check thank you
- 1
SELECT * FROM Apartments
WHERE price>=(SELECT AVG(price)FROM Apartments)
ORDER BY price;