List all the room names.
select t2.roomname from reservations as t1 join rooms as t2 on t1.room = t2.roomid
List all the room names with 2 beds.
select t2.roomname from reservations as t1 join rooms as t2 on t1.room = t2.roomid where t2.beds = 2
List all the room names booked with 1 adult.
select t2.roomname from reservations as t1 join rooms as t2 on t1.room = t2.roomid where t1.adults = 1
List all the room names booked with 1 adult and their check in date.
select t2.roomname, t1.checkin from reservations as t1 join rooms as t2 on t1.room = t2.roomid where t1.adults = 1
List all the room names booked with 1 adult and a check in date in October.
select t2.roomname from reservations as t1 join rooms as t2 on t1.room = t2.roomid where t1.adults = 1 and t1.checkin like "%oct%"
List the names of rooms booked by a customer whose first name is Roy.
select t2.roomname from reservations as t1 join rooms as t2 on t1.room = t2.roomid where t1.firstname = "ROY"