Which room has the highest rate? List the room's full name, rate, check in and check out date.
CREATE TABLE rooms (
    roomid text,
    roomname text,
    beds number,
    bedtype text,
    maxoccupancy number,
    baseprice number,
    decor text
)

CREATE TABLE reservations (
    code number,
    room text,
    checkin text,
    checkout text,
    rate number,
    lastname text,
    firstname text,
    adults number,
    kids number
)
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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Which room has the highest rate? List the room's full name, rate, check in and check out date. ### Input: CREATE TABLE rooms (
    roomid text,
    roomname text,
    beds number,
    bedtype text,
    maxoccupancy number,
    baseprice number,
    decor text
)

CREATE TABLE reservations (
    code number,
    room text,
    checkin text,
    checkout text,
    rate number,
    lastname text,
    firstname text,
    adults number,
    kids number
) ### Response: 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