题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
短视频直播间晚上11-12点之间各直播间的在线人数
https://www.nowcoder.com/practice/38f5febc9dac4e9e84ed5891a3e4ca05
SELECT
user_view_tb.room_id,
ANY_VALUE(room_name),
COUNT(DISTINCT user_id) user_count
FROM room_info_tb JOIN user_view_tb
ON room_info_tb.room_id = user_view_tb.room_id
WHERE HOUR(in_time) BETWEEN 23 AND 24
OR HOUR(out_time) BETWEEN 23 AND 24
GROUP BY user_view_tb.room_id
ORDER BY user_count DESC
