Which room has the highest rate? List the room's full name, rate, check in and check out date.
create table rooms (roomname varchar, roomid varchar, PRIMARY KEY (roomname)); create table reservations (rate varchar, checkin varchar, checkout varchar, room varchar, PRIMARY KEY (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