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

Return the name, rate, check in and check out date for the room with the highest rate.
SELECT T2.roomname, T1.rate, T1.checkin, T1.checkout FROM reservations AS T1 JOIN rooms AS T2 ON T1.room = T2.roomid GROUP BY T1.room ORDER BY T1.rate DESC LIMIT 1
SELECT "T2"."roomname", "T1"."rate", "T1"."checkin", "T1"."checkout" FROM "reservations" "T1" JOIN "rooms" "T2" ON "T1"."room" = "T2"."roomid" GROUP BY "T1"."room" ORDER BY "T1"."rate" DESC FETCH FIRST 1 ROWS ONLY