Database: inn_1
Question: What are the name of rooms booked by customers whose first name has "ROY" in part?
SQL:
SELECT T2.roomName FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId WHERE firstname LIKE '%ROY%'