Find the name of rooms booked by some customers whose first name contains ROY.
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 FROM reservations AS T1 JOIN rooms AS T2 ON T1.room = T2.roomid WHERE firstname LIKE '%ROY%'
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: Find the name of rooms booked by some customers whose first name contains ROY. ### 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 FROM reservations AS T1 JOIN rooms AS T2 ON T1.room = T2.roomid WHERE firstname LIKE '%ROY%'