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

SELECT
    b.room_id,b.room_name,
    COUNT(DISTINCT a.user_id) AS user_count
FROM user_view_tb AS a
INNER JOIN room_info_tb AS b
    ON (a.room_id = b.room_id)
WHERE a.in_time >= '23:00:00'
    OR a.out_time >= '23:00:00'
GROUP BY b.room_id,b.room_name
ORDER BY user_count DESC;