Database: inn_1
Question: For each room, find its name and the number of times reservations were made for it.
SQL:
SELECT T2.roomName ,  count(*) ,  T1.Room FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T1.Room