题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
短视频直播间晚上11-12点之间各直播间的在线人数
https://www.nowcoder.com/practice/38f5febc9dac4e9e84ed5891a3e4ca05
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;
