题解 | 短视频直播间晚上11-12点之间各直播间的在线人数

select
    u.room_id,
    room_name,
    count(distinct user_id) user_count
from
    user_view_tb u
    join room_info_tb rap on u.room_id = rap.room_id
where
    (
        out_time between time('23:00:00') and time('23:59:59')
    )
    or (
        in_time between time('23:00:00') and time('23:59:59')
    )
group by
    u.room_id,
    room_name
order by
    user_count desc

这样能运行通过，但是令人疑惑的是，如果从23:00之前进入直播间，到凌晨才出去，那么他应该也算在直播间，但是这个where语句却没有包含这种情况也能通过。不禁要问，what can i say?