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;