Below is an instruction that describes a task, paired with an input that provides further context. Write a response that appropriately completes the request.

### Instruction:

Convert text to sql: Return the name, rate, check in and check out date for the room with the highest rate. | rooms : roomid , roomname , beds , bedtype , maxoccupancy , baseprice , decor | reservations : code , room , checkin , checkout , rate , lastname , firstname , adults , kids | reservations.room = rooms.roomid | 

### Response:

select _ from _ group by _ order by _ desc limit _ | select rooms.roomname , reservations.rate , reservations.checkin , reservations.checkout from reservations join rooms on reservations.room = rooms.roomid group by reservations.room order by reservations.rate desc limit 1