Database: inn_1
Question: List the names and decor of rooms that have a king bed. Sort the list by their price.
SQL:
SELECT roomName ,  decor FROM Rooms WHERE bedtype  =  'King' ORDER BY basePrice;