Database: inn_1
Question: What are the names and decor of rooms with a king bed? Sort them by their price
SQL:
SELECT roomName ,  decor FROM Rooms WHERE bedtype  =  'King' ORDER BY basePrice;