select u.room_id
,room_name
,count(distinct user_id) user_count
from user_view_tb u
left join room_info_tb r
on u.room_id = r.room_id
where u.in_time <= '23:59:59' and u.out_time >= '23:00:00'
group by 1,2
order by 3 desc