Which room has the highest rate? List the room's full name, rate, check in and check out date.
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;