CREATE TABLE Rooms (roomName VARCHAR2, decor VARCHAR2, bedtype VARCHAR2, basePrice VARCHAR2)

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