Return the name and number of reservations made for each of the rooms.
create table reservations (room varchar, PRIMARY KEY (room)); create table rooms (roomname varchar, roomid varchar, PRIMARY KEY (roomname))
select t2.roomname, count(*), t1.room from reservations as t1 join rooms as t2 on t1.room = t2.roomid group by t1.room