What is the first name of Reservations Code 10105?
select firstname from reservations where code = 10105
What is the last name of Reservations Code 10105?
select lastname from reservations where code = 10105
Can you show the names of rooms that have been reserved for more than 60 times
select t2.roomname from reservations as t1 join rooms as t2 on t1.room = t2.roomid group by t1.room having count ( * ) > 60