题解 | 短视频直播间晚上11-12点之间各直播间的在线人数
短视频直播间晚上11-12点之间各直播间的在线人数
https://www.nowcoder.com/practice/38f5febc9dac4e9e84ed5891a3e4ca05
-- 题目要求查找各个直播间在线人数，所以主表为room_info_tb
select
r.room_id,
r.room_name,
count(distinct u.user_id) as user_count
from room_info_tb r
left join user_view_tb u
on u.room_id = r.room_id
where
u.in_time <= '23:59:59' and u.out_time >= '23:00:00'
group by
r.room_id,
r.room_name
order by
user_count desc
查看12道真题和解析