CREATE TABLE reservations (code DECIMAL, room TEXT, checkin TEXT, checkout TEXT, rate DECIMAL, lastname TEXT, firstname TEXT, adults DECIMAL, kids DECIMAL)
CREATE TABLE rooms (roomid TEXT, roomname TEXT, beds DECIMAL, bedtype TEXT, maxoccupancy DECIMAL, baseprice DECIMAL, decor TEXT)

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"