Find the reservations made by customers whose first name has "ROY" in part.
select * from reservations where firstname like '%roy%'
What rooms were booked by these customers?
select * from reservations as t1 join rooms as t2 on t1.room = t2.roomid where firstname like '%roy%'
What are the names of these rooms?
select t2.roomname from reservations as t1 join rooms as t2 on t1.room = t2.roomid where firstname like '%roy%'