CREATE TABLE Rooms (roomName VARCHAR2, RoomId VARCHAR2)
CREATE TABLE Reservations (Room VARCHAR2)

Find the name of rooms booked by some customers whose first name contains ROY.
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" "T1" JOIN "Rooms" "T2" ON "T1"."Room" = "T2"."RoomId" WHERE "firstname" LIKE '%ROY%'