How would you type this out in in SQL?

Question

id,city,address,price,status
2,Marlboro,985 Huntz Lane,800,Not rented
6,Great Neck,1927 Romines Mill Road,900,Not rented
1,Las Vegas,732 Hall Street,1000,Not rented

Answer 1

Please show us your attempt so that we can edit and correct your mistakes

Answer 2

Please be more clear. What do you want to do with the data?

Answer 3

Select * from Apartments where price>700 and status='Not rented' order by price