yes
select t1.lastname from reservations as t1 join rooms as t2 on t1.room = t2.roomid where t2.roomid = "IBS"
yes
select bedtype from rooms where roomid = "HBB"
what is the check in and check out of the room id RND ?
select t1.checkin, t1.checkout from reservations as t1 join rooms as t2 on t1.room = t2.roomid where t2.roomid = "RND"
Find the most popular room in the hotel. The most popular room is the room that had seen the largest number of reservations.
select t2.roomname from reservations as t1 join rooms as t2 on t1.room = t2.roomid group by t1.room order by count ( * ) desc limit 1