SELECT T2.roomName ,  count(*) ,  T1.Room FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T1.Room
Return the name and number of reservations made for each of the rooms.
SELECT T2.roomName , count ( * ) , T1.Room FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room = T2.RoomId GROUP BY T1.Room
select t2 . roomname , count ( * ) , t1 . room from reservations as t1 join rooms as t2 on t1 . room = t2 . roomid group by t1 . room
Return the name and number of reservations made for each of the rooms .