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