- 5

How would you type this out in in SQL?

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

10th Mar 2021, 4:48 AM
Ben O Factor
Ben O Factor - avatar
3 Réponses
0
Please show us your attempt so that we can edit and correct your mistakes
10th Mar 2021, 5:21 AM
Sharique Khan
Sharique Khan - avatar
0
Please be more clear. What do you want to do with the data?
10th Mar 2021, 5:24 AM
Abir Hasan
Abir Hasan - avatar
0
Select * from Apartments where price>700 and status='Not rented' order by price
5th Dec 2021, 1:25 PM
Dipali Patil