select
    room_id,
    room_name,
    count(distinct user_id) as user_count
from
    user_view_tb
    left join room_info_tb using (room_id)
WHERE
    in_time <= '23:59:59'
    AND out_time >= '23:00:00'
group by
    room_id,
    room_name
order by user_count desc;