id	room_id	user_id
1	5	10
2	5	20
3	5	20
4	6	30
5	6	40
6	6	50
7	7	10
8	7	10
9	8	20
10	9	10
11	9	10
12	9	10
13	5	20
room_id	total_bookings	total_renewal	renewal_rate
9	3	2	66.6667
5	4	2	50.0000
7	2	1	50.0000
6	3	0	0.0000
8	1	0	0.0000