Write a query to output the apartments whose prices are greater than the average and are also not rented, sorted by the 'Price' column.
Loading
3 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
- SELECT * from Tbl_Apartments
- SELECT City, address, Price from Tbl_Apartments
- WHERE Price > (SELECT AVG(Price) from Tbl_Apartments)
- AND Status like 'Not Rented'
- ORDER BY Price
Rajanikant HawaldarPosted Sep 12, 2021, 4:47 PM