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

Question

G
https://www.sololearn.com/discuss/2768101/?ref=app

Answer 1

Hi Ashraf Ali Qhtan Hammam
This looks like an SQL problem.
I will help you out
SELECT * FROM Apartments
WHERE price > 750
AND status = 'Not rented'
ORDER BY price

Answer 2

SELECT * FROM Apartments
WHERE price > 750
AND status = 'Not rented'
ORDER BY price