
CREATE TABLE "Reservations" (
	"Code" INTEGER, 
	"Room" TEXT, 
	"CheckIn" TEXT, 
	"CheckOut" TEXT, 
	"Rate" REAL, 
	"LastName" TEXT, 
	"FirstName" TEXT, 
	"Adults" INTEGER, 
	"Kids" INTEGER, 
	PRIMARY KEY ("Code"), 
	FOREIGN KEY("Room") REFERENCES "Rooms" ("RoomId")
)


CREATE TABLE "Rooms" (
	"RoomId" TEXT, 
	"roomName" TEXT, 
	beds INTEGER, 
	"bedType" TEXT, 
	"maxOccupancy" INTEGER, 
	"basePrice" INTEGER, 
	decor TEXT, 
	PRIMARY KEY ("RoomId")
)

CREATE TABLE "Reservations" (
	"Code" INTEGER, 
	"Room" TEXT, 
	"CheckIn" TEXT, 
	"CheckOut" TEXT, 
	"Rate" REAL, 
	"LastName" TEXT, 
	"FirstName" TEXT, 
	"Adults" INTEGER, 
	"Kids" INTEGER, 
	PRIMARY KEY ("Code"), 
	FOREIGN KEY("Room") REFERENCES "Rooms" ("RoomId")
)

/*
2 rows from Reservations table:
Code	Room	CheckIn	CheckOut	Rate	LastName	FirstName	Adults	Kids
10105	HBB	23-OCT-10	25-OCT-10	100.0	SELBIG	CONRAD	1	0
10183	IBD	19-SEP-10	20-SEP-10	150.0	GABLER	DOLLIE	2	0
*/


CREATE TABLE "Rooms" (
	"RoomId" TEXT, 
	"roomName" TEXT, 
	beds INTEGER, 
	"bedType" TEXT, 
	"maxOccupancy" INTEGER, 
	"basePrice" INTEGER, 
	decor TEXT, 
	PRIMARY KEY ("RoomId")
)

/*
2 rows from Rooms table:
RoomId	roomName	beds	bedType	maxOccupancy	basePrice	decor
RND	Recluse and defiance	1	King	2	150	modern
IBS	Interim but salutary	1	King	2	150	traditional
*/
Find the most popular room in the hotel. The most popular room is the room that had seen the largest number of reservations.
SELECT T2.roomName FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T1.Room ORDER BY count(*) DESC LIMIT 1;
[{'roomName': 'Convoke and sanguine'}]