CREATE TABLE Rooms (roomName VARCHAR2, RoomId VARCHAR2)
CREATE TABLE Reservations (Room VARCHAR2)

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" "T1" JOIN "Rooms" "T2" ON "T1"."Room" = "T2"."RoomId" GROUP BY "T1"."Room"