Find the room with the highest rate.
select * from reservations group by room order by rate desc limit 1;
What are the name, rate, check in and check out date of this room?
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;