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

Which room has cheapest base price? List the room's name and the base price.
SELECT roomname, baseprice FROM rooms ORDER BY baseprice LIMIT 1
SELECT "roomname", "baseprice" FROM "rooms" ORDER BY "baseprice" FETCH FIRST 1 ROWS ONLY