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)

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" AS "T1" JOIN "rooms" AS "T2" ON "T1"."room" = "T2"."roomid" GROUP BY "T1"."room" ORDER BY "T1"."rate" DESC NULLS LAST LIMIT 1