SELECT T2.roomName FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId WHERE firstname LIKE '%ROY%'
What are the name of rooms booked by customers whose first name has "ROY" in part?
SELECT T2.roomName FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room = T2.RoomId WHERE firstname LIKE ' % ROY % '
select t2 . roomname from reservations as t1 join rooms as t2 on t1 . room = t2 . roomid where firstname like value
What are the name of rooms booked by customers whose first name has `` ROY '' in part ?