For each room, find its name and the number of times reservations were made for it.
select t2.roomname, count(*), t1.room from reservations as t1 join rooms as t2 on t1.room = t2.roomid group by t1.room