CREATE TABLE rooms (roomid TEXT, roomname TEXT, beds DECIMAL, bedtype TEXT, maxoccupancy DECIMAL, baseprice DECIMAL, decor TEXT)
CREATE TABLE reservations (code DECIMAL, room TEXT, checkin TEXT, checkout TEXT, rate DECIMAL, lastname TEXT, firstname TEXT, adults DECIMAL, kids DECIMAL)

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" NULLS FIRST