select room_id,
max(room_name),
count(distinct user_id) as user_count
from user_view_tb
join room_info_tb using(room_id)
where out_time>='23:00:00'
group by room_id	
order by user_count desc